Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Gavin Smith (NZ)
Occasional Contributor

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

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
3 REPLIES
LukaS_9
Regular Advisor

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

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
Honored Contributor

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

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)
Occasional Contributor

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

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.