Summary Report
Hi, I would like to generate a summary report of total cases received, completed, SLA violations and pending something like below on a weekly and monthly schedule: Please assist. IRIS reports for the month of September: Total requests (incidents & service req) Received 4600 Total requests (incidents & service req) Completed 4599 Total requests (incidents & service req) Pending 57 Total incidents violating SLAs
Median Age Pending Tickets
Does anyone have a report that shows the current median age for all pending tickets and then a seperate report for incidents?
"Time taken to assign "reports
Request ID Technician Priority Subject Requester Group Site Request Status Operation Time Created Time UnAssigned Time Completed Time MY-SQL: Un-Assigned Tickets: Time Taken to Pickup SELECT wo.WORKORDERID 'Request ID',ti.FIRST_NAME 'Technician',pd.priorityname 'Priority',wo.TITLE 'Subject',aau.FIRST_NAME 'Requester',qd.QUEUENAME 'Group',sdo.NAME 'Site',std.STATUSNAME 'Request Status',(select FROM_UNIXTIME(wohi.operationtime/1000) from workorderhistory wohi where wohi.historyid = (select min(wohd1.historyid)
Custom Report for Pending Tickets
Hi I would like to create a report showing how many Pending request are left at the end of a month & week regardless of when the request was made. Is this possible as I've been unable to create it? Thanks.
Color Code Definition
Can we change chart colours for reports from ME ?
Get A Listing Of Catagories, Subcatagories and Items
I need to get a report or listing of our setup of catagories, their subcatagories, and items. I am not interested in incidents tied to them, but more of a way to get everything we have programmed into the system so we can review what we have. There is a tree view in the system, but I would like way to have this in a report format or print out. ver 8.2 build 8201, mysql any help is appreciated
Scheduled Report for User Logon History
Is there a way to make the "User Logon History by Computers" report to scheduled a monthly report base on "logon or logff" and "last month"? Currently using "Desktop Central 8 Build 80234 PS: i can't locate the "Desktop central" in the forum section, so please do move this topic to the correct one if it is posted in the wrong place. Thanks, Douglas
Unable to paste image in resolution using chrome. 8.2.0 Build 8201
I believe in prior versions I was able to do this.
Request Summary on dashboard
is there any way to make a Request Summary report like the one on the dashboard for a custom timeframe ? need to make one for a hole year with months or weeks as column/dots, see picture in attachments - Cyruz
Amendment to existing query report
Hi there, I currently use the MYSQL report located here: https://forums.manageengine.com/#Topic/49000004996423 The report works very well for my purposes but it adds the timespent to the technician that the job was assigned to at the time rather than the technician who entered the time. Can this be ammended? Thanks, Hayden
After update need a report that shows time spent on tasks not associated to a WO
Some of my techs do research and I need to track the time for them. They currently use the task in v8200 and apply time to them, however I can't seem to generate a time spent for just tasks. Am I overlooking something simple.
Outstanding ticket report
Is there a way to create a report that shows how many outstanding tickets each technician has on a weekly basis for a month? I would want to have this in a timeline format. Thanks.
Are reports affected by archived incidents?
Hi I'm trying to run a yearly report to track the number of service requests coming in monthly, by request mode; however the report is clearly showing inaccurate numbers in the early months of the past year. I assume this may be due to archived service requests. My question is as in the title: Are reports affected by archived incidents? and if so, is there a way to run reports that will include archived incidents? Attached is a picture of the report I ran.
Report Query on reassigned tickets
Is it possible to create a report that will show for a 24hr period how many tickets where reassigned and by who. we are using MSSQL on our demo set up 8.1.0 Build 8109
Report Stacked Bar group by Created Time
Dear, I have following problem, I need to do a stacked bar chart with number of Requests Group by Created Time and they Data Format should be Month but in Stacked Bar Chart isn´t Data Format available. Could you help me please or give me a hint? Thanks in advance! BR, userah
Custom Report needed showing relationship of changes to number of requests
Goal: I need a report that shows the number of requests received over time (7 day or 30 day) and the number of changes approved during that same time period. We can then show the impact of changes on request levels. Columns ID, Title, Date Graph Line Chart showing the total number of daily requests received Bar chart showing the total changes scheduled by days.
Custom Report Needed for upcoming changes
Goal I need a report that can be sent to the IT department every Friday which lists the approval status of each change for the next 7 days. An indication of approval status with the number of approvers that responded would be great. Columns Need Change ID, Change Title, Requester, Technician, Change Type, Scheduled Start Time, Change Approval Status, Approvers Responded (like 2/5, 2 of 5)
How to create sub-reports
Hi, Does anyone know how/if you can create new sub-reports for use in a custom summary report?
Disappearing Reports
When saving custom reports to be viewed by "Just me(Private Report)", they seem to disappear. I created a report, saved it to a folder and marked it as Just me, but the report is not visible anywhere. Any ideas on why I can't find it? Thanks
Questions regarding reports
Good day, I am new to ManageEngine Service Desk 8.10 Plus. I have been working with the reports module and I often need to edit the dates or add some filters. This does not seem to work for me. Can you point me to some resources that will help me delve into the query reports as well as information that will assist me in editing the canned reports so that I can get the data I need. Thank you
need a report of assets with attached files
I need a report of assets with attached files and without it. How to do it?
Unassigned time report SDP
Hi, I need modify the next Query for MSSQL, SDP 8123: SELECT woh1.WORKORDERID 'RequestID',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (woh1.OPERATIONTIME/1000),'1970-01-01 00:00:00') 'Created Time',dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (woh2.OPERATIONTIME/1000),'1970-01-01 00:00:00') 'Assigned Time', convert(varchar,ROUND((((woh2.OPERATIONTIME-woh1.OPERATIONTIME)/1000)/3600),2)) +':'+ convert(varchar,ROUND(((((woh2.OPERATIONTIME-woh1.OPERATIONTIME)/1000)/60)) % 60,2)) 'UnAssigned
Time taken to 1st response & Time Taken from Open state to resolved
Hi, Could you help me with this issue, we need to mesure the response time(= Responded Date-Created Time) in h:mm format, and the Time taken from Open state to Resolved state in h:mm format(=Completed Time-Created Time) h:mm format. The header of report . Request ID Level Priority Created Time Responded Date Time taken to 1st response in h:m Time Spent Executed Time Time taken from Open state to Resolved state in h:mm format Completed Time Technician Requester Request Status Thanks in advance.
change report about added today or resolved time blanked which is two days ago
Hi, i want show the change report that added today or resolved time blanked which change was added two days ago
New Report for support tickets
Is it possible to create a report, that will list all conversations and any notes attached to a specific support ticket. Basically everthing that is logged/ attached to a support ticket.
New Query Report
Is it possible to create a report that will show that our requests logged are meeting our SLA targets that are entered into the system ie 1. Was the request responded to according to the SLA and percentage that met the SLA 2. And was the request closed according to the SLA and the percentage that met the SLA.
First Contact Resolution
This is one of the most important helpdesk KPIs out there. Is there a report for this and if not, why?
Attenace Report of Technician
Hi, Please help How to generate attendance report of Technician, Regards, Harshad
Technician Performance Report
Hi, Is there a way I can generate a performance report of my technicians and see who they perform? Such as number of calls they finished, how long each call/request takes to finish. We need to generate a full enhanced report for our outsourced engineers. I’m open for any suggestion.
Automatic report generation
Daily reports are going to some email ID's at specific time. I want to stop these emails. But in scheduled reports no reports seems to be scheduled. While checking logs, it is showing performed by 'system'. andthe particular user who started reports are not appearing anywhere. Database :MYSQL Build Number : 8123
Work Log report for requests and changes
Hi to all, I was wondering how to create a report for Work Log (By Technician and By Group) having work logs from both Requests and Changes for a particular date range. The reports available are taking into consederation only requests. As I understand this could be possible with a custom report. My problem is I do not have the necessary programming skills to create one. Thank you in advance. Socrates
SD Reports
Hi Team, Need your help to build Below report. And I want to schedule this report: 1.Every Friday (Weekly report from Saturday to friday) 2.Every Last day of month (Monthly report) Thanks, Request ID Request Title Requester Created Time Technician Category Completed Time % Rating Comments
Generation of report using a query
Hi I want to generate reports using query. I can write queries for customizing the reports but i am not able to find the way to run that query. If there is any way pls share. Regards Aakash Tonk Infosys Ltd
I have a report to show monthly total for different request types, want to print the Month name in the title at run time?
Any idess? Is there a way to extract the month name from the current date range then display the value in the header or in adjecent column in every row (worst case scenario), this is the monthly report with the following criteria createdtime >= <from_lastmonth> and createdtime <= <to_lastmonth> Thanks!
Task report SDP
Hi, I have this query, but I need to make changes: I need to show: 1._ Field "Subcategory" the Ticket 2._ The "Item" Ticket. 3._% GroupName% 4._ LastMonth MSSQL SELECT cdtd.workorderid'RequestID', td.TITLE 'Title', longtodate(td.SCHEDULEDSTARTTIME) 'Scheduled Start Time', longtodate(td.SCHEDULEDENDTIME) 'Scheduled End Time', td.MODULE 'Module',std.STATUSNAME 'Status', aauo.FIRST_NAME 'Assigned To', aauc.FIRST_NAME 'Created By', longtodate(td.ACTUALSTARTTIME) 'Actual Start Time', longtodate(td.ACTUALENDTIME)
How to add Cost field into request.
ME Team, Is there any way to add cost field in new request same like in problems additional filed ?
Error reports
Hello good morning: I am a new user and I ServiceDesk has created a problem not solve agradecieria as ayudarn me if anyone knows the solution gener when a report throws me the following error:
request for report. need a report to show incidents against SLA times
been trying to create a report to show if we are meeting our SLA targets as set out on Servicedesk plus
Generate customized report
Hi Team, Kindly help to generate customized reports below: Severity breakdown percentage SEVERITY BREKADOWN PERCENTAGE SEVERITY # OF TICKETS WITHIN SLA BEYOND SLA WITHIN SLA% BEYOND SLA% Summary report per Technician Technician SEVERITY LEVELS TICKETS STATUS Technician CLOSED SEV 1 CLOSED SEV 2 CLOSED SEV 3 CLOSED SEV 4 CLOSED SEV 5 CLOSED OPEN TOTAL 0 0 11 0 0 11 0 14 Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA 0 0 0 0 1
Generate report for only business hours
Hi, I need a availability report (Percentage) which should show only defined Business hours. However i can't find any drag down option to selct the business hours report on the report page. So, i would like to know is there a way to associate this on the report? or it can be generated in different simple ways? I'm using Apps Manager11. Please let me know if any more info required for better clarity. Regards, Karthik.
Next Page