cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
koglerh
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
Bruce_Garoutte
Engaged Sweeper II
Daniel,
Brilliant!!
Thank you so much, this was exactly what we needed.
koglerh
Engaged Sweeper III
Thanks Daniel! That's the perfect solution!
Daniel_B
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now