
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 05:11 PM
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 '%%'
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 '%%'
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 06:44 PM
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 07:14 PM
Thank you very much that worked and it pulled both Win and Linux which is what I needed


Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-04-2016 06:44 PM
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
