topic Re: xpinfo output in XP Storage

xpinfo output

Julian Campbell — Sat, 03 May 2003 20:34:29 GMT

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.

Re: xpinfo output

Michael Tully — Sun, 04 May 2003 21:32:02 GMT

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.

Re: xpinfo output

Jon Hill_3 — Mon, 05 May 2003 12:20:25 GMT

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.

Re: xpinfo output

Julian Campbell — Mon, 05 May 2003 14:31:26 GMT

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.

Re: xpinfo output

Michael Steele_2 — Mon, 05 May 2003 17:30:38 GMT

'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.

Re: xpinfo output

Julian Campbell — Tue, 06 May 2003 16:33:59 GMT

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.

Re: xpinfo output

Jon Hill_3 — Tue, 06 May 2003 20:38:10 GMT

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.

Re: xpinfo output

Julian Campbell — Tue, 06 May 2003 21:17:45 GMT

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?