HPE Storage Users Group :: View topic - Grabbing 3PAR Config info

@ECHO OFF
:: ==============================================
:: Name : 3PAR_COLLECT.bat
:: Desc : Pulls config data from 3PAR to csv
:: Version : 2.1
::
:: Dependencies : OS: Windows XP/Vista/2003/2008/7
::    : 3PAR Inform CLI
::    : HOSTNAMES_TO_COLLECT file exists and contains list of 3PAR hostnames
::
::
:: History: v 1.0 initial release
::    v 1.1 added showld -p
::    v 2.0 made script multi-system capable
::       script will prompt/create missing pwfiles
::    V 2.1 Bugfixes
::
:: ==============================================

FOR /F %%i in (HOSTNAMES_TO_COLLECT) do call :Begin %%i
echo ::: 3PAR Collection Script Completed
goto :END

:Begin
echo ::: %1
set TPDSYSNAME=%1
set TPDPWFILE=%1.pwfile
set TPDCSVTABLE=1
set OUTPUTDIR=%TPDSYSNAME%
set PATH=C:\Program Files (x86)\inform_cli_3.2.1\bin;%PATH%
if NOT exist %OUTPUTDIR% mkdir %OUTPUTDIR%
if NOT exist %TPDPWFILE% call setpassword -saveonly -file %TPDPWFILE%
echo ::: Collecting from %1 ...

call showsys >%OUTPUTDIR%\sys.csv
call showsys -space >%OUTPUTDIR%\sysspace.txt
call showversion > %OUTPUTDIR%\version.txt
call shownode > %OUTPUTDIR%\node.csv
call shownodeenv > %OUTPUTDIR%\nodeenv.txt
call shownode -ps > %OUTPUTDIR%\node_ps.csv
call showcage > %OUTPUTDIR%\cage.csv
call showpd > %OUTPUTDIR%\pd.csv
call showpd -i > %OUTPUTDIR%\pd_i.csv
call showpd -c > %OUTPUTDIR%\pd_c.csv
call showpd -space > %OUTPUTDIR%\pd_space.csv
call showld > %OUTPUTDIR%\ld.csv
call showld -d > %OUTPUTDIR%\ld_d.csv
call showld -p > %OUTPUTDIR%\ld_p.csv
call showport > %OUTPUTDIR%\port.csv
call showport -c > %OUTPUTDIR%\port_c.csv
call showhost > %OUTPUTDIR%\host.csv
call showhost -d > %OUTPUTDIR%\host_d.csv
call showcpg > %OUTPUTDIR%\cpg.csv
call showcpg -d > %OUTPUTDIR%\cpg_d.csv
call showvv -rcopy > %OUTPUTDIR%\vv.csv
if ERRORLEVEL 1 call showvv > %OUTPUTDIR%\vv.csv
call showvv -cpgalloc > %OUTPUTDIR%\vv_cpgalloc.csv
call showvlun > %OUTPUTDIR%\vlun.csv
call showvlun -a > %OUTPUTDIR%\vlun_a.csv
call showdate > %OUTPUTDIR%\showdate.txt
call showfirmwaredb > %OUTPUTDIR%\firmwaredb.csv
call showlicense > %OUTPUTDIR%\license.txt
call showspare > %OUTPUTDIR%\spare.csv
call showspace -cpg * > %OUTPUTDIR%\space.csv
call showtoc > %OUTPUTDIR%\toc.txt
echo ::: Collection complete for %1

:END

Author:	adamdb [ Fri Oct 19, 2018 6:43 am ]
Post subject:	Grabbing 3PAR Config info
Hi all, I've been asked to document a load of 3PAR systems for a new customer. So this means running a load of CLI to gather the config. It's then i remembered that this stuff gets done on the SP automatically and uploaded. After some googling I found the following documunt. https://support.hpe.com/hpsc/doc/public ... kc-0126495 Its basically the process to get these files off manually. I'm guessing this bz2 (Tar file ) i believe will contain all sorts of useful output. I had two questions off the back of this. 1. How do you get this info out of a 5.x SP which now looks quite different. Haven't found it so far but I'll keep looking. <edit - located the files dialogue - now need to try a few different files. 2. I notice that on NinjaStars (https://saf.itcs.hpe.com/safdesktop/info/stars/) there's an option to import BZ2 config files for 3PAR. Does anyone know if you can use the exports from the SP and import them into NinjaStars to give you a nice summary of what the hardware is. Definitely useful when producing documentation that's for sure. Anyhow, any advice appreciated. If it's a case of running a whole load of 'show' commands fair enough but figured it was worth asking. < update > got some files off an 5.x SP. Took a collection (SRDATA) File. Seems to contains some text and .db files which sadly are not importable to NinjaStars. It looks like an SQLLite Database file so may try importing it into that. .... and yes the files are SQLite format. Having unpacked the SRDATA i end up with two .db files called SRMain and Export_HiRes. Export_HiRes does indeed contain lots of stat output which you can interrogate with your favourite DB tool. Now just need to find which one of these contains other useful data. If the meantime and useful advice welcome. thanks Ad

Author:	Richard Siemers [ Fri Oct 19, 2018 11:20 pm ]
Post subject:	Re: Grabbing 3PAR Config info
This is old, provided as-is, but may help give you some ideas. This is something I wrote quite a few years back in windows CLI. Code: @ECHO OFF :: ============================================== :: Name : 3PAR_COLLECT.bat :: Desc : Pulls config data from 3PAR to csv :: Version : 2.1 :: :: Dependencies : OS: Windows XP/Vista/2003/2008/7 :: : 3PAR Inform CLI :: : HOSTNAMES_TO_COLLECT file exists and contains list of 3PAR hostnames :: :: :: History: v 1.0 initial release :: v 1.1 added showld -p :: v 2.0 made script multi-system capable :: script will prompt/create missing pwfiles :: V 2.1 Bugfixes :: :: ============================================== FOR /F %%i in (HOSTNAMES_TO_COLLECT) do call :Begin %%i echo ::: 3PAR Collection Script Completed goto :END :Begin echo ::: %1 set TPDSYSNAME=%1 set TPDPWFILE=%1.pwfile set TPDCSVTABLE=1 set OUTPUTDIR=%TPDSYSNAME% set PATH=C:\Program Files (x86)\inform_cli_3.2.1\bin;%PATH% if NOT exist %OUTPUTDIR% mkdir %OUTPUTDIR% if NOT exist %TPDPWFILE% call setpassword -saveonly -file %TPDPWFILE% echo ::: Collecting from %1 ... call showsys >%OUTPUTDIR%\sys.csv call showsys -space >%OUTPUTDIR%\sysspace.txt call showversion > %OUTPUTDIR%\version.txt call shownode > %OUTPUTDIR%\node.csv call shownodeenv > %OUTPUTDIR%\nodeenv.txt call shownode -ps > %OUTPUTDIR%\node_ps.csv call showcage > %OUTPUTDIR%\cage.csv call showpd > %OUTPUTDIR%\pd.csv call showpd -i > %OUTPUTDIR%\pd_i.csv call showpd -c > %OUTPUTDIR%\pd_c.csv call showpd -space > %OUTPUTDIR%\pd_space.csv call showld > %OUTPUTDIR%\ld.csv call showld -d > %OUTPUTDIR%\ld_d.csv call showld -p > %OUTPUTDIR%\ld_p.csv call showport > %OUTPUTDIR%\port.csv call showport -c > %OUTPUTDIR%\port_c.csv call showhost > %OUTPUTDIR%\host.csv call showhost -d > %OUTPUTDIR%\host_d.csv call showcpg > %OUTPUTDIR%\cpg.csv call showcpg -d > %OUTPUTDIR%\cpg_d.csv call showvv -rcopy > %OUTPUTDIR%\vv.csv if ERRORLEVEL 1 call showvv > %OUTPUTDIR%\vv.csv call showvv -cpgalloc > %OUTPUTDIR%\vv_cpgalloc.csv call showvlun > %OUTPUTDIR%\vlun.csv call showvlun -a > %OUTPUTDIR%\vlun_a.csv call showdate > %OUTPUTDIR%\showdate.txt call showfirmwaredb > %OUTPUTDIR%\firmwaredb.csv call showlicense > %OUTPUTDIR%\license.txt call showspare > %OUTPUTDIR%\spare.csv call showspace -cpg * > %OUTPUTDIR%\space.csv call showtoc > %OUTPUTDIR%\toc.txt echo ::: Collection complete for %1 :END

HPE Storage Users Group https://3parug.com/

Grabbing 3PAR Config info https://3parug.com/viewtopic.php?f=18&t=3014	Page 1 of 1

Page 1 of 1	All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/