Report on Servers needed for Cylance

[cdubya1972]

Help with a report that has servers with Cylance and without? I need a detailed report of our Servers that have Cylance installed on them and then a report without Cylance. Seems like an easy request but I'm new so any help would be appreciated!

Thanks,

[Bruce_B]

I've added two reports below, one that shows all servers (domainrole>1) with cylance installed and one without. You may need to alter the highlighted software name if the product has a different name. Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Servers without Cylance installed

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssets.AssetID Not In (Select Top 1000000 tblAssets.AssetID
  From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
      tblAssetCustom.AssetID Inner Join tsysAssetTypes
      On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
      On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni
      On tblSoftwareUni.SoftID = tblSoftware.softID
  Where tblAssetCustom.State = 1 And tblSoftwareUni.softwareName Like
    '%Cylance%') And tblComputersystem.Domainrole > 1 And
  tsysAssetTypes.AssetTypename = 'Windows' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

Servers with Cylance installed

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Cylance%' And
  tblComputersystem.Domainrole > 1 And tsysAssetTypes.AssetTypename = 'Windows'
  And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName