→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PB
Engaged Sweeper II

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

1 ACCEPTED SOLUTION
PB
Engaged Sweeper II

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

View solution in original post

1 REPLY 1
PB
Engaged Sweeper II

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