cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DamonB
Engaged Sweeper

Hi

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

2 REPLIES 2
DamonB
Engaged Sweeper

Worked a treat, thanks

KevinA-REJIS
Champion Sweeper II

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