This module is designed to help you understand data exchanges in your instance powered by Perspectium. On this page, you'll find everything you need to know about installing the dashboard and what features are included.
Accessing the Dashboard
To access your dashboard, go to Perspectium DataSync Express > Dashboard
In order for the dashboard to display data, you need to first share some data, such as executing a bulk share. If your instance does not have any previously-shared data, simply run a few bulk shares in order to generate some data to view.
Dashboard Features
Here's a breakdown of all of the features available on your dashboard.
Queue Status
Status Indicators
Active: Queues that are healthy, running with valid credentials, and have the active field set to true are considered active. They are indicated with a green icon.
Not Active: Queues that are disabled or have the active field set to false with no error messages found are considered not active. They are indicated with a grey icon.
Error: Queues that contain any status errors or indicate unauthorized credentials are flagged as an error. More details about the error can be found from the queue alert field. They are indicated with a red icon.
This feature allows you to view all your shared and subscribed queues on your ServiceNow instance in one place. Click on a queue under Shared Queues or Subscribe Queues to view information about it. The queue clicked will have its information, such as queue status, and if available, queue history, displayed on the top part of this widget.
The Queue History table (x_perr2_datasync_psp_queue_history) stores the queue data shown in the dashboard and is rotated to minimize performance issues on your instance. The default rotation is set up for 8 rotations of 2 days each (16 days total of queue history data). You can adjust the rotation settings to change how much data is saved in this table and subsequently shown on the dashboard.
Total Daily/Monthly Records
Total Daily Records: Displays the total record shares for the current day.
Total Monthly Records: Displays the total record shares for the current month.
Changing the date/month on the calendar does not affect this count.
Average Records Sent + Calendar Select
Use this feature to get a breakdown of the number of records sent based on a selected date in the calendar.
Any time you access or reload the dashboard, the calendar date will reset to the current date.
You can change the date on the calendar using the available arrows or the dropdown settings.
The Records Sent/Day count reflects the number of records sent on the specific calendar date selected.
The Records Sent/Hour count is reflects the number of records sent in the the specific calendar date selected, divided by 24 hours. However, if the current date is selected, then this number is divided by the number of hours that have passed in that day so far.
Record Breakdown
The Record Breakdown graph is a visualization of data based on the calendar date selected. Toggle between different data representation (records per hour, day, month, or lifetime).
Shares from additional related tables selected on a dynamic or bulk share (such as selecting the include attachments or include journal fields options) are not counted in the overall share count displayed on the dashboard. This includes additional shares from tables such as sys_attachment, sys_journal, and sys_audit.
Recent Shares
This feature displays the most recent (up to 50) bulk shares from you instance. You can click on any entry to access that specific record directly.
Shares from additional tables are not counted in the overall share count displayed on the dashboard. This includes additional shares from tables such as sys_attachment, sys_journal, and sys_audit.
Errors
This feature displays the most recent inbound, outbound, and receipt messages that have an Error state. Click on any entry to access that message directly.
General Information
The Perspectium Dashboard Data scheduled job creates the instancedaily payload used to retrieve updated queue and recent shares information. This will run periodically every 5 minutes.