‎06-20-2016 08:44 PM
‎07-20-2016 08:44 PM
‎07-11-2016 11:26 AM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblSoftwareUni.SoftwarePublisher Like '%autodesk%' And
tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
Software
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now