How to remove a Scheduled Report Created By Another Technician
Several scheduled reports were created by a technician who is no longer with the company. How can I disabled the report. The technician's account has been removed from Service Desk? I have a similiar situation with ADSelfService. Thanks, AP3
LDAP Connection problem
Hello, I'm trying to install ManageEngine ServiceDesk Plus 7.6.0 Build 7604 and then upgrade it to Build 7605 by installing Service Pack. But when i configuring LDAP settings, i got an connection like this: FAILURE :Domain Controller saved successfully. But error occurred while trying to connect with LDAP Server - Please check your inputs. I try to connect to Domain Controller on Port 389 with telnet and there isn't any connection problem! Please help...
Report Request - Task assigned
Hi, I have searched and searched but can't find a report that shoes task assigments. If Team A owns a request and assigns a task to Team B - I need a report showing that a task was assigned to Team B. Currently everything I can find show that Team A created a task. Team B never gets credit in the report.
Survey Report Help
I get a report weekly (query below) of survey responses for the last week. I need to edit this query to have all surveys from 2019-10-01 to 2020-04-25 in the same format. I cant seem to get it to pull the correct timeframe and i also don't know if i am pulling everything, or if some of these are archived. SELECT wo.WORKORDERID AS "Request ID", max(wo.TITLE) AS "Request Title", max(aau.FIRST_NAME) AS "Requester", max(ti.FIRST_NAME) AS "Technician", max(srcmt.COMMENTTEXT) AS "Comments", longtodate(max(srm.SENDTIME))
Query to retrieve Technician and Requestor Ticket Convos - URGENT
Hi Folks - I need a MSSQL query to retrieve the Technician and Request communication History. I have tried this query but nothing is executing. select nw.workorderid "Request ID", nw.notificationid "Conversation ID", 'Outgoing' "Conversation type", DATEADD(s,datediff(s,getutcdate(),getdate())+(n.notificationdate/1000),'01-01-1970') "Sent on", aau1.first_name "From", nr.recipient_email "To", n.notificationtitle "Subject", nd.description "Conversation", sd.attachmentname "Attachment" from notificationtodesc
First Response on ticket
Hi We want to know the time taken for first response on ticket..Is this possible
Query Report Request
Can I have the query below show the version of the software as well? It just shows the software name. I need versions of all the software too. SELECT MAX(workstation.WORKSTATIONNAME) "Workstation", MAX(aaaUser.FIRST_NAME) "User", MAX(deptDef.DEPTNAME) "Department", MAX(state.DISPLAYSTATE) "Asset State", softl.SOFTWARENAME "Software Name" FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID
Get Technician Worklog Month
Hi, We have a report that gets the Hours that all technician have registered every week. If i take a look at the query i see that is this one "select * from sdp_technicianWorklogsWeek" Now they ask me to do another one but now filtered by month. I've tryed to use this query "select * from sdp_technicianWorklogsMonth", but i get an Invalid object name error. Could you help me? Thank you!
ManageEngine ServiceDesk Plus/Microsoft Power BI
Hello, Does anyone out there in ManageEngine land use Microsoft Power BI to create reports? Specifically perform direct queries from Microsoft Power BI whilst connected to the SD database? If so, do you have any tips and tricks? Cheers
Convert TIMESPENTONREQ
Hello, My ultimate goal is to get the difference of CREATEDTIME and COMPLETEDTIME into format of: DD:HH:MM. I tried the following, but results are incorrect. convert(varchar(10),((wo.COMPLETEDTIME)-(wo.createdtime))/86400)+' Days '+ convert(varchar(10),(((wo.COMPLETEDTIME)-(wo.createdtime))/1000)/3600)+' Hrs '+ convert(varchar(10),(((wo.COMPLETEDTIME)-(wo.createdtime))/1000)%3600/60)+' Mins'"Time Elapsed", I tried using TIMESPENTONREQ, but it returns incorrect results. I followed the instructions
ERROR WITH REPORTS
Dear good night. I request the help of who can cooperate please. The problem that I am presenting with my application is that I cannot run any report. The report I'm running has always worked in versions prior to 11.1. To rule out faults, I have limited the filter to a minimum of one day. from March 30 to March 31. (I am using version 11.1 of Service Desk Plus). Anyone's help is appreciated. Thank you. Cheers
[On-demand webinar] IT admin's guide to enabling organizational visibility
Hello folks, Sign up to watch our on-demand webinar on how IT admins can enable cross-functional visibility across the organization. During the session, we'll show you how analytics can help, Eliminate complex compliance, monitoring, and visibility issues. Efficiently unify disparate and complex business data spread across departments and functions. Provide decision-makers with a comprehensive overview via cross-functional reports and dashboards. Secure access to critical business data based on
Report For First Call Resolution
Hi Team, we need to generate a report for first call resolution can you please help us query for generating the report
to Generate Report on FCR
Hi Team, We want to generate a report for tickets which were resolved at the first level and which was taken to the next level of support. Kindly help us with the query to generate the report Regards, Divya Bharathi
I can not find the report
Hi, tell me if there is a report where you can see the whole history of ticket changes? v.9.1 build 9118
To Get Ticket History
Hi Team, In Particular Ticket we had added a notes .The notes is available in the Ticket but it is not available in history. Please clarify us and Help to get the history Regards, Karthikeyan R
Create a Dashboard Widget from a Service Desk Report
Is there a way to create a widget using a report that's built in ServiceDesk. I know I've seen the option before on the report side, to add to a widget, but I've looked at several reports and don't see that option. Does it have to be a specific type of report or data to allow it? What makes the 'Add to Dashboard' button show up sometimes and not others?
Query for tickets grouped by Solution ID
Is there a way to know how many tickets have been resolved using the same solution? Many Thanks Sofia
Report for SLA control
How can I have a report by request, the number of hours until the first response (considering only our defined working hours (9h-18h), excluding weekends and holidays) I need the following fields: Request ID, Subject, Created Time, Responded Date, Resolved Time, Time_2_first_response,Overdue Status, First Response Overdue Status * Time_2_first_response = time until the first response (considering only our defined working hours (9h-18h), excluding weekends and holidays) Can have a filter by requests
Need assistance with a report if possible
Hello, I'm trying to create 2 reports that encompass the following: 1. Report 1 -- Daily Worklog report a) Summary Count of all requests generated/entered by a certain technician in 1 day. b) Summary Count of total requests that a certain technician either generated or added work log to. c) Total work log time spent for all workorders generated or touched by a certain technician for that day. d) Detailed entries that show time spent per request generated or touched. 2. Report 2 -- Weekly
Requests Report showing Reporting To
Hello, We are looking at creating a report with the following. Reporting To Requester Department Request # Subject Date Created Category Sub Category Technician We are using Version 10 Build 10009 MSSQL database
Query of complete activity (new tickets created in given date + tickets with activity but created BEFORE given date) in given date
Hi all. I need to create a report where i can have the total activity (new created tickets, plus, tickets with activity but created before the creation date) on a given schedule (one week, 3 days, all year, whatever). Since i cannot create just 1 reports with all this information i am creating 2 separated reports: 1 - Report with the total tickets created in a given time: Columns: ID Ticket + Creation time: SELECT wo.WORKORDERID "ID de la solicitud",wo.CREATEDTIME "Hora de creación" FROM WorkOrder
Custom report
We would like a report of the top 25 subcategories tickets have been opened in.
Need A Report
Hi All, I need a report designed. When I run the following code: SELECT "cd"."CATEGORYNAME" AS "Category", "wo"."WORKORDERID" AS "Request ID", "wo"."CREATEDTIME" AS "Created Time" FROM "WorkOrder" "wo" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "CategoryDefinition" "cd" ON "wos"."CATEGORYID"="cd"."CATEGORYID" LEFT JOIN "WorkOrder_Queue" "woq" ON "wo"."WORKORDERID"="woq"."WORKORDERID" LEFT JOIN "QueueDefinition" "qd" ON "woq"."QUEUEID"="qd"."QUEUEID" WHERE
Report between 2 specific dates/times
HI Guys, Have tried to use the below end but of my query to look for requests specifically created between 01-04-2020 10:00:00 and 02-04-2020 09:59:59 AND ((("wo"."CREATEDTIME" >= datetolong('2020-04-01 10:00:00')) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= datetolong('2020-04-02 09:59:59')) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1))))) AND wo.ISPARENT='1' ORDER BY 7 But its throwing
[SDF-84417] Reports from Problem
We would like to generate a report where we can pull the following fields from Incidents associated with a problem. Ticket number, CSI, Device Name Field, Location Field, Summary, Desc, create date, Tech, Group - pls
Can I run a report showing the last login time of my technicians?
I want to run a report to see which technicians are using the system, is it possible to get a report of each users last logged in time?
VIPs
HI, Is anyone able to help me to extract a list of requestors who are listed as VIPs The fields needed are Name Email Job Title Department ManagerName We're on v9.4 PGSQL
Report for Requester list
Hi, Is there is a way to create a report for the Requester list with no department name or site, as we need to count it and correct it, thanks.
[SD-84377] Calculated Field - Showing Zero In Reports
Hello, I have a series of fields that calculate the number of days between two dates. The calculations work fine .. when there are two dates, it calculates the number of days... when there aren't two dates, it leaves the field blank. But when I create a report, the blank fields are reflected as ZERO, which is throwing off aggregates. I would like to reflect blank or NULL when there is no value calculated. Thank you in advance. First picture is of the form and the blank calculated fields. Second
Detailed purchase report
I would like run a detailed purchase order report, which shows the details of each item in the purchase order. My system run on MS-SQL, and the query's I have found don't run. Thanks Sal
Issue with query reports after upgrade to biuld 11108
we are having issue with query reports, after upgrade from build 9330 to 11108 the already configured query reports stopped working. Our lot of work is dependent of these query reports and the reports are configured in daily scheduled for management decisions. Now our management is asking for daily reports and we are not having any fix/resolution of this issue from service desk support. we are really stuck!!!
[Reports] view ticket time from queue to queue to completion
Hello, I am looking to get the times in a report for each ticket that going from each group to group then total for in each queue then the total time the ticket was open. I have tried to do this with the report builder but I am stuck. Will this need a custom query? If so and can you help create one for me please?
Query report to check on Bitlocker status
We are trying to run a report to pull the Bitlocker status off all workstations in Manageengine. I found a similar ask from a few years ago on these forums but the query doesnt seem to work for my. I get a database error 'invcomputer" not valid. Is there a newer query that would accomplish this or somewhere I may be able to fix our issue if the old query should still work.
Report Issues since upgrade
Hello, We recently upgraded from 10+ to the most recent 11+ version. I have reports that are no longer working. This report gives information about tickets which haven't been updated within the last 7 days, it's currently showing tickets that have been updated. Can somebody help me troubleshoot why it's not giving accurate info since the upgrade? SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", wo.TITLE "Subject", ti.FIRST_NAME "Technician", LONGTODATE(wo.CREATEDTIME) "Created Time"
[Free e-book] Resolve your help desk's biggest challenges with analytics
Help desks are constantly firefighting with little or no time to look into their own problems such as staffing or technician skill. This e-book outlines a few key help desk challenges and offers actionable solutions to tackle them.
Service request report
Hi there, I need to run a report from service requests which include additional fields (below) Column Name UDF_LONG1 UDF_CHAR1 UDF_CHAR10 UDF_CHAR2 UDF_CHAR3 UDF_CHAR4 UDF_DATE1 UDF_DATE2 UDF_DOUBLE1 UDF_DOUBLE2 UDF_CHAR5 UDF_DOUBLE3 UDF_CHAR6 UDF_DOUBLE4 UDF_DOUBLE5 UDF_CHAR7 UDF_CHAR9 Could someone please help me with the query? I do have service request query, and i have tried to add the above fields, but not working? SELECT wo.WORKORDERID AS "Request ID",
wo.TITLE AS "Subject",
Worklog Report
With the new worklogs, I'm trying to get a report together that consolidates the worklogs across all modules from the chargestable. I'm not sure how to get what the worklog was tied to. Here is the data I am looking for: Origin Type (Request, Change, etc.) Origin ID Technician Description CreatedTime Time Spent I am looking to get this data for a specific range - Daily, Weekly, Monthly, etc. I am on pgsql.
ITSM analytics case study: Happiest Minds Technologies automates IT reporting using Analytics Plus
Happiest Minds Technologies, Bengaluru, India, is a leading IT services company focused on delivering seamless customer experiences across industry sectors such as retail, e-commerce, banking, insurance, IT, engineering R&D, and manufacturing. The company wanted a fully automated analytics program to gain real-time insights from an array of IT applications in a single console. The challenge was that their IT data was scattered across several IT applications and tools. The team at Happiest Minds
Database Query Request - Technician Logon History
Would it be possible to query the database to find out when a technician last logged onto SDP and also how many times they've logged into the system? I'm trying to create a report that will show people who are assigned technician licenses who are not using or rarely use the system and should be removed as technicians. ServiceDesk Plus (On Premise) Build: 11105 Database: MSSQL
Next Page