Report for number of apps installed on machines

[sunshine]

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

[sunshine]

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]

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