HP HTTP Server / System Management Homepage

[Jon_151]

Is there a way to tell what version of the HP HTTP Server or System Management Homepage a server is running using HPSIM?

[Rob Buxton]

I once wrote a script that pulled the data out of the HPSIM database and formatted a web page.

This gave me the level of PSP Foundation Agent but didn't get to the level of the HP SMH.

The basic SQL was;
select CAST(R_Software.DeviceName AS char(20)), CAST(R_Software.Version AS char(24))
from R_Software
WHERE (R_Software.Description LIKE '%Foundation Agents Service%' OR R_Software.Description LIKE '%Insight Management Agents%')
AND (R_Software.SnapShotID=-1)
order by R_Software.DeviceName ASC

Also if you ran a standard HPSIM report on Software, you can then sort by Description.

[Jon_151]

Thanks Rob, You the man!

[Jon_151]

Thanks again.