Notification

Icon
Error

Custom Scanning - file not existing

Posted: Monday, October 12, 2015 7:16:51 AM(UTC)
koglerh

koglerh

Member Original PosterPosts: 21
2
Like
This issue has been solved! Click here to view the solution
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?
Daniel.B
#1Daniel.B Member Posts: 1,150  
posted: 10/12/2015 12:35:43 PM(UTC)
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:
    Code:
    
    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 '%[h]Fonts\EXAMPLE.TTF[/h]' And
        tblFileVersions.Found = 'True') And tblAssetCustom.State = 1
    Order By tblAssets.AssetName
    
koglerh
#2koglerh Member Original PosterPosts: 21  
posted: 10/12/2015 1:47:11 PM(UTC)
Thanks Daniel! That's the perfect solution!
Bruce Garoutte
#3Bruce Garoutte Member Posts: 3  
posted: 7/17/2019 8:19:50 PM(UTC)
Daniel,
Brilliant!!
Thank you so much, this was exactly what we needed.

Active Discussions

Lansweeper Dell Update v3.0
by  gmw158  
Go to last post Go to first unread
Last post: Yesterday at 5:42:19 PM(UTC)
Lansweeper Report to compare softwareVersion
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 4:57:16 PM(UTC)
Lansweeper Dublicate entries (multiple lines with assetname)
by  wkorrubel  
Go to last post Go to first unread
Last post: Yesterday at 10:10:28 AM(UTC)
Lansweeper Only show string right of character N
by  RC62N   Go to last post Go to first unread
Last post: 1/20/2020 10:36:12 PM(UTC)
Lansweeper Report From Lansweeper For My Company
by  RC62N  
Go to last post Go to first unread
Last post: 1/17/2020 6:59:47 PM(UTC)
Lansweeper AD Users to Managers and their devices.
by  C&C   Go to last post Go to first unread
Last post: 1/17/2020 1:45:52 PM(UTC)
Lansweeper Report From Lansweeper
by  Aravin Nokaraju  
Go to last post Go to first unread
Last post: 1/17/2020 1:46:40 AM(UTC)