cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Dennis_A
Engaged Sweeper
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.
1 REPLY 1
endyk
Engaged Sweeper III
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