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.
Click New and choose New table / Import Data.
Click Local and Cloud Databases.
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)
Choose Custom Query radio button and paste the custom query(from attachment) inside the query editor. Click Next to proceed.
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.
Schedule the import and click Create to complete the import.
Get back to us for any clarification.