‎11-18-2014 08:53 PM
Solved! Go to Solution.
‎11-20-2014 03:16 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets.SP,
SubQuery1.FileVersion As IISversion,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%inetinfo%') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblServices.Started = 1 And tblAssetCustom.State = 1 And
tblComputersystem.Domainrole > 1 And tblServicesUni.Name Like '%W3SVC%'
Order By tblAssets.Domain,
tblAssets.AssetName
‎03-09-2016 07:33 PM
‎06-23-2015 07:51 PM
‎06-23-2015 07:28 PM
‎11-20-2014 03:16 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets.SP,
SubQuery1.FileVersion As IISversion,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Left Join (Select tblFileVersions.AssetID,
tblFileVersions.FileVersion
From tblFileVersions
Where tblFileVersions.FilePathfull Like '%inetinfo%') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblServices.Started = 1 And tblAssetCustom.State = 1 And
tblComputersystem.Domainrole > 1 And tblServicesUni.Name Like '%W3SVC%'
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now