List Version Control Agent status

[Tom Bate]

Is there any way to use the Version Control Repository Manager to create a list of servers that are running the agent and what level they are at?

[Rancher · Accepted solution]

You can do this though the Reports option in SIMS, under General, Software. Unfortuntely this will show all HP software installed. I don't know of any other way to get this information.

[Rob Buxton]

I run a report manually from the HPSIM Database to get an idea of the PSP by looking at the Foundation Agents, here's the SQL. Not quite what you're after but you'll get the idea.

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

You can also just use the reporting mentioned above and then sort it by the description, that will at least group what you want.