→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-23-2015 07:10 PM
Solved! Go to Solution.
‎04-24-2015 01:38 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Username,
tblAssets.Userdomain
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where ((tblSoftwareUni.softwareName Like N'Microsoft Office % 20%' And
tblSoftwareUni.softwareName Not Like '%viewer%' And
tblSoftwareUni.softwareName Not Like '%tools%' And
tblSoftwareUni.softwareName Not Like '% designer%') Or
(tblSoftwareUni.SoftwarePublisher Like 'adobe%' And
tblSoftwareUni.softwareName Like '%Reader%')) And tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎04-24-2015 01:38 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblAssets.Username,
tblAssets.Userdomain
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where ((tblSoftwareUni.softwareName Like N'Microsoft Office % 20%' And
tblSoftwareUni.softwareName Not Like '%viewer%' And
tblSoftwareUni.softwareName Not Like '%tools%' And
tblSoftwareUni.softwareName Not Like '% designer%') Or
(tblSoftwareUni.SoftwarePublisher Like 'adobe%' And
tblSoftwareUni.softwareName Like '%Reader%')) And tblAssetCustom.State = 1
Order By tblAssets.AssetName
‎04-24-2015 07:55 AM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now