Reports / On Premise / Standard Reports¶
A list of the standard reports provided by MAGIQ Documents are:
Document / Folder Report Templates¶
These reports are created based on a search criteria.
- BoxNumberDetails_01
- BoxNumberDetails_02
- BoxNumberDetails_03
- CorrespondenceDetails_01
- CorrespondenceDetails_02
- CorrespondenceDetails_03
- DocumentDetails_01
- DocumentDetails_02
- DocumentDetails_03
- FolderDetails_01
- FolderDetails_02
- FolderDetails_03
- FolderDetails_04
- FolderDetails_05
Administration Statistical Report Examples¶
Note
Reports which have XLS in the name, must be run with output file as Excel.
Not all parameters are required to be entered.
The Standard library IDs are:
900 = Form Templates,
1000 = Corporate,
1001 = Public Access,
1009 = System Files,
1010 = MAGIQ Reports,
1012 = Service Requests,
1017 = User Workspace,
1018 = Business Classification Scheme, and
1019 = Converted Data
Correspondent Reports¶
Document Reports¶
Note
For all Audit reports, ensure 'Audit Logs' check boxes are ticked in the Library Policies.
All Document reports exlcude the IDs of 900, 1000, 1001, 1009, 1010, 1012, 1017 and 1019.
- Audit Document Creates XLS
- Audit Document Disposition XLS
- Audit Document Owners XLS
- Audit Document Retention XLS
- Audit Document Security XLS
- Audit Document Type Changes XLS
- Audit Documents Accessed XLS
- Audit Documents Changed XLS
- Audit Documents Checked in XLS
- Audit Documents Checked out XLS
- Audit Documents Deleted XLS
- Audit Documents Generic XLS
- Audit Documents Moved XLS
- Audit Documents Renamed XLS
- Completed Response Times for Organisation
- Completed Task Timeframes
- DailyCorrespondence_sql
- DailyCorrespondenceTodayUsingDateRecd
- DailyCorrUsingPubDate_sql
- Deleted Documents
- DocPathLengths-ExcelXLS
- DocPathLengths-WordXLS
- DocsPerFolder
- DocsWithNoExtension
- DocTypeStatsByLibraryCreatedLast7Days
- DocTypeStatsByRange
- Document Expirations
- Document Resubmits_sql
- Document-DateRegisteredRangePerBox
- DocumentRegister_sql and DocumentRegisterNoOrg_sql
- Documents AccessedXLS_sql
- Documents Changed_sql
- Documents Owned by a Deleted User
- Documents Read_sql
- Documents Unpublished
- Documents(emails)RegisterStatsByDepartment
- Documents(emails)RegisterStatsByUser
- DocumentsRegisterStatsByDepartment
- DocumentsRegisterStatsByUser
- DocumentTypeStats
- DocumentTypeStatsByDepartment
- DocumentTypeStatsByUser
- FinancialYearStats
- FinancialYearStatsbyDepartment
- InfoXpertAudit_sql and InfoXpertAuditNoOrg_sql
- YearlyStats
- YearlyStatsbyDepartment
Task and Workflow Reports¶
- All_TaskandWorkflowStatsWithDepartmentXLS
- MyTasks_Sql and MyTasksXLS_sql
- TaskandWorkflowStats
- TaskandWorkflowStatsWithDepartment
- TasksRedirected_sql
- TasksUserOverdueDesc_sql
- TaskUserOverduebyDepartment_sql
- TaskUserOverdueDocs_Sql and TaskUserOverdueDocsNoOrg
- TaskUserTotalsByRange
- TasksUserTotalsLast31Days
- WorfklowDefinitions
Folder Reports¶
Note
For all Audit reports, ensure 'Audit Logs' check boxes are ticked in the Library Policies.
- Audit Folder Classification XLS
- Audit Folder Creates XLS
- Audit Folder Owners XLS
- Audit Folder Security XLS
- Audit Folders Deleted XLS
- Audit Folders Moved XLS
- Audit Folders Renamed XLS
- Audit Folder Rule Changes XLS
- Deleted Folders
- Empty Folders
Service Request Reports¶
Note
All the Service Request reports are based on the library ID of 1012.
- AllRequestsRegister_sql
- OverdueSRs_sql
- SR TaskandWorkflowStats
- SR TaskandWorkflowStatswithDepartment
- SR YearlyStatsXLS
- SRbyTypes_sql
- SRs CompletedTaskTimeframes_sql
Retention and Disposal Reports¶
- NZ_Retention-Document RetentionsXLS_sql
- Retention and Disposal ScheduleXLS
- Retention-Documents Ready for TransferXLS_sql
- Retention-Document RetentionsXLS_sql
- Retention-Documents TransferredXLS_sql
- Retention-Documents with No RetentionXLS_sql
- Retention-Folder RetentionsXLS
- Retention-Frozen DocumentsXLS_sql
- Retention-Folders with No RetentionsXLS
- Retention-Frozen FoldersXLS