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
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]
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
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
Query to get SLA escalation time difference for each request.
Version:10609 DB:PGSQL OUTPUT: SELECT wo.WORKORDERID AS "Request ID", LONGTODATE(wo.CREATEDTIME) AS "Open date", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", LONGTODATE(wos.LAST_TECH_UPDATE)
Query to get Project details and Worklog timespent details of Project
Version : 10602 DB: MSSQL Output : Query : 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"
Upcoming EOL / Behavior changes in ServiceDeskPlus MSP - 14.0 version
Dear Users Greetings for the day. We are working on the next major release ServiceDeskPlus MSP - 14.0. We are bringing more automation , useful features, New API's, behavioral changes along with this release. This thread gives you the consolidated list
Query to get WorkLog timespent For Request and Project
Version:10500 DB:PGSQL SELECT ad.ORG_NAME AS "Account", COALESCE(wtk.WORKORDERID , wo.workorderid) "Module ID", to_timestamp((ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time",'Request' "Module", CONCAT(COALESCE(TRUNC(sum(ct.TIMESPENT)/3600000,0)),'
ServiceDesk Plus MSP - version 13 - Build - 13002 Released
Dear User(s) Greetings for the day. We released ServiceDesk Plus MSP - version 13 - Build - 13002. Please refer to the Migration path and the read me available to upgrade your SDP MSP instance. Please do the upgrade only in a test environment first and
What email commands are limited to a requester?
This comment was in another question; "If the email is sent from the requester's email address, the requester can perform limited actions with the email command, such as creating." Is this documented anywhere to show the email commands available to a
outlook sync ?
Hi. Is it possible to synchronize local Outlook calendar with schedule on ServiceDesk ? I suggest to change the schedule view in Service Desk. Would be the best - view like Outlook calendar where I see the day divided into hours... Maybe it's possible to export data from ServiceDesk schedule to Outlook calendar?
Deprecation of basic authentication in Microsoft Exchange Online
Dear users, As you maybe aware, Microsoft has announced that it will start disabling basic authentication for Outlook, EWS, POP, IMAP, EAS, and RPS protocols in its Exchange Online effective October 1, 2022. https://docs.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basic-authentication-exchange-online
Update to 10511 from 8.3
Hi, I would like to know how to update the SDP from the build 8310 to 10511. I looked for the version I have in https://www.manageengine.com/products/service-desk/on-premises/migration-sequence.html but I didn't find it.
My SD MSP won't upgrade to 13.0
after upgrade from updatemanager, info from admin panel still is 10.6 instead 13. What's wrong with it? Twoja wersja : 10.6 kompilacja 10609 Ostatnia wersja : 13.0 kompilacja 13001 Baza danych : postgres
Default PGSQL username and password & superadmin username and password for servicedesk plus msp version 13.0 build 13000
Default PGSQL username and password & superadmin username and password for servicedesk plus msp version 13.0 build 13000
Project Template Creation Role
I would like to give my Project Managers ability to create Project Templates. Is there any way to create a Project Creation Role without giving SDAdmin role which has access to everything?
How to customize logo in j_security_check
Hello Support, How to customize logo (instead ServiceDeskPlus MSP) on j_security_check page after we enabled two-factor authentication? Thank you
OAUTH Support for Office 365 Email
Does anybody have a working solution for email for SDP+MSP, when all you have is a brand-new Office 365/Azure tenant without access to the Exchange Legacy API (new tenants do not get this).
Account disabling
hi! Is it possible to disable Account instead of it's deletion?
Upcoming End-of-Life of Request Admin V1 APIs
Dear users, This announcement is to inform you that we have plans to process End-of-life (EOL) for Request Admin V1 APIs and Worklog V1 as a part of the 2022 Q3 release(Next SDP MSP major release). Post that release, any upcoming releases will not have
SSL Certificate Issues
Hey, community! I'm having some troubles with getting SSL to work happily with ServiceDesk Plus. With Microsoft deprecating basic authentication for Exchange Online, and OAuth requiring SD+ to be in HTTPS mode, this is a brand new problem (we host on-premises,
Logon Failure: unknown user name or bad password
I'm having a problem regarding the email search it's saying that the username or password is incorrect but I already checked, and even then I'm still having problems I've already checked if the connection to the email server is blocked using: telnet mailservername:port(995)
Presenting ServiceDesk Plus MSP version 13: Zoho's AI Zia, Teams and Outlook integrations, and more
Hello there, Greetings from the ServiceDesk Plus MSP team! We know firsthand that running an MSP business entails dealing with a flurry of unexpected challenges. With some of these in mind, we have worked tirelessly to improve ServiceDesk Plus MSP
two schedulated reports in the same email one off is false and i can't disable it
hello every one , i have a weekly reports that i schedulated every monday but the mail contains two attached reports one off them is false i don't know why is sending with the original reports how can disable it in the attachments you will find more
Adding an approval with a custom trigger on a request in ServiceDeskPlus MSP
Since i see a lot of admins having trouble making this work, i am posting a walkthrough i made with a working python script. How to add approval workflow on a request in SDP & SDP MSP with automatic approval send, using python Warning : This procedure works only for requests created through ServiceDesk portal. This will not work with email fetching. Step 1: Install python on the server that SDP or SDP MSP is running. On installation procedure select to add the PATH as well. Python version that
Upcoming EOL and Behavior changes of API in SDP MSP 13.0 release
Dear User(s) Greetings for the day. This is a consolidated announcement about our upcoming EOL and Behavior changes of API in ServiceDesk Plus MSP (SDP MSP) 13.0 release. We are working on our next major release ServiceDesk Plus MSP - 13.0. This release
ServiceDesk Plus MSP - version 10.6 - Build - 10609 Released
Dear User(s) Greetings for the day. We released ServiceDesk Plus MSP - version 10.6 - Build - 10609. Please refer to the Migration path and the read me available to upgrade your SDP MSP instance. Please do the upgrade only in a test environment first
Auto align text to the right
Hey We have Hebrew speaking technicians and the want the text in "reply" to be auto aligned to the right instead of left.. is it possible?
Worklog Queries for various modules
Worklog Queries Database : PGSQL Request Charges SELECT COALESCE(wtk.WORKORDERID , wo.workorderid) "Request ID", CASE WHEN (tk.TASKID) IS NOT NULL THEN (wo2.TITLE) ELSE (wo.TITLE) END "Title",cast((ct.TIMESPENT/1000 * interval '1 second') as varchar) "Time Spent",to_timestamp((ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time", rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable ct LEFT JOIN WorkOrderToCharge wotoc ON ct.CHARGEID=wotoc.CHARGEID LEFT JOIN WorkOrder wo ON wotoc.WORKORDERID=wo.WORKORDERID
How do you find saved attachment
How do you easily find an attachment that has been saved in MSP? I have located the location where all of the attachments are saved.(M:\Attachments\fileAttachments\Request) However, the files are stored in numbered folders. The number on the folder does
Automatically close tickets with no interactions, but through a native function on SDP
Hi, i would like to request a native functionality on SDP MSP, that auto closes tickets that doesn't have any interactions. I know it is possible today with scripts. Here's the link i used for reference: https://pitstop.manageengine.com/portal/en/kb/articles/ews-mail-configuration-script-to-send-reminder-emails-to-both-requesters-and-technicians-when-there-is-no-response-for-more-than-a-specific-time-period-and-auto-close-the-ticket
Service Desk Plus MSP Users
Hi, we purchased SDP MSP. We have 10 Accounts Managers that manage several customers. They open presale requests and sometimes they need to open tickets to attend their customers. We´ve not been able to assign permission for this Account Managers to "see"
ManageEngine SupportCenter Plus version 11.0 - Build - 11024 released
Dear User(s) We released SupportCenter Plus version 11.0 - Build - 11024. Please refer the Migration path table available here and upgrade to our latest build 11024. Enhancements: SCP-1547 : Option to include the Bcc field in the emails from SupportCenter
ServiceDesk Plus MSP - version 10.6 - Build - 10608 Released
Dear User(s) Greetings for the day. We released ServiceDesk Plus MSP - version 10.6 - Build - 10608. Please refer to the Migration path table available here and upgrade to our latest build 10608. What's new in 10608? Major Enhancements SDPMSP-13172: Support
add Ukraine translation
Hello. please add Ukraine translation UI
Next Page