Help Adding Mac workstations to report

[Twinter]

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

[Nick_VDB]

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%'