cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sunshine
Engaged Sweeper
I need a report that will list the number of apps installed on a machine. For example, if there are 10 Apps installed on machine x, then all I want to know is that there are 10 apps installed on machine x. I'm trying to target machines with the least number of apps installed for an imaging project.

Thanks for the help in advance.

Sunshine
2 REPLIES 2
sunshine
Engaged Sweeper
Thanks for the query and thanks for bringing it to my attention about the reporting area. This seemed to have done the trick.

Thank you.
Sunshine
MikeMc
Champion Sweeper II
This request should go in the reports section, but hope this works for you:

Select Top 1000000 T1.AssetID,
T1.AssetName,
T1.SystemSoftwareCount,
T1.UserSoftwareCount,
T1.TotalSoftwareCount,
T1.icon
From (Select Distinct tblAssets.AssetID,
tblAssets.AssetName,
(Select Count(tblSoftware.SoftwareID) From tblSoftware
Where tblSoftware.AssetID = tblAssets.AssetID And tblSoftware.CurrentUser <>
1) As SystemSoftwareCount,
(Select Count(tblSoftware.SoftwareID) From tblSoftware
Where tblSoftware.AssetID = tblAssets.AssetID And tblSoftware.CurrentUser =
1) As UserSoftwareCount,
(Select Count(tblSoftware.SoftwareID) From tblSoftware
Where tblSoftware.AssetID = tblAssets.AssetID) As TotalSoftwareCount,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1) T1
Where (T1.TotalSoftwareCount > 0)
Order By T1.AssetName