Change module data : Import into Analytics Plus

Change module data : Import into Analytics Plus

Note: When Analytics Plus officially supports Change module integration Out of the box, then these imported tables and reports might get overwritten. Please ensure to name the table as 'Change_localDB'.

Please find text file attached with the query to pull data from change module of Servicedesk Plus. Below are the steps to import them into Analytics Plus.

Step 1:

Click New and choose New table / Import Data.

Step 2:

Click Local and Cloud Databases.

Step 3:

Fill the database server details for the connection under the Connect to Local and Cloud Databases section and click Next. (In this case, We have chosen MS SQL as example)

Step 4:

Choose Custom Query radio button and paste the custom query(from attachment) inside the query editor. Click Next to proceed.

Step 5:

Type the table name(Change_localDB) and choose the proper datatypes for the columns in the preview. Click Next to proceed.

Below are the datatypes for the columns.

Column Name	Data Type
Change ID	Positive Number
Created Time	Date
Completed Time	Date
Scheduled Start Time	Date
Scheduled End Time	Date
Next Review Schedule	Date
Overdue Status	Plain Text
Retrospective	Plain Text
Emergency	Plain Text
Subject	Plain Text
Change Requester	Plain Text
Change Owner	Plain Text
Change Manager	Plain Text
Category	Plain Text
Sub Category	Plain Text
Item	Plain Text
Priority	Plain Text
Change Type	Plain Text
Urgency	Plain Text
Site	Plain Text
Group	Plain Text
Template	Plain Text
Workflow	Plain Text
Stage	Plain Text
Status	Plain Text
Reason For Change	Plain Text
Change Closure Code	Plain Text
Risk	Plain Text
Impact	Plain Text
SLA	Plain Text