cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mzipperer
Engaged Sweeper III
lists windows devices that have the agent installed but are below 7.2.110.18
2 REPLIES 2
mzipperer
Engaged Sweeper III
Thank you I ended up building something else which is very similar


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.LsAgentVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname Like 'Win%' And tblAssets.LsAgentVersion Is Not Null And
tblAssets.LsAgentVersion < '7.2.110.18' And tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
Caleb
Engaged Sweeper III
Something like this?

SELECT Top 1000000 tblAssets.AssetID,
tsysOS.Image AS icon,
tblASsets.ASsetUnique,
tblOperatingsystem.Caption AS [Operating System],
tblADusers.Displayname AS [User],
tblSoftware.softwareVersion AS [LsAgent Version],
tblASsets.IPAddress AS [IP Address],
tblASsets.LAStseen AS [Last Seen],
tblASsets.LASttried AS [Last Tried]
FROM tblSoftware
INNER JOIN tblASsets ON tblSoftware.ASsetID = tblASsets.ASsetID
INNER JOIN tblOperatingsystem ON tblASsets.ASsetID = tblOperatingsystem.ASsetID
INNER JOIN tblComputersystem ON tblASsets.ASsetID = tblComputersystem.ASsetID
INNER JOIN tblSoftwareUni ON tblSoftware.softID = tblSoftwareUni.SoftID
INNER JOIN tblASsetCustom ON tblASsets.ASsetID = tblASsetCustom.ASsetID
INNER JOIN tsysOS ON tblASsets.OScode = tsysOS.OScode
INNER JOIN tblADComputers ON tblASsets.ASsetID = tblADComputers.ASsetID
LEFT JOIN tblADusers ON tblASsets.Username = tblADusers.Username
WHERE tblSoftwareUni.softwareName LIKE '%LsAgent%' AND tblSoftware.softwareVersion < '7.2.110.18' AND tblASsetCustom.State = 1
ORDER BY tblASsets.ASsetName