→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Twinter
Engaged Sweeper
I tried replacing all the tblLinuxSoftware with tblMacOSInfo but keeps giving me an error on the tblsoftwareuni
Anyone have Ideas?

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
1 REPLY 1
Nick_VDB
Champion Sweeper III
Mac software information is stored in tblMacApplications. You must replace the tblLinuxSoftware with tblMacApplications as shown in the example below.

Select tblMacApplications.AssetID
From tblSoftwareUni Inner Join tblMacApplications
On tblMacApplications.softid = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like '%CrowdStrike_Falcon_Sensor%'