HP StorageWorks Fabric Manager 5.x Administrator Guide (AA-RUQSF-TE, September 2005)

222 Creating reports
4. Click OK.
The Microsoft Excel program is launched. Fabric information is gathered and displayed in the
spreadsheet.
To generate the Physical Inventory report:
1. Change directory to <install_dir>\reports\excel\PhysicalInventoryExcelReport.
2. Double-click Physical Inventory Excel Report.exe.
The Physical Inventory Excel Report dialog box opens. See Figure 157 on page 221.
3. Select which fabric or switch to report on:
• To generate a summary report for all fabrics and switches, select All Fabrics.
• To generate a summary report for a single fabric or switch, select Fabric or Switch and then enter its
IP, WWN, name, or domain.
4. Click OK.
The Microsoft Excel program is launched. Fabric information is gathered and displayed in the
spreadsheet.
Using the SQL queries
Included in your Fabric Manager installation are SQL queries that you can use to retrieve information from
the database (see Table 23).
These queries are located in
<install_dir>\reports\excel\PhysicalInventoryExcelReport.
Changing the report server
Reports are generated based on the Fabric Manager server ODBC setting defined during installation. If
you want to generate reports from a different server:
1. Using a text editor, open the install_odbc.bat file located under <install_dir>\odbc.
Here is an example of such a file:
call C:\FabricManager\odbc\asa_config.bat
echo Installing ODBC driver DSN
dbdsn -y -w FabricManagerODBC -c
"uid=dba;pwd=sql;ASTART=no;ASTOP=no;eng=fabman;CommLinks=tcpip{DOBROADCAST=DIRECT
;HOST=localhost;ServerPort=2638}"
2. Change the HOST value to the new server’s IP address.
3. Save and exit.
Table 23 Included SQL queries
Use this query: To find:
findAllSFPsOfModelXXX.sql SFPs of certain model organized by switches and ports
findAllFailingFans.sql Failing fans in the entire managed SAN
findPartNumbersOfAllSwitches.sql Part numbers of all switches