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
JIRA integration Error: Check Jira Xml file..
I have set basic configurations and made a menu, but below error pops-out. <Configurations> Attatched Jira.xml & log from Serverlog Parser
[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.
Change browser title icon (favicon) for SDP?
How do I replace the default favicon.ico in ServiceDesk Plus with one of my own? Thank you.
Non Login Technicians
Hi, Is there a way for non login technicians to view a task and close it after they resolved it. We have limited license and would like to utilize the non login technicians however I can send notifications with them but could not login (when clicking the link) to further view and update it. Additionally if they reply back to the email, SDP treat it as new incident request. Please help. If my question is not clear I'll be happy to elaborate further. Thanks
How to Export a CMDB Relationship?
Hello Team, I'm building the CMDB for a client. Once done, the customer will need to export the relatioships that will be created between the items into a file. can you help me please?
Request resolved after open and change area
Is the report reopened and which are changed after the request is solved?
Cannot upgrade to 10500
HI, I have problem with upgrade windows version of Service Desk to version 10500, during step: "Upgrading PostgreSQL from 9.2.0 to 10.5 Migrating Data" it stops and roll back. How could I resolve this issue?
Change ticket due date dependency
Dear team, Can we change ticket due date dependency instead of requester site to be technician site . Note: This requirement issue because we have several sites with different operation hours. Thanks
Manage engine Service desk plus - One of the User not visible under requesters after importing from AD
One of the User not visible under requester's after importing from AD, the log says import successful. however one particular user is not visible under requesters tab. Require your assistance.
(solved)Backup ServiceDesk Plus Database Fails
We are trying to backup database on our old SD+ workstation (Win7) and restore it into our new SD+ workstation (Win10). *The same version of ServiceDesk Plus (8.0.0) is installed on both workstations As far as the backup process we were able to start following below instructions: https://www.manageengine.com/products/service-desk-msp/help/installation-guide/documents/perform-backup.html However the backup seems to fail every time during the process, it says: ERROR: invalid page header in block 1
Supported QR Code Printer
Is there a preferred printer for QR Code? should any laser printer can support QR Code for asset scanning?
[SDF-59846] Show Project ID Within Project
Good afternoon, would it be possible to add the Project ID to either the Project Details or above where the Due Date/Milestones/Tasks are located in the Project? We'd like to be able to reference the Project ID from within the project itself rather than having to back out to the project list to find it. Thank you!
Create Lync Account - Using Custom Menu/Trigger
So our procedure and policies changed on creating lync accounts. This led me to create a powershell script to make this quick and easy, so I decided to share a powershell script I wrote. I hope this helps some people out there. Not promising any support though =D # ------------------ Start Script ------------------ # Store request data passed to script - this must be first element in script param ( $json = "none" ) $jsondata = Get-Content $json -Encoding UTF8 #Encode if necessary $requestdata
Category/Subcategory/Item Taxonomy
Has anyone developed (and is willing to share) a Category/Subcategory/Item taxonomy for all of the standard type of IT Helpdesk and Enterprise Application incidents and services (and problems for that matter)? Any help would be greatly appreciated. Thanks.
IT analytics in 90 seconds: Analyze time spent in different support groups
View a detailed overview of the time spent across your help desk groups using Analytics Plus reports. If you're not already using Analytics Plus, download your free, 30-day trial today.
Asset scan - Wrong Product Type > CIType association
Hi, I have a problem when scanning assets. I'm using the agent and I configured a custom product as you can see in the following picture: The scan finds the exact model -> "Latitude 7490" but sets the CIType to "Server" instead of "Workstation - Laptop". If I try to edit the asset Product Name manually then it gets linked to the right CIType. This is the state right after the scan: Then I click on Actions->Modify Type: and without changing anything I just click Save. Doing so moves the asset directly
Changes in v10, Longwinded procedures closing tickets
Hi, Is it just me or are their more steps involved when closing tickets since V10? In V9 you could simply select the drop down items, enter a work log and then close the ticket. Now you have to enter the worklog separately and the resolution separately meaning more time spent doing the same thing... Can we modify Servicedesk and tailor back to how it was? Cheers,
Pre-configured SDP with basic industry standard templates
Do we have or has anybody tried a pre-configured SDP with basic Industry Standard Template? Reason is we are doing a lot of Client POC, so instead of configuring from time to time Can we create (from back-up) or any other way so that we can load a pre-configured basic or advance configuration with industry standard templates. So that we can just load the back up on every POC request. Any suggestions are highly appreciated. Thanks, Allan
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
Windows Agent - Why port 9000?
Why is it that SDP is using port 9000 on the Windows Agent for scanning and fetching information? Is there a plan to change this in the near future? https://www.speedguide.net/port.php?port=9000
Flexible SDP PM Scheduling
Hello, I would like to see more options for scheduling PM in SDP. In my case, I want to schedule a monthly backup ticket. Since we follow the accounting calendar, we would need to to something like week 4-4-5 (x4) to properly schedule it. It would be nice. Thanks. Marco.
API V1 Powershell Repo
I put together a small repo of some API V1 powershell functions I've built that work for creating requests, adding notes, and updating requests. Feel free to use any of these you like! https://gist.github.com/aggiebck/60efda1eea63431d5a7d8c05f05379e0
Service Desk Build 10501 Slow In Internet Explorer 11
Hi, After successfully upgrading our TEST environment to the most recent Service Build, I am noticing Service Desk is extremely slow in IE 11. This however is not a problem if using Google Chrome, its almost completely the opposite. Any idea's on what could be causing the issue with IE? Thanks
ITIL incident management & SLA & response time
Hello When defining SLA's in SD+, you can configure a response time: What is the criteria for triggering the response time? How does SD+ know that a response has been undertaken for a ticket? Is it the automatic mail to the requester, when a ticket is created in the system? when a technician sends a first mail? when the request status is set to 'in progress' ? Thanks for helping me to understand it. Best regards, Marc
License SDP Expire
Hi Manage Engine Support , We currently use the SDP type subscription, which will end the contract on 5 October 2019. In the meantime, we are processing the contract renewal which is under consideration from the management. Could you please let us know what will happen if we couldn't renew contract before 5 October 2019? Best Regards,
Launching advanced analytics for ServiceDesk Plus' asset management module
Hello folks, We're delighted to announce the launch of advanced analytics for ServiceDesk Plus asset management module. You can now gain a complete overview of your enterprise's IT and non-IT assets—all in one place. With advanced analytics for asset management, you can, Get actionable insight to improve asset performance and software usage. Plan asset purchases, taking into account the complete history of assets such as purchase cost, active life, percentage of depreciation, and residual costs.
links
Does anyone know how i can link the following how do i link requester name, assets, department and site so that when the requester adds their name all of the above are auto populated.
Trigger notifications to requesters
I am looking to notify specific Requesters that a new hire is coming on board. These requesters will be in responsible for creating accounts for said new hires. I have a template setup for our HR team that will come to the IT team when someone is initially hired. I need to be able to perform a task that will notify users that are not technicians so that they can begin creating the accounts for the systems that they are responsible for. What is the most efficient way to do this? Thank you for the
flushing of logfile
Hi, In the logs directory there is a file called sso log. This has the size of almost 1 GB. Is there any way to flush the file automatically? We really don't need log 1 year back, and it should be flushed on a weekly basis. Best regards Thomas
JESPA.LOG file up to 2 GB
Noted this log file is getting pretty big. Properties say it was last modified in 2017. Any reason not to delete it? Path is "Manage Engine\Service Desk\Logs". We are on Service Desk Plus 9400 (soon to be 9411). Thank you.
Copy values from one field to another in bulk
Hi folks, I have a field that was specific to a Service Request that I'd like to replace with a common field, but I have to preserve the data. My thought was to add the common field to the existing template and I was hoping you could provide me with a way to copy the values from one field to the other. In this case, the request field is a date field called "Eff. Date" and I'd like to copy the values from that field to a common field called "Effective Date." Thanks, Adam
Email added to old ticket conversation with no delimiter
Odd thing popped up (Build 10500). We use the standard delimiter ## in the subject of emails. Normally when a user sends an email to the inbox with ##request number## in the subject, that ticket's conversation will get updated with the email. We just had, what strongly appears, to be an old ticket update that did NOT have the ##request number## in the subject. This email should have created a new ticket. I cannot figure out how this happened. The subjects of the tickets were identical. Has new logic
Templates not showing up to Technicians after upgrade to 10503
Dear All after upgrading to version 10503 the request catalog templates displaying all services and incidents stopped showing up for technicians while it is being displayed normally to normal requesters. the problem was faced only after the upgrade while it was working in version 10502 anyone experienced the same issue? thank you
Changing the Additional Field Type
Why is it not possible to change the current format of the field to other format? We currently have fields in use that we would like to change the field format ( Ex. Single Line field is used to with amount by users) but what I can only do is to remove/disable the field and insert the same with different format. But by doing so, we will lose the field in the already created requests and the new field inserted will be blank. It would be tedious to update the existing request one by one.
Next Page