I have searched high and low trying to find out what I'm doing wrong here and I just can't get it. I'm trying to run a report that shows how many versions of which Adobe products are installed on our clients. I am able to get that information with the following query.
Code:
SELECT a.Name, a.Version, COUNT(a.name) AS '# Installed'
FROM [inv_aex_os_add_remove_programs] a
WHERE [publisher] LIKE '%adobe%'
GROUP BY a.Name, a.version
ORDER BY a.Name
What I would like to do is then double click on an application that is returned from that query and see which machines have that particular application installed. I attempted to do it by altering this code I found slightly.
Code:
select ag.[_ResourceGuid], i.[Name], tcp.[IP Address]
from Inv_Aex_Ac_Client_Agent ag
join vComputer i on ag.[_Resourceguid] = i.[Guid]
join Inv_AeX_AC_TCPIP tcp on ag.[_ResourceGuid] = tcp.[_ResourceGuid]
join Inv_AeX_OS_Add_Remove_Programs adp on adp.[_ResourceGuid] = ag.[_ResourceGuid]
where adp.[publisher] LIKE '%adobe%'
order by i.[Name] asc
The problem is that the above query returns a row for EVERY application that is installed on a client.
I'm sure this is something easy, but I can't get it right now and would truly appreciate any help or advice you may have to offer.
Thanks in advance for your help.
