Software Installed Inventory

Newbie · 06-20-2005, 04:19 PM

I have created a simple report to generate all software installed. (I selected add remove progerams ) table. Now I'm getting over 6000 Rows returned , arround 100 for each machine. The report lists every Executable as an application installed. Any way to narrow the search to just what the Add remove program displays,.

Thanks

Ray · 06-21-2005, 11:59 AM

There is canned reports you can run. view the gif file for example.

Newbie · 06-21-2005, 04:14 PM

Thanks Ray , for some reason My repot Is generating a list of all applications Installed Like 699 per Machine (looks like it scanned the Drive for all executables and reported it as installed applicaton. I'll go over the configuration agatin to see if there is something I missed. thanks

Tom.Reyntjens · 07-01-2005, 11:52 AM

This query should give you all Add/Remove Programs entries for each computer :

select vc.Name, arp.Name
from vcomputer vc
join Inv_AeX_OS_Add_remove_programs arp on arp._ResourceGuid=vc.Guid
order by vc.Name, arp.Name

Ray · 07-05-2005, 02:36 PM

Looks good but I wonder if there is a way to summary this. like have the list of pc's then have the drill down to display this for that device.

Tom.Reyntjens · 07-06-2005, 12:55 PM

Looking for something like this ?

Ray · 07-08-2005, 12:30 PM

Looks great Tom once again I must Bow down.

lenmessing · 08-10-2006, 06:59 PM

I want to modify the query you guys posted to run against collections, but am unable to get the JOIN statement to work

select vc.Name, arp.Name
from vcomputer vc
join Inv_AeX_OS_Add_remove_programs arp on arp._ResourceGuid=vc.Guid
order by vc.Name, arp.Name

What do I need to add?

Nick · 08-10-2006, 07:56 PM

See if this doesn't help you.

Code:

SELECT vc.[Name], arp.[Name]
FROM vcomputer vc, Inv_AeX_OS_Add_remove_programs arp
WHERE arp._ResourceGuid=vc.Guid
ORDER BY vc.[Name], arp.[Name]

You may also want to look HERE for some tips on writing SQL queries.

coateshire · 08-10-2006, 11:57 PM

Hi,

Thanks for the Software Inventory Report. It works like a charm. I am wondering if there is a similar report for hardware inventory which shows following in one report:

Hardware Make
Hardware Model
Hardware Type
OS Running

Also, I want to run this report on different collections, separately. This report should only show the live computers.

Any help will be much appreciated.

Regards,

Manoj (CoatesHire)

lenmessing · 09-21-2006, 02:48 PM

Quote:

Originally Posted by lenmessing

I want to modify the query you guys posted to run against collections, but am unable to get the JOIN statement to work

select vc.Name, arp.Name
from vcomputer vc
join Inv_AeX_OS_Add_remove_programs arp on arp._ResourceGuid=vc.Guid
order by vc.Name, arp.Name

What do I need to add?

Thanks for the reply to this but I'm still not able to filter this through collections. I changed the statement to what you suggested but it still doesnt work.
Please Help!
Thanks

frank6666 · 01-18-2008, 02:46 PM

Hi

Do you know how I could modify these reports so they would be:

"Add Remove Programs by User" ?

The reports are great and I just want to be able to search against users instead of computers but my SQL knowledge is very limited (totaly nul to be honest...)

Thanks