‎01-30-2019 03:18 PM
‎01-30-2019 10:38 PM
‎01-30-2019 06:14 PM
‎01-30-2019 08:46 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName As Hostname,
tblAssets.Username,
tsysOS.OSname As OS,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssetCustom.Model,
tblSoftwareUni.softwareName As [Microsoft Office Version]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where (tblSoftwareUni.softwareName Like '%Microsoft Office Professional%' And
tblState.Statename = 'Active') Or
(tblSoftwareUni.softwareName Like '%Office 365%')
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now