General
Query to list request IDs with Requester and Technician Employee ID (MSSQL)
Tested in build MSSQL (14306) Sample Table Database : MSSQL Query SELECT "wo"."WORKORDERID" AS "Request ID", ti.FIRST_NAME AS "Technician", td.employeeid "Tech Employee ID", ti1.FIRST_NAME AS "Requester", td1.employeeid "Req Employee ID" FROM ...Query to show requests and its associations with Problems, Changes and Projects (MSSQL)
Working on Builds: 14500 and above Database: MSSQL SELECT wo.WORKORDERID AS "Request ID", pim.problemid "Associated Problem ID", icm.changeid "Associated Change ID", wtp.projectid "Associated Project ID", CASE WHEN (wo.is_catalog_template) = 'false' ...Query to show ticket with its attachment details ( PGSQL & MSSQL)
Working on Builds 14500 and above too Databases: PGSQL & MSSQL: SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", sa.ATTACHMENTNAME "Attachment Name", sa.ATTACHMENTPATH "Attachment ...Query to show count of tickets account based (PGSQL)
Tested in Build PGSQL (14300) Please go to Reports-New Query Report and execute this report. select concat(ad.org_name, ' - ', tmp.wo_count), w.workorderid "Request ID",to_timestamp((w.createdtime)/1000)::TIMESTAMP "Created ...
New to ADSelfService Plus?
Popular Articles
Unable to access ServiceDesk Plus in the latest version of Edge and Chrome version (Version 94 - Released)
Root cause : Chrome has defined Scheduler as a variable and unfortunately the same is used in ServiceDesk Plus in resource management section and Chrome API's 'scheduler' variable is overriding our application's variable (Used in resource management) ...How to reset administrator password in ServiceDesk Plus (or Asset Explorer).
1. Access your application server and browse to [your drive]:\ManageEngine\<application_name>\bin. 2. Click changeDBServer.bat. Information on the configured database will be displayed. If the database is MSSQL, go to the SQL Management Studio, go to ...Where do I find the log files that I need to send to technical support team for analysis?
If Applications Manager is up and running and the WebGUI can be accessed, refer to the steps in this knowledge base article for creating support information file. If Applications Manager is down or the WebGUI cannot be accessed, or if the log size ...How to migrate ServiceDesk Plus from one server to another
Following are the steps to move data from the existing server to a new server, Step 1: Stop ManageEngine ServiceDesk Plus service. Step 2: Kindly Upgrade ServiceDesk Plus if required. Refer to the link below to check if you are in the latest version, ...Data flow and ports used in Password Manager Pro
List of ports used in Password Manager Pro