BigFix Analysis to fetch line between to patterns

1

As script is writting an output to the text file and the text file looks like below ,

**“XIV Devices”;
"Device Size (GB) Paths Vol Name Vol ID XIV ID XIV Host ";

“\.\PHYSICALD 120.5 8/8 usculcv01_SW_ 9736 7861175 usculcv01”; “RIVE1 cache
”\.\PHYSICALD 51.6 8/8 XIV07_usculcv 5546 7861175 usculcv01"; “RIVE2 01_index_cach
”\.\PHYSICALD 327.0 10/10 XIV12_USCULCV 11931 7825824 USCULCV01"; "RIVE3 01_DATA_01

“Non-XIV Devices”;
“Device Size (GB) Paths”;

"\.\PHYSICALDRIVE0 255.0 N/A ";

"\.\PHYSICALDRIVE4 32.2 8/8 ";

"\.\PHYSICALDRIVE5 53.7 8/8 ";

I have written an analysis to fetch Contents of line of .txt file between pattern1 & pattern2 like below ,

preceding texts of lasts “RIVE” of following texts of firsts “\” of lines whose(it contains “\” AND (following text of first " " of it contains “RIVE”)) of files whose((name of it ends with “.txt”) AND (exists line whose(it contains “\” AND (following text of first " " of it contains “RIVE”)) of it)) of folder “C:\temp”

I could get the output as below ,

.\PHYSICALD 120.5 8/8 usculcv01_SW_ 9736 7861175 usculcv01"; “
.\PHYSICALD 51.6 8/8 XIV07_usculcv 5546 7861175 usculcv01”; “
.\PHYSICALD 327.0 10/10 XIV12_USCULCV 11931 7825824 USCULCV01”; "

Is it possible to store this value in each column ?

2

It’s possible to store them as multiple/plural results of one property (column) as it is.

I’m not sure what you mean by multiple columns…you’d need to create the properties (columns) first, and have some criteria for dividing them.

Would you be trying to have one property for PHYSICALDRIVE0, another for PHYSICALDRIVE1, etc.? That’s possible, but you’d have to predict the total number of physicaldrives first.

Another option we sometimes use is to concatenate the plural results together so they come back as one result, for example concatenation "|" of....

3

Hi Jason ,
Thank you response.
for the below line ,
".\PHYSICALDRIVE4 32.2 8/8 ";
I would need to have one property for .\PHYSICALDRIVE4 ,one property for 32.2 and another Property for 8/8 .
Is it possible ?

4

Oh, I see…yes, it’s possible.

Keeping your original query, you might try having the first property as preceding texts of firsts " " of (your query) , the second property preceding texts of firsts " " following texts of firsts " " of (your query), and so on.

I’m on a phone now, but if you have some difficulty with that then post back and I can write up a more complete example from my PC later.