→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎11-25-2016 07:19 PM
‎12-29-2016 01:51 PM
Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Total,
Count.Count,
tblAssets.AssetName
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 (Select Top 1000000 tblAssets.AssetID,
Count(tblAssets.AssetID) As Count
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.softwareName Not Like '%help%' And
tblSoftwareUni.softwareName Not Like '%air%' And
tblSoftwareUni.softwareName Not Like '%flashax%' And
tblSoftwareUni.softwareName Not Like '%flashpg%' And
tblSoftwareUni.softwareName Not Like '%reader%' And
tblSoftwareUni.softwareName Not Like '%flash%player%' And
tblSoftwareUni.softwareName Not Like '%quiz%' And
tblSoftwareUni.softwareName Not Like '%digital%' And
tblSoftwareUni.softwareName Not Like '%wallaby%' And
tblSoftwareUni.softwareName Not Like '%assistant%' And
tblSoftwareUni.softwareName Not Like '%connect%' And
tblSoftwareUni.softwareName Not Like '%toolkit%' And
tblSoftwareUni.softwareName Not Like '%viewer%' And
tblSoftwareUni.softwareName Not Like '%reviewer' And
tblSoftwareUni.softwareName Not Like '%add-%' And
tblSoftwareUni.softwareName Not Like '%shockwave%player%' And
tblSoftwareUni.softwareName Not Like '%acrobat%' And
tblSoftwareUni.SoftwarePublisher Like N'%Adobe%' And tblAssetCustom.State =
1
Group By tblAssets.AssetID) As Count On tblAssets.AssetID = Count.AssetID
Where tblSoftwareUni.softwareName Not Like '%help%' And
tblSoftwareUni.softwareName Not Like '%air%' And
tblSoftwareUni.softwareName Not Like '%flashax%' And
tblSoftwareUni.softwareName Not Like '%flashpg%' And
tblSoftwareUni.softwareName Not Like '%reader%' And
tblSoftwareUni.softwareName Not Like '%flash%player%' And
tblSoftwareUni.softwareName Not Like '%quiz%' And
tblSoftwareUni.softwareName Not Like '%digital%' And
tblSoftwareUni.softwareName Not Like '%wallaby%' And
tblSoftwareUni.softwareName Not Like '%assistant%' And
tblSoftwareUni.softwareName Not Like '%connect%' And
tblSoftwareUni.softwareName Not Like '%toolkit%' And
tblSoftwareUni.softwareName Not Like '%viewer%' And
tblSoftwareUni.softwareName Not Like '%reviewer' And
tblSoftwareUni.softwareName Not Like '%add-%' And
tblSoftwareUni.softwareName Not Like '%shockwave%player%' And
tblSoftwareUni.softwareName Not Like '%acrobat%' And
tblSoftwareUni.SoftwarePublisher Like N'%Adobe%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
Total Desc,
Software
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now