Change module data : Import into Analytics Plus

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 NameData Type
Change IDPositive Number
Created TimeDate
Completed TimeDate
Scheduled Start TimeDate
Scheduled End TimeDate
Next Review ScheduleDate
Overdue StatusPlain Text
RetrospectivePlain Text
EmergencyPlain Text
SubjectPlain Text
Change RequesterPlain Text
Change OwnerPlain Text
Change ManagerPlain Text
CategoryPlain Text
Sub CategoryPlain Text
ItemPlain Text
PriorityPlain Text
Change TypePlain Text
UrgencyPlain Text
SitePlain Text
GroupPlain Text
TemplatePlain Text
WorkflowPlain Text
StagePlain Text
StatusPlain Text
Reason For ChangePlain Text
Change Closure CodePlain Text
RiskPlain Text
ImpactPlain Text
SLAPlain Text

Step 6:
Schedule the import and click Create to complete the import.

Get back to us for any clarification.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Problem Module Data import

                        Importing Problem data into Analytics Plus:  You could log into the Analytics Plus 'ME ServiceDesk Plus Analytics' database and start creating these two tables using the below queries. Check this link for steps to import data from Local DB. Problem ...
                      • Importing Projects Module data into Analytics Plus

                        We are yet to sync 'Projects' module's data into Analytics Plus. Meanwhile, you can use custom queries to import those data from ServcieDesk Plus. Step 1: Login into Analytics Plus and open ServiceDesk Plus database. Step 2: Click 'Import Data' and ...
                      • How to import Survey data from ServiceDesk Plus to Analytics Plus?

                        Helpdesk surveys help you identify how happy your customers really are with your services. A recent research revealed that 96% of unhappy customers don't complain but, 91% of those unhappy customers leave and never come back. That is sad, isn't it?   ...
                      • How to import description and resolution fields from ServiceDesk Plus to Analytics Plus?

                        Description details from the Requests' module are not available out-of-the box in Analytics Plus as it might contain HTML contents and cannot be displayed properly for reporting. However, if you wish to import description details into Analytics Plus, ...
                      • Analytics Plus Inventory

                        Aim: To have the detailed list of all the Reports, Databases created in Analytics  Open Local & Cloud Databases and fill the entries password = Postgres and if any error occurs stating something like "check the DB connection" change the Port to ...