‎02-06-2017 02:09 PM
Select Top 1000000 tblAssets.AssetName As Hostname,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like '%someapp%' And
tblAssetCustom.State = 1
Select Top 1000000 tblAssets.AssetName As Hostname,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where tblFileVersions.FilePathfull Like '%\Program Files (x86)\someapp.exe'And
tblFileVersions.Found = 1
Order By tblAssets.AssetName
‎02-08-2017 04:04 PM
Select Top 1000000 tblAssets.AssetName As Hostname,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
FileInfo.FilePathfull,
FileInfo.FileVersion,
FileInfo.CompanyName
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select Top 1000000 tblAssets.AssetName As Hostname,
tblFileVersions.AssetID As AssetID,
tblFileVersions.FilePathfull,
tblFileVersions.FileVersion,
tblFileVersions.CompanyName
From tblAssets
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where tblFileVersions.FilePathfull Like '%\Program Files (x86)\someapp.exe'
And tblFileVersions.Found = 1
Order By Hostname) As FileInfo On tblAssets.AssetID = FileInfo.AssetID
Where tblSoftwareUni.softwareName Like '%someapp%' And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now