Asset Management Suite

Hi,

I need some assistance in putting together SQL query report in Altiris 7.1 that will have the following fields but better if I can enter Software Name is = "Xyz"

• Software Name
• Software Version
• Install Date
• Comuter Name
• OS Name
• OS Type
• Software Status

Go through these thread

https://www-secure.symantec.com/connect/forums/report-installed-software-products-and-install-date

https://www-secure.symantec.com/connect/forums/how-get-report-altiris-71

Inbuilt report location

Reports > All Reports, then expand Reports > Discovery and Inventory > Inventory > Cross-platform > Software/Applications > Installed Software or Installed Software by Computer.  For example, using the Installed Software report, type '%Adobe%' for the Company OR '%Lync%' for the Name.

Thanks for the details Summit G. The reports listed there dont show the fileds I'm looking for which I listed below and looks like i need help customise SQL report to get that data. I'm new to SQL and Altiris so any helps is appreciated.

• Software Name
• Software Version
• Install Date
• Comuter Name
• OS Name
• OS Type
• Software Status

The reports dont show the fileds I'm looking for which I listed below and looks like i need help customise SQL report to get that data. I'm new to SQL and Altiris so any helps is appreciated. Can someone provide SQL query for the a report in Altiris that will have the information below:

• Software Name
• Software Version
• Install Date
• Comuter Name
• OS Name
• OS Type
• Software Status

Anyone able to provide input on SQL query for the report with specific fields that can show the Software Name, Software Version, Install Date, Computer Name, OS Name, Software Status.  Thanks.

Again the SQL query report I'm looking for with all the fileds needed are listed below. We are running Altiris SMP 7.1.   Please advise and thanks for your time.

What is Software Status?

This uses Add/Remove Programs.

SELECT arp1.DisplayName, arp1.DisplayVersion, arp1.InstallDate, c1.Name AS 'Computer', id1.[OS Name], id1.[OS Type]
FROM vRM_Computer_Item c1
JOIN Inv_AddRemoveProgram arp1 ON c1.Guid = arp1._ResourceGuid
JOIN Inv_AeX_AC_Identification id1 ON c1.Guid = id1._ResourceGuid

Marking split solution here as user abandoned post. Sumit G gave links to useful reports and EathenR tried his best to answer the question exactly as poster rquested.

Need SQL query report I'm looking for with all the fileds needed are listed below. We are running Altiris SMP 7.1.   Please advise and thanks for your time.

SELECT arp1.DisplayName, arp1.DisplayVersion, arp1.InstallDate, c1.Name AS 'Computer', id1.[OS Name], id1.[OS Type]
FROM vRM_Computer_Item c1
JOIN Inv_AddRemoveProgram arp1 ON c1.Guid = arp1._ResourceGuid
JOIN Inv_AeX_AC_Identification id1 ON c1.Guid = id1._ResourceGuid
WHERE arp1.DisplayName LIKE '%chekpoint%'

Thank you Eathen for your information which resolved this issue, greatly appreciate it.