ReportDeck
ReportDeck is an automated web based reporting system designed for the security industry. Many access control systems can not easily provide aggregated count reports used for people flow analysis. ReportDeck allows the creation of customised report templates using SQL scripts. Many templates have already been created for reporting on systems like CCure 9000, Lenel, Pacom GMS, Pro-Watch and Inner Range systems such as Insight and Integriti. Once a template is configured, any number of reports can be created from this template and saved in permission based folders. Reports can be scheduled to be sent via email to information stakeholders. Excel report outputs can be generated by the server or a custom Excel base file uploaded to a report to allow for graphs and charts on the first worksheet while data is written to the last. Complete column customisation is possible along with wild card text filters on any column. Example reports are:
- Send door access history for any door that contains "IT Room" every day at 8am showing access for last 24 hours.
- Send report with Excel dashboard showing alarm activation counts, per day, per alarm point with most active alarm at the top.
- Send occupancy report that shows number of unique people who badged on site per hour for the last 30 days.
- Send alert report that runs every 10 minutes and only emails if a particular value is found in an events table (e.g. "Offline") within the last 10 minutes.
