("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?
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?
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:
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?