Steps to import Archived Request

Steps to import Archived Request into Analytics Plus

By default, we don't import archived request details into Analytics Plus but we are working on a model to import these details out of the box and will be available in one of our future builds.

Meanwhile, please follow the below text instructions

Step 1:

Open ServiceDesk Plus database in Analytics Plus, click on Create New and choose New Table / Import Data.




Step 2:


Click on Local and Cloud Databases.





Step 3:


Fill the database server details for the connection in the following section and click Next. (In this case, we have chosen Postgres as an example)




Step 4:


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




Step 5:


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






Step 6:


Schedule the import and click create to complete the import



Note: You can create a query table in Analytics Plus as outlined in this link to join Requests and Archived Requests

Here is the query
SELECT "RequestID","Subject","Created Time","Requester","Resolved Time","Completed Time","Responded Time","Time Elapsed","Category","Department","DueBy Time","Group","Impact","Level","Mode","Overdue Status","Priority","ReOpened","Request Status","Service Category","Service Request","SLA","Urgency","Workstation" FROM Request 
UNION
SELECT "RequestID","Subject","Created Time","Requester","Resolved Time","Completed Time","Responded Time","Time Elapsed","Category","Department","DueBy Time","Group","Impact","Level","Mode","Overdue Status","Priority","ReOpened","Request Status","Service Category","Service Request","SLA","Urgency","Workstation" FROM "Archived Request"
  • This will sum up Request and Archived Request into the same table. So you can combinedly create reports on Request and Archived Request

                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • 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 ...
                    • Move Analytics Plus from one Server/folder

                      Go to Start --> Services.msc and stop the ManageEngine Analytics Plus service. Take a backup of the entire <Analytics Plus_Home> directory and then move it to the new server.  On the new server, navigate to (similar path) <Analytics Plus_Home>\bin ...
                    • Steps to import approval date

                      We can fetch the approval date data from ServiceDesk Plus using the following workaround. Below are the steps to be followed to successfully import the data. Step 1: Click Import data within the ServiceDesk Plus database in Analytics Plus. Step 2: ...
                    • 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, ...