What Queries Populate "Software Summary" for Resource Manager?

book

Article ID: 195306

calendar_today

Updated On:

Products

Software Management Solution Management Platform (Formerly known as Notification Server)

Issue/Introduction

Question:

What queries populate the Resource Manager>Summaries>Software Summary?



Note: The direct link for this page is for example (just replace the GUID for the desired machine):
http://localhost/Altiris/Inventory/SoftwareSummary.aspx?Type=full&ResourceGuid=7247bd7a-ec70-4e9e-b4d0-cdf442ec7d3c

Environment

ITMS 8.5

Resolution

These panels are actually populated by stored procedures. These are the ones:

For "Installed Software":
EXECUTE sp_Inv_GetInstalledSoftwareData @ResourceGuid='7247bd7a-ec70-4e9e-b4d0-cdf442ec7d3c'

For "Add Remove Program":
EXECUTE sp_Inv_GetAddRemoveProgramData @ResourceGuid='7247bd7a-ec70-4e9e-b4d0-cdf442ec7d3c'

For "Installed File Details":
EXECUTE sp_Inv_GetInstalledFileDetails @ResourceGuid='7247bd7a-ec70-4e9e-b4d0-cdf442ec7d3c'


Note: Just replace the GUID for the desired machine.

 

Also, if you want to create custom reports using these stored procedures, attached is an example of 3 reports using the stored procedures above.

Attachments

1595611019904__Support-SoftwareSummaries.xml get_app