→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Twinter
Engaged Sweeper
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblComputersystem.Domainrole,
tsysOS.OSname,
tblAssets.Domain
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 tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%') And
tblAssets.Lastseen > GetDate() - 4 And tblComputersystem.Domainrole = 1 And
tblAssetCustom.State = 1 And tblAssets.Assettype = -1 And
tblAssets.AssetUnique Not Like '%%'
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
Just a few things:
  • I'd recommend a separate report due to how Lansweeper separates Windows and Linux devices.
  • I don't scan Linux devices in our environment so the report may or may not be entirely accurate.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblComputersystem.Domainrole,
tsysOS.OSname,
tblAssets.Domain
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%' Union All
Select tblLinuxSoftware.AssetID
From tblLinuxSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%') And
tblAssets.AssetID In (Select tblComputersystem.AssetID
From tblComputersystem Union All Select tblLinuxSystem.AssetID
From tblLinuxSystem) And tblAssets.Lastseen > GetDate() - 4 And
(tblComputersystem.Domainrole = 1 Or tblComputersystem.Domainrole Is Null) And
tblAssetCustom.State = 1

View solution in original post

2 REPLIES 2
Twinter
Engaged Sweeper
Thank you very much that worked and it pulled both Win and Linux which is what I needed

MikeMc
Champion Sweeper II
Just a few things:
  • I'd recommend a separate report due to how Lansweeper separates Windows and Linux devices.
  • I don't scan Linux devices in our environment so the report may or may not be entirely accurate.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblComputersystem.Domainrole,
tsysOS.OSname,
tblAssets.Domain
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%' Union All
Select tblLinuxSoftware.AssetID
From tblLinuxSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%') And
tblAssets.AssetID In (Select tblComputersystem.AssetID
From tblComputersystem Union All Select tblLinuxSystem.AssetID
From tblLinuxSystem) And tblAssets.Lastseen > GetDate() - 4 And
(tblComputersystem.Domainrole = 1 Or tblComputersystem.Domainrole Is Null) And
tblAssetCustom.State = 1