IP Address Change Report
I would like to schedule a report which will run once a week to show me the names of any assets which have changed their IP address, showing name of asset new IP address and date/time of change of address. I am not sure how to do this, can somebody help me please?
Query report all requests per technician
Hello I'm looking for a report showing created requests per technician per day the last 7 days. I found this https://pitstop.manageengine.com/portal/community/topic/query-report-all-requests-per-technician but I'm using version : 10.5 Build 10500 Database : postgres so the quarry isn't working for me. Any help would be helpful. TIA Daniel
Delete Scheduled Report for Terminated Technician
One of our technicians took a position with another company, so I deleted him from the "Technician List". Then I realized he had some "Scheduled Reports" that are still being generated. 1.) How can I disable his scheuled reports? 2.) Why didn't the scheduled reports go away with the account, when deleted? Thanks!
All tickets assigned to a group even if they were then assigned to another
I have a group that is assigned tickets but then may assign them out to another group. I am looking to report on all tickets assigned to this group even if they were assigned back out to another group.
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.
Next Page
