File size

[Azkor]

Team I am looking to build a custom file report for files I am looking for using this KB: http://www.lansweeper.com/kb/19/report-based-on-file-information.html the issue I have is the default canned report doesnt include the file size, can you give me some assistance in building the file size field into a custom report?

[Daniel_B · Accepted solution]

The following report matches the reports generated under Configuration\Custom scanning and it lists the filesize. We recommend having a look the Database Dictionary as well which provides as overview about which data is stored in which table. You can access it at the top of the report editor.

Select tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon16 As icon,
  tblAssets.Domain,
  tblFileVersions.FilePathfull,
  tblFileVersions.FileVersion,
  tblFileVersions.CompanyName,
  tblFileVersions.Filesize,
  tblFileVersions.CreationDate,
  tblFileVersions.LastAccessed,
  tblFileVersions.LastModified,
  tblFileVersions.Lastchanged,
  TsysLastscan.Lasttime As [Last scanned]
From tsysAssetTypes
  Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblFileVersions On tblAssets.AssetID = tblFileVersions.AssetID
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysLastscan.CFGcode = TsysWaittime.CFGCode
Where tblFileVersions.FilePathfull Like '%iexplore.exe' And
  TsysWaittime.CFGname = 'FILES' And tblFileVersions.Found = 1