We've rolled out LSAgent and it's gone well. I'd like to create a report to show devices that haven't got the agent yet, but exclude server O/S's from the report as I won't be installing the agent on them. Any help appreciated. Cheers
We use LsAgent on our laptops, and I created a report for those that don't have it installed. I changed it so it should return only non-server Windows assets.
Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.IPAddress, Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.Lastseen, tblAssets.Lasttried From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Where tblSoftwareUni.softwareName Like '%LsAgent%') And (tblComputersystem.Domainrole = 1 Or tblComputersystem.Domainrole = 0) And tblAssetCustom.State = 1 Order By tblAssets.AssetName