‎07-24-2019 07:59 PM
‎07-25-2019 05:57 PM
‎07-25-2019 07:08 PM
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.
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now