[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"
Query to get Contracts Expiring in 30 days
Version : 13000 DB : PGSQL SELECT mcdt.CONTRACTNAME AS "Contract Name", Vendors.NAME as "Vendor Name", longtodate(mcdt.FROMDATE) AS "From Date", longtodate(mcdt.TODATE) AS "To Date", ad.ORG_NAME AS "Account", cst.STATUSNAME AS "Contract Status", cadf.UDF_CHAR1
Query to get Status change info from particular status to others
Version : 10609 DB : MSSQL & PGSQL OUTPUT : SELECT wo.WORKORDERID AS "Request ID", LONGTODATE(wo.createdtime) AS "CREATEDTIME", sisd.STATUSNAME as "Changed From", sinsd.STATUSNAME as "Changed To", aaa.first_name as "Created By" FROM WorkOrder wo LEFT
Export Site Data and import to another site
Is there a way to export all the site data from one account to another account in servicedesk plus msp ver 14
Query to get Asset Harddisk and software Information
Version : 13000 DB :MSSQL OUTPUT : SELECT MAX("workstation"."WORKSTATIONNAME") AS "Machine Name", MAX("ad"."ORG_NAME") AS "Account", MAX("resource"."ACQUISITIONDATE") AS "Acquisition Date", MAX("resFields"."UDF_CHAR6") AS "Asset Description", MAX("state"."DISPLAYSTATE")
File Attachment in announcements section
Hi, Is there any way I can attach the file in the announcements?
Looking for query for Account Details after 10.6
Recently switching from 10.5 to 10.6, some custom PowerBI reports stopped working seemingly due to database changes. Connecting with ODBC, I can see that while the accountci table used to be tied to the accountdefinition table by the ciid value on each,
Notification email, send to account manager as well as requestor
Dear ME Team, We need our account manager to receive notifications with the tickets that we raised to the customers. Could you please advise how to do that. The scenario that we are expecting, once the service desk team receive or log an ticket, the internal
Query to get Due date difference calculation in hours.
Version : 10609 DB : Postgres Output: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", wo.TITLE AS "Subject", std.STATUSNAME AS "Request Current Status", longtodate(wh.operationtime) AS "Due Date changed",
Query to get Project and worklog detailed information
Version : 13000 DB : PGSQL OUTPUT: SELECT projectdet.PROJECTID AS "Project id", projectdet.TITLE AS "Project NAME", ad.ORG_NAME AS "Account", projectestimations.TOT_TASKHOURS_COST AS "Actual Cost", projectdet.ACTUALENDTIME AS "Actual end", projectestimations.ACTUALTASKHOURS
Query to get First Assigned Tech info including Auto Assign details
Version : 10609 DB : MSSQL & PGSQL OUTPUT : SELECT wo.WORKORDERID "Request ID", Longtodate(max(wo.CREATEDTIME)) "Created Time", longtodate(min(woa.executedtime)) "Assigned time", max(aau.FIRST_NAME) "Requester", max(wo.TITLE) "Subject", max(qd.QUEUENAME)
ManageEngine ServiceDesk Plus MSP version 14.0 is available !!
Dear Users, Greetings for the day. I am excited to announce the availability of ManageEngine ServiceDesk Plus MSP version 14.0 (Build 14000) is now available. ManageEngine ServiceDesk Plus MSP is getting better and better !!! I thank all our users for
Query to get Survey info with custom filter
Version : 10609 DB : MSSQL & PGSQL OUTPUT: SELECT wo.WORKORDERID AS "Request ID",longtodate(srm.responsetime) AS "Responded Date", longtodate(srm.SENDTIME) AS "Survey Created Time", smn.SURVEYNAME AS "Survey Name", AaaLogin.NAME AS "Username Received
Query to get Request details with SLA and Group change info
Version : 10524 DB : MSSQL Output: SELECT wo.WORKORDERID "Request ID", wo.TITLE "Subject", reqtl.TEMPLATENAME "Template Name", std.STATUSNAME AS "Request Status", serdef.NAME AS "Service Category", sladefinition.slaname "SLA NAME", convert(varchar(5),((wo.TIMESPENTONREQ))/1000/3600)+':'+convert(varchar(5),(((wo.TIMESPENTONREQ))/1000)%3600/60)+':'+convert(varchar(5),
Query to get Request details with resolution and resolved time calculation.
Version : 10537 DB : Postgres Output: SELECT LONGTODATE(wo.CREATEDTIME) AS "Created Time", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", cd.CATEGORYNAME
Query to get Software Summary info
Version : 10609 DB : MSSQL & PGSQL OUTPUT : SELECT wssl.SOFTWARENAME AS "Software Name", swmfg.NAME AS "Manufacturer", wmiswui.SOFTWAREUSAGE AS "Software Usage", wsst.SOFTWARETYPE AS "Software Type", wssc.SOFTWARECATEGORY AS "Software Category", wssct.COMPLIANCETYPE
When can we have Facilities Management for MSP?
Kindly add the facilities management module to the MSP version. It would be a game-changer for us and our customers! In addition, it would create efficiencies in the following; 1. Cabling (new & upgrade) & ICT fit-out in campuses (Bank branches, Education
Query to get Asset details
Version : 10609 DB : Postgres OUTPUT: SELECT MAX(workstation.WORKSTATIONNAME) AS "Machine Name", resource.resourcename "Asset Name", MAX(rtype.TYPE) AS "Device Type", citype.TYPENAME AS "Product Type", MAX(net.ipaddress) "IP Address", MAX(workstation.MANUFACTURER)
Query to get Requester details with login info.
Version : 10609 DB : MSSQL OUTPUT: SELECT AaaUser.FIRST_NAME "First Name", AaaUser.last_name "Last Name", adef.org_name "Account Name", sdo.name "Site Name", AaaContactInfo.EMAILID "E-mail", sduser.jobtitle, ar.name "Role", AaaContactInfo.landline, AaaContactInfo.mobile,
kanban bard and manage engine
is it possible to track sdp tickets on kanban board ?
Query to get Request details with requester and Notes details
Version : 13001 DB : PGSQL & MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", "aau"."FIRST_NAME" AS "Requester", "wo"."TITLE" AS "Subject", "ti"."FIRST_NAME" AS "Technician", "pd"."PRIORITYNAME" AS "Priority", "wotodesc"."FULLDESCRIPTION" AS
Query to get Request Details and Date field in Custom Format
Version : 10609 DB : PGSQL OUTPUT: SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", pd.PRIORITYNAME AS "Priority", impdef.NAME AS "Impact", urgdef.NAME AS "Urgency", rtdef.NAME AS "Request Type", to_char(from_unixtime(wo.CREATEDTIME/1000),'DD
Query to get Request details and first technician assigned
Version : 10609 DB : MSSQL OUTPUT: SELECT "wo"."WORKORDERID" AS "Request ID",aauTech.FIRST_NAME As "First Technician", CASE WHEN (wo.is_catalog_template) = 'false' THEN 'Incident' ELSE 'Service Request' END "Request Type", "wo"."TITLE" AS "Subject", "mdd"."MODENAME"
Query to get Change Auto closure info
Version:10600 DB: PGSQL OUTPUT: SELECT chdt.CHANGEID AS "change_id", max(stageDef.DISPLAYNAME) AS "Stage", max(statusDef.STATUSDISPLAYNAME) AS "Status", longtodate(max(operationtime)) "Operation time" FROM ChangeDetails chdt LEFT JOIN Change_StageDefinition
Custom task trigger missing
Hello, I would like to add a custom task script, but can not find menu. Can you tell me how to add custom task triggers. https://www.manageengine.com/products/service-desk-msp/help/adminguide/requests/tasks/task-custom-trigger.html
Problem updationg from SD MSP 10538 to 10600
Hi, i am trying to upgrade from 10538 to 10600 but during patch installation i get error: Any ideas what is - No constraint with this name [OutgoingEWSServer_UK0] is defined (full update log attached) 14.01.2023 17:37:40 [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor]
Query to get Change approval details and Change role info of one particular role.
Version : 10609 Database : MSSQL OUTPUT: Query to find Change Role ID : select chrol.name,chrolusermap.ROLEID from changeroles chrol LEFT JOIN changeroleusermapping chrolusermap on chrolusermap.roleid = chrol.ID where chrol.name = 'Initimation' Note :
Query to get Service Request Approval Details
Version : 10609 Database : MSSQL Output: SELECT "wo"."IS_CATALOG_TEMPLATE" AS "Service Request", "serdef"."NAME" AS "Service Category", "appStDef"."STATUSNAME" AS "Approval Status", "cd"."CATEGORYNAME" AS "Category", "ti"."FIRST_NAME" AS "Technician",
Query to get Request Details with Group change info and Technician Timespent info
Build: 10609 Database: MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", LONGTODATE("wo"."CREATEDTIME") AS "Created Time", LONGTODATE("wo"."RESOLVEDTIME") AS "Resolved Time", "cri"."FIRST_NAME" AS "Created By", "aau"."FIRST_NAME" AS "Requester",
[Security advisory] Authentication bypass vulnerability in Active Directory/LDAP authentication
This security advisory addresses the authentication bypass vulnerability in ServiceDesk Plus MSP due to value override in required entries for LDAP authentication. This vulnerability affects customers using versions 10600 to 10610 and 13000 to 13003 of
Next Page