HP SIM and "All Servers" default page SQL query or View?

[Gavin Smith (NZ)]

I wish to use the sql query or view used by "All Servers" default page so I can run an external report.

Does any one know what this is or where I could find out?

Thanks

[LukaS_9]

Hi,
if you need to have this info in textual mode, you can use mxnode command in /opt/mx/bin.
With -lt parameter it display some info, but not the type of system (so you cannot add |grep "Server" for example).
Probably you have to create a script cycling on all systems returned by
mxnode -ln
and check if
mxnode -ld |grep -i "Device type: Server"
return something. Does it make sense?

Luca

[David Claypool]

The easiest way to get what you want would be to create an HP SIM report with 1 field in it (so you can easily identify and eliminate it) and run it against the All Servers collection. Then in the report select 'Show SQL query' and cut, paste and edit as necessary...

[Gavin Smith (NZ)]

Thanks guysâ ¦

Spent a few hours today going through each of the views and reports to better understand the relationships between the tables and data.