xpinfo output

[Julian Campbell]

Whats the best way to format the output from xpinfo so I can import it to an excel spread sheet? I want each field as a column format. If you have a formatting script of this kind I would appreciate the help.

[Michael Tully]

A lot of people aren't going to know what this output looks like, perhaps you could provide an example we may be able to assist with the scripting part.

[Jon Hill_3 · Accepted solution]

Are you referring to xpinfo -i or xpinfo without parameters? I generally get all I need from xpinfo -i, which I redirect to a text file and import into Excel as fixed-width.

I use the following Excel VBA code when I want to automate it:

strFileName = "c:\myfile.txt"
Workbooks.OpenText strFileName, _
Origin:=xlWindows, StartRow:=6, DataType:=xlFixedWidth, FieldInfo:= _
Array(Array(0, 2), Array(22, 2), Array(24, 2), Array(28, 2), _
Array(32, 2), Array(36, 2), Array(41, 2), Array(49, 2), Array(66, 1))

You could probably also import it as a delimited text file and use space as the delimiter.

[Julian Campbell]

John, points for you my friend. Perfect, just what I wanted. Do you have a man page for xpinfo? I was unaware of the -i option.

[Michael Steele_2]

'xpinfo' is provided to CU's via the XP disk array cdrom. Note the readme file.

HP's has Storage Solutions Architects who provide these tools they don't usually come by way of the O/S.

[Julian Campbell]

I couldn't find it on the hp storageworks disk array xp1024 cd. Is this the right one? If so what directory is it under and name? Could anyone attach the readme file please.

[Jon Hill_3]

xpinfo is provided by the Response Center but not otherwise supported, afaik. I got my copy from my ASE.

xpinfo -? gives you a little info, but I found a downloadable shell file (http://aa11.cjb.net/hpux_admin/2000/11/bin0000.bin) that, when sh'd, installs what I assume is an old version of xpinfo. Install this on a UX box not connected to the san, then you can do a man.

Oh, that's just dumb. I redirected the man output to a text file, which I have attached. Please excuse the formatting codes.

[Julian Campbell]

Many thanks Jon for taking the trouble to dig this out. Is it just me or is the lack of an all inclusive provisioning tool a problem to most people? How does everyone else map xpinfo information to configured vg's, lvols and mount points on the system side? Does everyone use spread sheet to track the information and are there no other short cuts? I've been matching xpinfo to vgdisplay and lvdisplay but when you have 300 Luns to do it gets very tedious. Any suggestions?