11-16-2023
03:26 PM
- last edited on
05-28-2024
03:33 PM
by
Riley
Can someone help with "custom file scanning"!? I want to have a report if a special file is found and larger than xybytes.
The CustomFilescan works already, but i struggle to generate a report, for this.
Many thanks
Solved! Go to Solution.
11-16-2023 03:52 PM
OK, i already found a solution...
Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.IPAddress,
tblFileVersions.Filesize / 1024 / 1024 As [Size(MB)],
tblFileVersions.FilePathfull As Path
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where
(tblFileVersions.FilePathfull Like
'c:\path\file.out.log.1' And tblFileVersions.Filesize > 1073741824) Or
(tblFileVersions.FilePathfull Like
'c:\path\file.err.log.1' And tblFileVersions.Filesize > 1073741824)
Order By [Size(MB)] Desc
11-16-2023 03:52 PM
OK, i already found a solution...
Select Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetName,
tblAssets.IPAddress,
tblFileVersions.Filesize / 1024 / 1024 As [Size(MB)],
tblFileVersions.FilePathfull As Path
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
Where
(tblFileVersions.FilePathfull Like
'c:\path\file.out.log.1' And tblFileVersions.Filesize > 1073741824) Or
(tblFileVersions.FilePathfull Like
'c:\path\file.err.log.1' And tblFileVersions.Filesize > 1073741824)
Order By [Size(MB)] Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now