Request Management - query to fetch information on service catalog additional fields
Requests with service catalog additional fields. Service catalog additional fields can be a common field or category specific fields. These fields are stored in a dynamic table, hence we need to join the specific template to get the resultant. Run the below query to get table name and column name of the field you need in the report. select * from columnaliases where aliasname='NAME OF THE ADDITIONAL FIELD'; Replace table name and column name in the below query. SELECT wo.WORKORDERID AS "Request
Request Management - report to find the recipient email address
To find the recipient email address. Some requests are forwarded to others through the mail, this report helps to find the statistics what and how many requests are forwarded to others. To make any changes to this query, refer to this post. SELECT wo.workorderid "RequestID", wo.title "Subject", wor.to_cc_bcc "Parent Request", wor.recipient_email "Parent request email ", cr.TO_CC_BCC " In conversations", cr.recipient_email "Conversation email", nr.TO_CC_BCC "Sent mails", nr.recipient_email "Sent mail
SQL Cookbook for ServiceDesk Plus - Chapter 2 - Request Process Management
Requests based on SLA. To make any changes to this query, refer to this post. SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", cd.CATEGORYNAME AS "Category", scd.NAME AS "Subcategory", icd.NAME AS "Item", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", sla.slaname "SLA Name" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrder_Queue
Request Management - to get the list of shared requests
Shared request - returns the list of shared requests. To make any changes to this query, refer to this post. SELECT wo.WORKORDERID AS "Request ID",
wo.TITLE AS "Subject",
aau.FIRST_NAME AS "Requester",
qd.QUEUENAME AS "Group",
ti.FIRST_NAME AS "Technician",
std.STATUSNAME AS "Request Status",
sa.first_name "Shared to technician" FROM WorkOrder wo
LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID
LEFT JOIN WorkOrderStates
Request Management - report to get information on linked requests
Linked requests - to find the child request ID that are linked to the parent request ID. To make any changes to this query, refer to this post. SELECT wos.linkedworkorderid "Request ID", wo.TITLE "Subject", std.STATUSNAME "Request Status", rtdef.NAME "Request Type", longtodate(wo.CREATEDTIME) "Created Time", wo.workorderid "Linked to" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT
Request Management - Report to get information on merged requests
Merged requests - provides information as shown in screenshot below. To make any changes to this query, refer to this post. MSSQL: SELECT Workorderid "Parent Request ID",
(SELECT STUFF(
(SELECT cast(Child_woid AS varchar) + char(10)
FROM conversation co
WHERE conversation.Workorderid=co.Workorderid
FOR XML PATH ('')), 1, 0, '')) "Merged Request"FROM conversation
WHERE Child_woid IS NOT NULL
GROUP BY Workorderid PGSQL:
Request Management - quick overview of monthly opened, closed and overdue requests
This report provides a quick overview of monthly opened, closed and overdue requests. It provides you a quick determination of a large number of requests. This information can then be used by a request management administrator to determine if a particular department requires additional resources to efficiently manage the number of requests. MSSQL: SELECT 'Inbound' "Status", COUNT(CASE WHEN MONTH(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00'))=1 THEN 1
Masterclass – Hardware asset management: Bringing all your assets under one roof - session 3 June 12th
Hi folks, We had hosted a webinar June 12th on Hardware asset management: Bringing all your assets under one roof using ServiceDesk Plus, the third session of our Masterclass series. We have talked about how you can use Service Desk Plus to: Inventory all the assets in your organization Organize and classify assets based on business impact Identify vulnerable assets Track the status of assets Using examples, we have demonstrated how to manage vulnerable assets with complete visibility into your
Introducing brand new OS Deployer!
Dear all, We are happy to inform you that we have introduced a brand new OS Deployer with a more friendly user interface, fresh features and advanced techniques. You can refer our website for more details on this - https://www.manageengine.com/products/os-deployer/ Useful Resources: Userguide - https://www.manageengine.com/products/os-deployer/help/ How-tos - https://www.manageengine.com/products/os-deployer/how-to.html Knowledge bases - https://www.manageengine.com/products/os-deployer/knowledge-base.html
[Webinar recording] Deliver next-level customer support using advanced analytics for your service desk
Did you miss our webinar on delivering next-level customer support using advanced analytics for your service desk? Check out the recording to learn about providing satisfactory resolutions, empowering users, keeping your desk technicians happy, and more.
Mozilla fixed Zero-day vulnerabilities in Firefox
Mozilla addressed two zero-day vulnerabilities in Mozilla Firefox that were being used in targeted attacks in the wild. CVE-2019-11707 is a type confusion vulnerability in Mozilla Firefox that can result in an exploitable crash. CVE-2019-11708 is a sandbox escape vulnerability. Combining both CVE-2019-11708 and CVE-2019-11707, attackers can perform arbitrary code execution. Thunderbird is also affected but generally cannot be exploited since scripting is disabled when reading mail. Following this,
Mozilla fixed Zero-day vulnerabilities in Firefox
Mozilla addressed two zero-day vulnerabilities in Mozilla Firefox that were being used in targeted attacks in the wild. CVE-2019-11707 is a type confusion vulnerability in Mozilla Firefox that can result in an exploitable crash. CVE-2019-11708 is a sandbox escape vulnerability. Combining both CVE-2019-11708 and CVE-2019-11707, attackers can perform arbitrary code execution. Thunderbird is also affected but generally cannot be exploited since scripting is disabled when reading mail. Following this,
Request Management - most used request template, category and top requesters based on request count
To make any changes to these queries, refer to this post. Report to find the most used template in the application: SELECT serd.Name "Service Category", reqtl.templatename "Template name", count(wo.WORKORDERID) "Count of Request" FROM WorkOrder wo
LEFT JOIN RequestTemplate_list reqtl ON wo.TEMPLATEID=reqtl.TEMPLATEID
LEFT JOIN ServiceDefinition serd ON reqtl.PARENT_SERVICE=serd.SERVICEID
WHERE reqtl.isdeleted='0'
GROUP BY serd.Name,
reqtl.templatename
ORDER BY 3 DESC To find top used category
Request Management - requests based on incident and service templates
To make any changes to this query, refer to this post. Request based on incident and service templates: SELECT reqtl.TEMPLATENAME "Template Name", wo.WORKORDERID "Request ID", dpt.DEPTNAME "Department", sdo.NAME "Site", cd.CATEGORYNAME "Category", scd.NAME "Subcategory", std.STATUSNAME "Request Status", ti.FIRST_NAME "Technician" FROM WorkOrder wo LEFT JOIN RequestTemplate_list reqtl ON wo.TEMPLATEID = reqtl.TEMPLATEID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID = dpt.DEPTID LEFT JOIN SiteDefinition
ServiceDesk Plus 10503 Released
Dear Users, We are glad to announce the release of latest servicepack 10503 for ServiceDesk Plus. This servicepack includes 18 new features and behaviour changes. Take a quick tour of our new features. Check out our Readme for more and download the servicepack here. Try our demo before upgrade. Step by step installation process can be accessed here. Regards, Edwin Vasantha Kumar Servicedesk Plus Team
Configuring category, subcategory and item (CSI) in a helpdesk software
Hello folks, Documenting requests help determine how they move through an organization. Today, most ServiceDesk software utilizes three crucial layers to classify requests: categories, subcategories and items. These three key factors of requests can have a huge impact on the success of the ServiceDesk, as they will have huge impact on reporting, SLA constructions, priority degree, the paths requests take throughout the workflow and so on. Culturally, the requester enters a category, subcategory and
ServiceDesk Plus MSP - version 9.4 - Build - 9419 Released
Dear User(s) We released ServiceDesk Plus MSP - version 9.4 - Build - 9419. Please refer the Migration path table available here and upgrade to our latest build 9419. Please refer our read me from here. New Features : SDPMSP-13194 : EWS Support - Use Exchange Web Services to connect to an exchange server for mail fetching. Issues Fixed : SDPMSP-13301 : Insecure Direct Object Reference vulnerability (CVE-ID-2019-8394) in File Upload sections of the application. SDPMSP-13336 : Preventive Maintenance
[Announcement]: Free OpManager training series starting July 10, 2019
Hola Amigos! With how popular the OpManager training series was in April, we've decided to continue it through July as well! Join us on July 10 to learn about new features, interesting business scenarios, and much more. In this training session, we'll get to the bottom of various challenges of server and network performance monitoring. Register now! A quick look at what you'll learn about: Adding devices into OpManager and automating configurations using the rule engine Monitoring device availability
Join our free ITOM Dubai workshop and resolve your application and server monitoring woes!
Save the date! Our IT Operations Management workshop is coming to Dubai on July 22, 2019. We have interesting sessions on server and applications monitoring that are aimed to help you meet your business demands. This workshop will guide you on the various ways through which you can ensure seamless application performance. You can participate in the interactive demos of our solutions and learn how to get the most out of your IT while getting certified as an ITOM expert. You can connect with our product
Microsoft Patch Tuesday updates for June 2019
New Security Bulletins : 2019-06 Security Update for Adobe Flash Player for Windows (KB4503308) 2019-06 Security Only Quality Update for Windows Server 2008 (KB4503287) 2019-06 Security Only Quality Update for Windows 7 and Windows Server 2008 R2 (KB4503269) 2019-06 Security Only Quality Update for Windows Server 2012 (KB4503263) 2019-06 Security Only Quality Update for Windows 8.1 and Windows Server 2012 R2 (KB4503290) 2019-06 Cumulative Update for Windows 10 Version 1607 and Windows Server 2016
Microsoft Patch Tuesday updates for June 2019
New Security Bulletins : 2019-06 Security Update for Adobe Flash Player for Windows (KB4503308) 2019-06 Security Only Quality Update for Windows Server 2008 (KB4503287) 2019-06 Security Only Quality Update for Windows 7 and Windows Server 2008 R2 (KB4503269) 2019-06 Security Only Quality Update for Windows Server 2012 (KB4503263) 2019-06 Security Only Quality Update for Windows 8.1 and Windows Server 2012 R2 (KB4503290) 2019-06 Cumulative Update for Windows 10 Version 1607 and Windows Server 2016
[Free webinar] Deliver next-level customer support using advanced analytics for your service desk
Hello folks, We're hosting our next webinar on June 27, 2019 titled, Deliver next-level customer support using advanced analytics for your service desk. Agenda: During the session, we'll talk about how you can leverage analytics to assess help desk operations and behavior, and draw actionable insights to improve customer service. Join us for a free session and learn how to leverage analytics to, Make it easy for customers to raise requests. Make the first response count. Empower users. Identify
ManageEngine ITOM Australia Seminar - Learn to overcome IT management challenges!
We are elated to announce that we are all set to host a free IT Operations Management seminar in Sydney and Melbourne on July 16th and 18th respectively. Our product experts will walk you through on the various challenges faced while monitoring servers, networks, and applications. Register now Highlights : 1. Interactive product demos 2. One-on-one question and answer sessions. Agenda: View the entire agenda
.MDMP files
Hello users, Lately we have been receiving requests related to piling-up of .MDMP files in the directory ../ManageEngine/ServiceDesk/bin. We would like to inform you that these are dump files generated by operating system on the event of application crash. It contains data from the application's memory state at the time of crash. Reference: https://community.tableau.com/thread/251030 We would not require these .MDMP files and can safely be moved to a different location. Ensure ServiceDesk Plus gets
Discussion on Masterclass training: "Service request: Employee Onboarding simplified" Date : 14-05-19
Hello users, Feel free to post your questions for an interactive discussion in regards to the training topic- "Service request: Employee Onboarding simplified" which will be conducted on the following date : 14-05-19 ( we are locking down this post for time being and will be available for discussion on 14th ) Reference link : https://pitstop.manageengine.com/portal/community/topic/masterclass-%E2%80%93-servicedesk-plus-online-training-series-starts-may-14th
Launching advanced analytics for ServiceDesk Plus ticket history, projects, and knowledge base modules.
Hello there, We're happy to announce the launch of the latest version of Analytics Plus 3950. This release introduces out-of-the-box analytics for the following ServiceDesk Plus modules: 1. Ticket history Closely track your tickets from start to finish. Get visual clues into the number of times a ticket was reassigned, and use this information to identify bottlenecks in your ticketing process. 2. Projects Take complete control of your IT projects from planning, resource allocation,
Highly critical processor chip flaw "ZombieLoad" patched
A new class of processor chip vulnerabilities targeting the 'speculative execution' portion of Intel chips has been discovered by a group of researchers a few days back. These three vulnerabilities are named ZombieLoad, fallout, and RIDL (Rogue In-flight Data Load). These flaws are rated highly critical by the team of researchers who discovered them. ManageEngine Desktop Central now supports patches for the ZombieLoad vulnerability. Name of the Vulnerability: ZombieLoad Severity : Highly critical
[Release announcement] Launching advanced analytics for ServiceDesk Plus MSP's request history, projects, and knowledge base modules.
Hello there, We're happy to announce the launch of advanced analytics for three more ServiceDesk Plus MSP modules: request history, projects, and knowledge base management. Request history—Visualize the complete request timeline, from ticket creation to ticket resolution, and get clues into the number of times a ticket was reassigned. Use this information to identify bottlenecks in your ticketing process. Projects—Plan, manage, and monitor IT projects from a single console. Track project progress
ZOHO Reports and SDP MSP Integration Update
Dear user(s) Due to a major update in ZOHO reports cloud framework, SDP MSP + ZOHO Reports integration will not work if the SDP MSP instance is less than 9418 build. We are providing 2 months time period for all users who are using this integration to upgrade their SDP MSP instance. Post this period, the framework will be updated in the cloud and the restriction will be get into effect. I request your co-operation in this regard and upgrade the SDP MSP instance. Please refer here to upgrade the
[Free Seminar] Secure your organization's endpoints against the latest cyberattacks and security vulnerabilities
Be it WannaCry, Meltdown, Spectre or Petya each year bears witness to new cyberattacks and security vulnerabilities, and the year 2019 is no different. From the BlueKeep vulnerability that affects over a million systems, to the ZombieLoad attack that affects nearly every Intel chip since 2011, IT teams across the globe face an uphill battle this year to secure their organization's desktops and mobile devices. Organizations irrespective of the industry they cater to, are often caught unawares by
[Free Seminar] Secure your organization's endpoints against the latest cyberattacks and security vulnerabilities
Be it WannaCry, Meltdown, Spectre or Petya each year bears witness to new cyberattacks and security vulnerabilities, and the year 2019 is no different. From the BlueKeep vulnerability that affects over a million systems, to the ZombieLoad attack that affects nearly every Intel chip since 2011, IT teams across the globe face an uphill battle this year to secure their organization's desktops and mobile devices. Organizations irrespective of the industry they cater to, are often caught unawares by
[Free Seminar] Secure your organization's endpoints against the latest cyberattacks and security vulnerabilities
Be it WannaCry, Meltdown, Spectre or Petya each year bears witness to new cyberattacks and security vulnerabilities, and the year 2019 is no different. From the BlueKeep vulnerability that affects over a million systems, to the ZombieLoad attack that affects nearly every Intel chip since 2011, IT teams across the globe face an uphill battle this year to secure their organization's desktops and mobile devices. Organizations irrespective of the industry they cater to, are often caught unawares by
ServiceDesk Plus startup issue post 10500 build upgrade
Hello users, As you maybe aware that Java Runtime Environment (JRE) has been upgraded to the build 1.8 in ServiceDesk Plus 10500 build. So far, we have had handful of users reporting startup issue post 10500 successful upgrade and most of the cases found to occur as the application tries to start using JRE 1.7. This occurs due to environmental restrictions with renaming the folders. In case if you are facing start-up issues post 10500 build successful upgrade and happened to find the below traces
Mobile Device Manager Plus- Free Training
Join us on 13th and 20th June 2019 at 6:30 GMT or 11:30 EDT for a free training session on ManageEngine's enterprise mobility management solution - Mobile Device Manager Plus! Following topics will be covered on June 13th: App Management and Device Security: Complete management of Store and Enterprise apps Lock specific apps to devices Remotely track and troubleshoot mobile devices Secure misplaced/lost device Following topics will be covered on June 20th: Device Enrollment and Provisioning: Various
Newsletter de Mayo!
¡Newsletter de Mayo! Actualízate sobre todas las novedades que tenemos este mes y recuerda inscribirte aquí para recibirlos mensualmente en tu buzón de correo
ServiceDesk Plus MSP - version 9.4 - Build - 9418 Released
Dear User(s) We released ServiceDesk Plus MSP - version 9.4 - Build - 9418. Please refer the Migration path table available here and upgrade to our latest build 9418. Please refer our read me from here. Please note the Major Behavior changes Update below. Ability to move request from an account to another is restricted. It will work only in the following cases. If the requester of a ticket is an actual end user (not technician), then the new site will be associated if that site belongs to the requester’s
Major Behavior change Update - 9416 release - SDP MSP
Hi Users Greetings for the day. We did a major behavior change in our 9416 release of ServiceDesk Plus MSP. This is taken as a precautionary step of security. We request all your understanding on this and share your feedback in case if this change affects you. I request all users to post your valuable comments in this thread or contact us at sdpmsp@manageengine.com for any clarification. As SDP MSP targets MSP users who supports different organization (companies), we are restricting the request movement
[Webinar recording] Busting analytics myth: Can analytics really help you improve help desk processes?
In case you missed our live session, here's a recording of the webinar:
[Important] Migration of Central Patch Repository server; If you've whitelisted Central Patch Repository server's IP address from firewall, attention!!
Hello peeps, We've got an important announcement. To support our increasing customer base and to meet the future demand, we are migrating our current patch repository server - patchdb.manageengine.com to a static alternative. For users who've white listed the current patch repository server's IP address in their firewall, we request to contact our support team for details of the latest patch repository IP address. This migration will take place on 30-May-2019. So, we suggest our users to contact
Discussion on Masterclass training: "Service request: Employee Onboarding simplified" Date : 15-05-19
Hello users, Feel free to post your questions for an interactive discussion in regards to the training topic - "Service request: Employee On boarding simplified" which was conducted as webinar on 15-05-19 We will post the webinar video shortly, which will be follow by questions and answers which were discussed with participants after the session. Please watch the webinar video and feel free to discuss your questions with us, we will be more than happy to assist you. Refer the link below, to know
Next Page