‎09-21-2015 05:52 AM
Solved! Go to Solution.
‎09-21-2015 04:53 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate
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
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname In ('Win 2003', 'Win 2003 R2', 'Win 2000 S', 'Win 2008',
'Win 2008 R2') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
‎09-21-2015 04:53 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate
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
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname In ('Win 2003', 'Win 2003 R2', 'Win 2000 S', 'Win 2008',
'Win 2008 R2') And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now