Software Reporting and Count?

sixdollarshirt · 06-03-2009, 09:12 AM

I hope this is in the correct forum. If not will a mod please move it to the correct one.

I'm trying to create a SQL query that will show me the names and versions of all Adobe products installed in our environment. Honestly I was having a problem with the report builder so I went straight to the SQL query.

This is what I have right now.

Code:

SELECT DISTINCT description, publisher, version FROM dbo.application WHERE publisher LIKE 'Adobe%' AND description <> ''

This works fine and returns the information, but I can't figure out how to get a count of how many computers each application is installed on and perhaps the name of the computer. I have been unable to find the correct table holding that information.

I'm running NS 6.0 and appreciate any help you can offer.

Thanks in advance. Your help is appreciated.

sixdollarshirt · 06-03-2009, 10:59 AM

I couldn't be more stupid. Looking in the eXpress database instead of Altiris. Sorry for the bother.

Nick · 06-03-2009, 11:34 AM

No worries we all have days like that.

You may want to check the file repository out, under the reports section. There are several custom reports there that you may find useful.

sixdollarshirt · 06-03-2009, 12:56 PM

Thanks Nick. I appreciate the help. I did find something that looks like it would work or I could edit it to work. However, I'm not sure how to import an XML report into NS or if it's even possible. Am I just being a dummy?