What Queries Populate "Software Summary" for Resource Manager?

Products

• Software Management Solution
• IT Management Suite

Issue/Introduction

Question:

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

Note: The direct link for this page on the Notification Server is for example (just replace the GUID for the desired machine):
http://localhost/Altiris/Inventory/SoftwareSummary.aspx?Type=full&ResourceGuid=<GUID OF COMPUTER>

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 three reports using the stored procedures above.