Though SIGNL4 does not provide canned reports (yet), it allows for downloading all required data of on-call times, alerts and responses. Hence all it takes is an external tool to process and analyse those logs.
Shift and alerts logs can be used to review workload of your team members, frequency of certain alert types, hours spent on duty for compensating your on-call staff, etc. All logs are accessible as CSV files through the SIGNL4 team management portal at ‘Audit Trail’.
Log and Reporting Samples
AlertAuditReport.csv
Timestamp,EventId,EventType,AlertId,UserId,UserMail,Content,Price,Duration
2018-09-14T15:21:06.9508401Z,e507fdc2-1bd3-4f28-bdee-7653001c0f66,Alert_New,2518653623330491598_9456e190-5f85-43a4-b6f6-7cfa831f3d4e,,,,0.00,
2018-09-14T15:27:17.5749352Z,5b91bc1a-093f-467e-8a6c-4ddc3e412291,Alert_Confirmed,2518653623330491598_9456e190-5f85-43a4-b6f6-7cfa831f3d4e,1082a885-7541-4615-b3ae-6ef7660b834e,anna@derdack.com,,0.00,0
2018-09-14T15:33:44.2164155Z,0145c84a-ac51-488b-bd63-2034d90542e4,Alert_New,2518653615757835844_ce525f29-a231-48cc-8f59-37f0ed7f95f2,,,,0.00,
ShiftReport.csv
Name;Email;Start;End;Hours
Anna;anna@derdack.com;2018-09-14T15:21:02.0743200Z;2018-09-14T17:31:44.4990010Z;2:10
John;john@derdack.com;2018-09-19T07:51:45.4039920Z;2018-09-19T07:52:29.5466015Z;0:0
John;john@derdack.com;2018-09-19T07:52:58.9672917Z;2018-09-19T08:51:01.8244028Z;0:58
Let look how we can use Microsoft Excel to create some nice reports and charts like these:
AlertAuditReport
ShiftReport
Follow these steps to get started
1. Download csv log files from your SIGNL4 portal at Audit Trail at https://account.signl4.com/manage/Report
2. Import the .csv files from Excel. Please make sure to import the data and not just open (double-click) it! The import function can automatically recognize the date / time formats used in the SIGNL4 logs (UTC plus timezone).
3. Do the calculations and create the diagrams you need in Excel.
4. Print or export the reports and send them to whoever needs them 🙂
To be honest, creating above charts is a bit tricky. Therefore, we’ve created a sample Excel file for your convenience. You can download it on GitHub: https://github.com/signl4/signl4-reporting.
This Excel file provides the following reporting information:
Alerts
- Total number of alerts
- Alerts outside working hours
- Number of alerts per user
- Number of alerts per day
- Average response times per user
Shifts
- Total number of alerts
- Alerts outside working hours
- On-call time per user in hours
With this Excel file you can add your CSV date in the following way:
1. Open the file SIGNL4-Reporting.xls and point to your .csv files. In order to do so go to Data -> Queries & Connections and then double-click AlertAuditReport on the right-hand side. The Power Query Editor opens. Here go to Home -> Advanced Editor. In the text box you can see the path to the .csv file. Adapt this one to match the path to your AlertAuditReport .csv file. Then click Done and Save & Load to close the Power Query Editor. Do the same for SiftReport as well.
2. Back in the main Excel window click Data -> Refresh All. This will update the report accordingly.
3. You might want to adapt the reports with the information you need. If you have large data sets you can also add additional rows by copy and paste in the Sheets AlertHelper and ShiftHelper.
4. That is it and your reports are available in the Sheets Alerts and Shifts. You can print them or export them as PDF.
(Click to open animated GIF.)
If you have any questions you can mail me at ron@signl4.com