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, you can follow the below steps
Text Instructions:
1. Login to your Analytics Plus and go-to your ServiceDesk Plus workspace.
2. Click on create new table / import data.
3. Select local & cloud databases.
4. Under connection name select local databases -> choose the database type of your ServiceDesk Plus and fill in the connection information. (NOTE: If postgres SQL is your ServiceDesk Plus database, then you can find the database related information under <ServiceDesk home>\conf\database_params.conf)
5. Choose custom query ( radio button) and paste the below query and hit next.
SELECT wo.WORKORDERID AS "Request ID", rrs.RESOLUTION AS "Resolution", wotodesc.FULLDESCRIPTION AS "Description" FROM WorkOrder wo LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID = rrs.REQUESTID WHERE (wo.ISPARENT='1')
6. Type the table name (Description Field) and choose the proper datatypes for the columns in the preview. Click Next to proceed.
Below are the datatypes for the columns.
Request ID -> Positive Number,
Description -> Multi Line Text
Resolution -> Multi Line Text
7. Setup a schedule interval to periodically fetch the latest data from the database specified.
8. Open the table "Description Field", goto Request ID column -> right click -> change to lookup column.
9. Choose "Request ID" from the request table. Click here to know more about creating a lookup column.
New to ADSelfService Plus?
Related Articles
How to import description field details 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, ...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'. ...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 ...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? ...