Query to get Info about request technician change and changed by
Version : 14001 DB: MSSQL / PGSQL OUTPUT : SELECT wo.WORKORDERID "Request ID", (aau.FIRST_NAME) "CREATEDBY", (wo.TITLE) "Subject", (std.STATUSNAME) "Request Status", aau.FIRST_NAME AS "Changed By", auTech.FIRST_NAME as "Tech Changed From", auNextTech.FIRST_NAME
Query to get Template list with fields mapped to it and default values.
Version : 14000 DB : PGSQL OUTPUT : select sd.name "Service Catalog Name",rt.templatename "Template name",fc.field_name "Fields",fc.default_value "Field Value" from requesttemplate_list rt left join servicedefinition sd on sd.serviceid = rt.parent_service
Query to get Project and milestone timespent in same query.
Version : 10.6 DB : MSSQL OUTPUT : SELECT tpr.PROJECTID , MAX(pr.TITLE) "Title", (SELECT SUM(ct.TIMESPENT)/1000/3600 "Total Time Spent" FROM ChargesTable ct LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID LEFT JOIN TaskDetails tk ON tkc.TASKID=tk.TASKID
Query to Request created from Mail and waiting for an Tech Reply.
Version : 14001 DB : PGSQL / MSSQL OUTPUT : SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ad.ORG_NAME AS "Account" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderAccountMapping wam ON wo.WORKORDERID=wam.WORKORDERID
Business Role
Hi there, Can I associate all my request to specific Site, Group and Account? If Can , How can I do it
Query to get Request Closure Comments added by requester.
Version : 13000 DB : MSSQL / PGSQL SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", rtdef.NAME AS "Request Type", lvd.LEVELNAME AS "Level", std.STATUSNAME AS "Request Status", wo.CREATEDTIME
Query to get SLA and First Response voilated percentage based on account
Version : 10609 DB : PGSQL / MSSQL OUTPUT : SELECT ad.org_name "Account", count(wo.WORKORDERID) "Total Request", count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) "Completed Requests" , count(case when (wos.ISOVERDUE='1') THEN 1 ELSE NULL END) "SLA
Query to get Change WorkLog
Version : 14001 DB : PGSQL / MSSQL OUTPUT : SELECT ch.CHANGEID "Change ID", ch.TITLE "Change Title", rctd.FIRST_NAME "WorkLog Owner", Longtodate(ct.TS_ENDTIME) "WorkLog END Time", ct.DESCRIPTION, chfd.UDF_DATE2 AS "Signature Date" FROM ChargesTable ct
Query to get Time calculation of request from created time to resolved / closed status
Version : 10.5 DB : PGSQL SELECT wo.WORKORDERID AS "Request ID", case when (wo.completedtime=0) then null else TO_CHAR(((wo.completedtime-wo.createdtime)/1000 || ' second')::interval, 'HH24:MI:SS') end "Completed Date - created Date", case when (wo.resolvedtime=0)
Update tasks fields from request additional field - again :)
I need to automatically complete the task fields with the start and end date based on an additional field in the request. I have the following script but it doesn't work properly. After launching, it throws the error "{"result":"Failure","message":"Task
Any update on feature for asset replenishment or consumables
We are currently trying to implement SDP MSP to organize our storages to keep track on spareparts and consumables for our MSP sites and our customers. I'm hoping this feature is not far away and that you could prioritize this.
Query to get list of template name, rule name, event, conditions and actions information
Version : 13000 DB : PGSQL OUTPUT: SELECT rd.rulename "Rule Name", rd.usertype "Applies To", rd.jscode "Script", ry.ruletype "Event", rff.fieldname"Field Condition", rcm.condition_string "Condition", rcfv.fieldvalue "field value", raty.actionname "Action
Is it possible to mass produce the replacement templates in the SDP?
from the default template to another, since 5000 templates is changed manually, horror mode
Query to get Active Technician key list with Technician info.
Version : 13004 DB : PGSQL OUTPUT: select au.first_name, techkey.techniciankey, techkey.status from techniciankeydefinition techkey left join AaaLogin al on techkey.LOGIN_ID = al.LOGIN_ID Left join AaaUser au on al.user_id=au.user_id where techkey.status
[Analytics Plus webinar] How analytics-driven IT service management improves employee productivity
Hello folks, We're back with an insightful new webinar on how analytics-driven IT service management can improve employee productivity . Date and time: April 27, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? When faced with a plethora of
Query to get PO Approval Details
Version : 13000 DB : PGSQL / MSSQL OUTPUT: SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", ad.ORG_NAME AS "Account", longtodate(max(po.DATEORDERED)) AS "Created On", (li.name) "Approver Level", (aaa.FIRST_NAME) "Approver Name", (pos1.STATUSNAME)
ServiceDesk Plus MSP - version 14.2 - Build - 14200 Released
Dear User(s) Greetings for the day. We released ServiceDesk Plus MSP - version 14.2 - Build - 14200. A couple of enhancements available along with this release are as follows : Custom Modules :You can now create custom modules that allow you to manage
SDP MSP Upgrade Problem from 10538 to 10600 (sub patch 11100 to 11200)
hi there i am trying to upgrade service desk plus msp with MSSQL database from build 10522 to 13000 (migration sequence is 10522 to 10538 then 10538 to 10600 then 10600 to 10611 then 10611 to 13000) but i get stuck in step 10538 to 10600 this patch have
Worklog auto start timer
Is there any way to have this feature automatically start logging time when a tech opens a request and stop when closed?
Query to get complete Change module info with all sub modules
Version : 10524 DB : MSSQL Output : SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", longtodate("chdt"."CREATEDTIME") AS "Created Time", "chdt"."SCHEDULEDSTARTTIME" AS "Scheduled Start Time", "chdt"."SCHEDULEDENDTIME" AS "Scheduled
query to get Technician list of each request with time taken to resolve.
Version : 13004 DB: PGSQL OUTPUT: SELECT wo.WORKORDERID "Request ID", ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status", pd.PRIORITYNAME "Priority", longtodate(wo.CREATEDTIME) "Created Time", adef.org_name "Account", cast((wo.TIMESPENTONREQ/1000
Query to get Request Attachment details with customer / requester info
Version : 13000 DB : PGSQL / MSSQL OUTPUT : select sda.attachmentid AS "Attachment ID", sda.attachmentname AS "Attachment Name", sda.attachmentpath AS "Attachement Path", sda.attachmentsize AS "File Size", sda.description AS "Comments", wo.workorderid
sd+ MSP support create a new request but another one with same subject already exists
hi ! we have some issues with SD+ MSP (v13.0 Build 13004) it creates a new request while a requeste is already open, same subject, and we do'nt understand why. Requester seems to be the same some exemples (view uploaded logs): 23134 but 22977 already
Adding values from custom fields to task fields - not working
I have a tasks created automatically after receiving a request with additional fields (custom date). Is it possible to set the start date from an additional field and set a reminder 15 minutes before? I tried with this script but it returns errors {"result":"Failure","message":"Task
Setting up a DR Environment
I need to setup a DR/BCP environment for MSP. I have two virtual servers setup in our DR datacenter. My question is does the Production MS SQL Server have to be the same version as the DR MS SQL Server? Has anyone setup anything like this? My plan is
JIRA - ServiceDesk Plus MSP Integration requirement Gathering
Dear Users We are working on JIRA + ServiceDesk Plus MSP integration. As our users we would like to understand your requirements and use cases to fine tune the feature. Please share your use cases which you want to address through this integration with an example for better understanding. You can also send an email to our support email -> sdpmsp@manageengine.com with the details. Thanks for your continuous support Santhosh Head Of Quality Assurance and Helpdesk ManageEngine ServiceDesk Plus MSP Team
Query to get Response dueby time and dueby time change info
Version : 14001 DB : PGSQL OUTPUT: SELECT ti.FIRST_NAME AS "Technician", wo.WORKORDERID AS "Request ID", ad.ORG_NAME AS "Account", longtodate(wo.CREATEDTIME) AS "Created Time", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician",
Upgrading MS SQL Server
Our Service Desk MSP is running on an older version of MS SQL which is now out of support. I have a few questions: 1) If I upgrade the SQL Server what is the risk for the Service Desk? Is this supported? 2) If not and I need to install a new SQL server
Has the Android Mobile App for MSP been released? At least enough features for Field Technicians
Has the Android Mobile App for MSP been released? At least enough features for Field Technicians, if full-feature not feasible.
[Free e-book] The handbook for MSPs to achieve profitability
Hello folks, We're excited to share with you our latest e-book that focuses on nine critical metrics for MSPs to achieve profitability in challenging economic times. In this e-book, you'll discover metrics that can give you multiple perspectives into
Adding values from custom fields to task fields
I have a tasks created automatically after receiving a request with additional fields. Is it possible to copy their content to the task description, set the start date from an additional field and set a reminder 15 minutes before? I tried with this script
How to Bulk Reassign Tickets
I created a new Support Group and moved existing technicians from the old group to the new one. How do I bulk update all their existing tickets to their new support group?
ServiceDesk Plus MSP - version 14 - Build - 14001 Released
Dear User(s) Greetings for the day. We released ServiceDesk Plus MSP - version 14 - Build - 14001. Releasing Account specific Outgoing Mail server configuration, Site 24*7 Integration and more... Please refer to the Migration path and the read me available
Scanned Software
ISDP MSP 14, upgraded yesterday, In my scanned software i see this. Something wrong with it. In FF 109.0.1 is wrong. In Chrome is ok.
PostgreSQL 10 End of Life Today
PostgreSQL 10 is no longer supported as of today per Per postresql.org. https://www.postgresql.org/support/versioning/ My DevSecOps lead has reached out previously to get ahead of this and we were assured that ME would maintain use of supported DB versions.
How to create / adjust user per script
Our environment Version: 13.0 Build 13011 DB: Extern MSSQL How can I build a custom function to create or adjust a user in one step? I get a lot of requests like: make user x, y a technician and give it permissons like user z. I want to build a custom
Pink23 Conference - SDP MSP
Are there any Admins or Powerusers for companies using ServiceDesk Plus MSP planning to be at the Pink23 IT Service Management conference in vegas this year?
Worklog time reporting
When you record a worklog time for a task specifically, even though there are hours put against it, it does not count towards billing. You have to put the worklog against the request itself, and not a specific task.
Infrassist : White - Label Managed IT Services and NOC Services, Professional Services For MSP
We are providing high-quality White Label Managed IT Services and NOC (Network Operations Center) 24*7 Monitoring and Support for your network and also providing Professional Services like M365 solutions, Automation, RMM(Remote Monitoring and Management)
Query to get Solution of particular topic and its first level child topic list and with status filter.
Version : 10524 DB : MSSQL OUTPUT : SELECT solution.solutionid "Solutionid" , kb1.TOPICNAME " Topic", case when kb2.topicname is null then kb1.TOPICNAME else kb2.topicname end "Parent", Solution.TITLE "Subject ", Sol_StatusDefinition.STATUSNAME "Status"
Next Page