Relevance: New Line Problems

("Disk: " & preceding text of first "," of it & ", Firmware: " & preceding text of first "," of following text of first "," of it & ", Model: " & preceding text of first "," of following text of first "," of following text of first "," of it & ", Adpname: " & preceding text of first "," of following text of first "," of following text of first "," of following text of first "," of it & ", Affected: " & preceding text of first "," of following text of first "," of following text of first "," of following text of first "," of following text of first "," of it) of lines whose (line number of it > 1) of file "/tmp/disk_firmware_check.out"

This is the relevance I’m using to return data however I get it retuned like this in Web Reports…

Disk: 1I:3:1 Firmware: HPD4 Model: HP EH0600JEDHE Adpname: Smart Array P840ar Affected: UN-Affected Model

Disk: 1I:3:2 Firmware: HPD4 Model: HP EH0600JEDHE Adpname: Smart Array P840ar Affected: UN-Affected Model

Disk: 1I:3:3 Firmware: HPD4 Model: HP EH0600JEDHE Adpname: Smart Array P840ar Affected: UN-Affected Model

I’m struggling to get each row onto its own line - any help please?

Are you able to give us a sample of the formatting of the disk_firmware_check.out file?

Disk,Firmware,Model,Adpname,Affected

1I:3:1, HPD4, HP EH0600JEDHE,Smart Array P840ar,UN-Affected Model,

1I:3:2, HPD4, HP EH0600JEDHE,Smart Array P840ar,UN-Affected Model,

1I:3:3, HPD4, HP EH0600JEDHE,Smart Array P840ar,UN-Affected Model,

I’m not sure I understand, it looks like each result is already on its own line here…this is probably the only time I’d ask this, but… can you paste a screenshot instead of the text?

OH I get it, I think.

So what you’ve posted is the client relevance that fills out a property, but when you report that property in Web Reports all the results are in one cell.

Like in my screenshot, ‘rhel-sv1.domain.home’ has two IP addresses in a single cell:

In the ‘Edit Columns’ dialog, click the ‘+’ symbol beside that column name to expand the plural results into multiple rows:

That will split the result into multiple rows

Not quite :sweat_smile:

I need it like this

Disk: 1I:3:1
Firmware: HPD4
Model: HP EH0600JEDHE
Adpname: Smart Array P840ar
Affected: UN-Affected Model

Ok, for that I think the easiest path is to change the Client Relevant to return these as plural results then.

q: ("Disk: " & preceding text of first "," of it ; "Firmware: " & preceding text of first "," of following text of first "," of it ; "Model: " & preceding text of first "," of following text of first "," of following text of first "," of it ; "Adpname: " & preceding text of first "," of following text of first "," of following text of first "," of following text of first "," of it ; "Affected: " & preceding text of first "," of following text of first "," of following text of first "," of following text of first "," of following text of first "," of it) of lines whose (line number of it > 1 and it as trimmed string != "") of file "c:\temp\disk_firmware_check.out"
A: Disk: 1I:3:1
A: Firmware:  HPD4
A: Model:  HP EH0600JEDHE
A: Adpname: Smart Array P840ar
A: Affected: UN-Affected Model
A: Disk: 1I:3:2
A: Firmware:  HPD4
A: Model:  HP EH0600JEDHE
A: Adpname: Smart Array P840ar
A: Affected: UN-Affected Model
A: Disk: 1I:3:3
A: Firmware:  HPD4
A: Model:  HP EH0600JEDHE
A: Adpname: Smart Array P840ar
A: Affected: UN-Affected Model

I basically changes several of your concatenations ’ & ’ into plurals ’ ; ’ and removed the commas between. Do you think that would do what you like?

1 Like