In order to be able to trace certain file extensions you need to: Select file types you want to track: You can do it under Site Database>Site Management >SiteName>Client Agent >Software Inventory Client Agent Select file types you like to monitor Create report with following SQL statement: The following one will generate report on all AVI files SELECT CS.Name0, CS.UserName0, SF.FileName, SF.FileSize, SF.FileModifiedDate, SF.FilePath FROM dbo.v_GS_COMPUTER_SYSTEM Read more

By default System Center Configuration Manager 2007  Files are located under the following path %Windir%System32CCMLogs CAS Content Access service. Maintains the local package cache. CcmExec.log Records activities of the client and the SMS Agent Host service. CertificateMaintenance.log Maintains certificates for Active Directory directory service and management points. Read more