Custom Scanning - file not existing

[koglerh]

I want to check certain clients if they DONT have a specific file installed. Whenever i want to scan FOR a file, i use custom scanning method. But in this case i wonder how i should proceed?

ps. i want to scan if a specific font is not installed (or at least not in the windows-font directory).

any ideas?

[Bruce_Garoutte]

Daniel,
Brilliant!!
Thank you so much, this was exactly what we needed.

[koglerh]

Thanks Daniel! That's the perfect solution!

[Daniel_B · Accepted solution]

You can get a list of computers not having a specific file through a custom report by

• setting up custom file scanning for this file (instructions can be found here)
  
• rescanning all your Windows computers
  
• running a report like the following example:
  

  
  Select Top 1000000 tblAssets.AssetID,
    tblAssets.AssetName,
    tblAssets.IPAddress,
    tblAssets.Lastseen,
    tsysOS.OSname,
    tsysOS.Image As icon
  From tblAssets
    Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
    Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Where tblAssets.AssetID Not In (Select tblFileVersions.AssetID
    From tblFileVersions
    Where tblFileVersions.FilePathfull Like '%Fonts\EXAMPLE.TTF' And
      tblFileVersions.Found = 'True') And tblAssetCustom.State = 1
  Order By tblAssets.AssetName