Filescan Report for special file and size

[PB]

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

[PB · Accepted solution]

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