Apple Mac Report - Missing specific software

[Adam_Gonzalez]

Hello All,

I'm having a difficult time creating a report that isolates Apple Mac stations that are missing a specific piece of software. In this case I'm looking for any station missing 'CylanceUI' but will be targeting others in the future. Most of the reports I've encountered on this forum are specific to Windows but I have failed to find one that works with our Mac workstations. Any help would be appreciated. I'm still learning to SQL language but I need this report sooner rather than later so I thought I'd ask instead of spinning my wheels. Thanks in advance!

-adam

[Esben_D]

Take a look at this report: https://www.lansweeper.com/report/missing-software-audit/

Change all mentions of tblSoftware to tblMacApplications

And change the software name obviously.

[Adam_Gonzalez]

Esben.D wrote:
Take a look at this report: https://www.lansweeper.com/report/missing-software-audit/

Change all mentions of tblSoftware to tblMacApplications

And change the software name obviously.

ok... I ended up copying the built in mac hardware report and modifying it with bits of the report you mentioned above.

Here's the final code just in case anyone else wants it.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.OScode,
tblAssets.SP,
tblMacOSInfo.SystemVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Where tblAssets.AssetID Not In (Select Top 1000000 tblMacApplications.AssetID
From tblMacApplications Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblMacApplications.softid
Where tblSoftwareUni.softwareName Like '%CylanceUI%') And
tsysAssetTypes.AssetTypename = 'Apple Mac' And tblAssetCustom.State = 1
Order By tblAssets.AssetID,
tblAssets.AssetName

Thanks for your help.

Also, if anyone notices anything wrong with the code above please let me know but it seems to be ok.