‎07-25-2013 06:33 PM
Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Count(tblSoftware.SoftwareID) As Total
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.SoftwarePublisher Like N'%Adobe%' And
tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
Order By Total Desc,
Software
Solved! Go to Solution.
‎07-26-2013 03:43 PM
‎07-31-2013 12:18 AM
‎07-30-2013 08:29 PM
Select Top 1000000 tblAssets.Domain,
tsysOS.OSname,
Count(tblOperatingsystem.Caption) As Total
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By tblAssets.Domain,
tsysOS.OSname
Order By Total Desc,
tsysOS.
‎07-26-2013 03:43 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now