→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎08-13-2015 10:31 AM
Solved! Go to Solution.
‎08-17-2015 11:12 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tSoftware.softwareName,
tSoftware.softwareVersion,
tSoftware.Installdate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Snow inventory %') tSoftware
On tSoftware.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tSoftware.softwareName
‎08-17-2015 11:12 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen,
tSoftware.softwareName,
tSoftware.softwareVersion,
tSoftware.Installdate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftware.Installdate
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Snow inventory %') tSoftware
On tSoftware.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
tSoftware.softwareName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now