I think these will be hard report to create or not, i need to know all the application installed on computer that have Windows 7 of all model of that os?
Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftwareUni.SoftwarePublisher As Publisher, Count(tblSoftware.AssetID) 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 Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tblAssetCustom.State = 1 And tsysOS.OSname = 'win 7' Group By tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher Order By Total Desc
Select Top 1000000 tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftwareUni.SoftwarePublisher As Publisher, Count(tblSoftware.AssetID) 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 Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tblAssetCustom.State = 1 And tsysOS.OSname = 'win 7' Group By tblSoftwareUni.softwareName, tblSoftware.softwareVersion, tblSoftwareUni.SoftwarePublisher Order By Total Desc
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.