cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
baycrest
Engaged Sweeper II
I want to have a report that would show if a specific file on a users C drive has been modified in the last 24
hours. Is anyone able to create this for me?
1 REPLY 1
CyberCitizen
Honored Sweeper
Add the file to custom scanning. Rescan your assets.

Then look at the included report Windows: File Scanning results.

You should then be able to save as and create a new report to show just that scanned file.

Below is a report I have setup looking for our Service Desk Portal Shortcut.

Its filtered to show those machines that don't have the shortcut. We then have a scheduled deployment setup based on that report. That way anytime a new machine is joined to our network it gets the shortcut within 15 minutes.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.Domain,
tblAssets.Username
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
'C:\Users\Public\Desktop\Service Desk Portal.url' And
tblFileVersions.Found = 'True') And tblAssetCustom.State = 1
Order By tblAssets.AssetName