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 Scan timeout... How long?
by  RobertB   Go to last post Go to first unread
Last post: Yesterday at 11:23:30 PM(UTC)
Lansweeper Lansweeper support levels
by  aldo22  
Go to last post Go to first unread
Last post: Yesterday at 9:31:00 PM(UTC)
Lansweeper selection of database for migration
by  aldo22   Go to last post Go to first unread
Last post: Yesterday at 9:25:36 PM(UTC)
Lansweeper Deployment Threads
by  RobertB  
Go to last post Go to first unread
Last post: Yesterday at 5:06:47 PM(UTC)
Lansweeper Bulk remove old domain users from Lansweeper
by  Erik.T   Go to last post Go to first unread
Last post: Yesterday at 3:42:00 PM(UTC)
Lansweeper Weekly tasks
by  LithiumKid1976  
Go to last post Go to first unread
Last post: Yesterday at 3:29:56 PM(UTC)
Lansweeper Bulk user deletion
by  Erik.T   Go to last post Go to first unread
Last post: Yesterday at 9:36:03 AM(UTC)
Lansweeper Tracking assets like docking station, mouse and keyboards
by  CyberCitizen  
Go to last post Go to first unread
Last post: Yesterday at 2:43:18 AM(UTC)