Number of Software

[Dennis_A]

Hallo,

I'm trying to build a Report wich shwos me wich Software is installed on all clients in a spesific Domain. The Publisher is the Microsoft Corperation. I don't want to see where it is installed just the Number of innstallations in this Domain. Is there any possibility to do this?
Thank you for your help.

[endyk]

Hello Dennis,

This query should work for your scenario. It will return each domain and the number of installations for software published by Microsoft.
Let me know if you need further help.

Endy



select
a.Domain
,count(su.softwareName) nbrOfInstallations
from tblassets a
Inner Join tblSoftware s On a.AssetID = s.AssetID
Inner Join tblSoftwareUni su On su.SoftID = s.softID
where su.SoftwarePublisher like 'microsoft%'
group by a.Domain