InTrust Reporting Jobs use Microsoft SQL Server Reporting Services for report generation. Reporting jobs run in the Quest.Shotgun.InTrust.ReportingJob.exe executable; a separate instance of Quest.Shotgun.InTrust.ReportingJob.exe is created for each job of that type. InTrust Reporting jobs allow reports to be run against any InTrust database (Configuration, Alerts, Audit) configured as a data source for reporting:
The reporting process in InTrust involves the following:
If a reporting job is configured to use report-driven data import, then data required for the report(s) is retrieved from the repository and placed into the database prior to report generation. The following accounts are used during the reporting job that has data import enabled:
For more information on report-driven data import, refer to the Reporting Job topic.
Two executables are used for data cleanup purposes:
Repository cleanup jobs delete whole files from the repository; if a repository file spans a date/time boundary, the file is not deleted.
Audit database cleanup jobs remove data from the following tables:
The TRUNCATE statement, which requires dbo rights, is used when the delete ALL option selected.
RetentionJob.exe does not delete position data, so InTrust knows the last gathered/imported events. Position data for imported events is stored in the GatheredEvents table; position data for gathered events is stored in the repository, in files that contain a NULL GUID in the filename.