
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-07-2017 12:59 PM
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.
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.
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2017 08:53 AM
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
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
