Modify Report for Application Requests
I have this MSSQL query that allows me to report on selected resources in our Service Catalog. It works well, however I am having a hard time trying to include the ticket resolved status and limit the results to tickets created last year. I added std.statusname into the query, however when I do that, I can't figure out how to bound it. Any help you could provide would be greatly appreciated. Dave B SELECT WO_Resources.WOID "RequestID",wo.TITLE "Subject",aau.FIRST_NAME "Requester",ti.FIRST_NAME
report elapsed time
how to create a report on unassigned requests for more than 20 minutes?
Project Report Request
I need a report that displays the following and I don't see the italics item below as a field option in the Wizard MSSQL / SD 9.1 9103 Project ID Project Title Project Type Site Owner Members List (From Members Tab)- Need to show who is involved on the report Priority Status Created Date Schedule Start Schedule End Actual Start Actual End
Reporting
Hi, Is there any way to get a report of all the categories, sub categories and items ? A
how to extract Reprt on "time taken to resolve a ticket "
hi team, I need to get a report on how much time a technician takes to resolve a ticket. plss help me with this report
Preventive Maintenance Tasks
Hi, Is there a report that can show all the Preventive Maintenance Checks and Task inc the Description ? Any help would be appreciated. I found one from the forums but it's not giving the description. Andrew
Report. Manual change dueby date.
Hi!!! Is it possible to create a report about manually shifted time of resolving of a request? Freelance
Time Elapsed Analysis Report
Dear ME Support, It would be really appreciated if you provide me a report? I have attached a spec table for current requirements. Database is PGSQL. Thanks in advance. Best Regards, Levent
Help with the dashboard
I feel like I may be going crazy and I'm hoping someone can assist me :D I need to change the reports that are presented on the dashboard. I am currently using the free version of the tool with 5 technicians From what I understand to make changes to the dashboard, you must go into one of the reports on the dashboard and there should be a button which allows you to add or remove it from the dash, I don't see this no matter what permissions I give my technicians.... any ideas?
Report - Time spent on tickets
Hello, I need to generate a report on the amount of time my techs spend on tickets. I have each of them enter the time they spend in the tasks section of each ticket. At the end of the week or month. I need to be able to generate a report that says Tech (A) completed X number of tickets and spent X number of hours on all their tickets(B) completed X number of tickets and spent X number of hours on them and do on. For the life of me I cant figure out how to generate this report.
Report to show number of requests per month
Hi is it possible to have a report to show the number of requests / incidents for service desk group for each month thanks Postgres Version : 9.2 Build 923
On demand reporting
Hello All, Does anyone know if there is a way to setup on demand reporting for the customer dissatisfaction report within Service Desk Plus? My director would like to receive a report everytime a customer completes a survey and is dissatisfied with the level of service they received. Any help would be greatly appreciated. Colby
SLA violation in servicedesk plus
Hi All, I have this issue with SLA. One of the requests have been resolved in time but it keeps showing a response status flag of being delayed by 12 days and 22 hours - and growing. (as per picture) I need SDP to recognise that when a request has been resolved in time, the response status is not delayed. Any suggestions? Thanks.
Requester's - Service Request Approver
Hi I would like a report that contains all requesters and technicians who have "service request approver" enabled. Running postgres. thanks
How to create custom query report from the 16th to the 15th of the month.
I need to create a scheduled report that runs every month on the 16th and must start from the 16th to the 15th of the previous month. My current query is: SELECT wo.WORKORDERID AS "Request ID", wof.UDF_CHAR12 AS "Visitor Name", wof.UDF_CHAR11 AS "ID Number", wof.UDF_CHAR13 AS "Visitor Surname", wof.UDF_CHAR1 AS "From Company", longtodate(wof.UDF_DATE1) AS "Effective From", longtodate(wof.UDF_DATE2) AS "Effective To", std.STATUSNAME AS "Request Status", longtodate(wof.UDF_DATE3) AS "Card Issued Date/Time",
How do I create separate date and time columns in my report?
I need to create separate columns for the date and time of the "Effective From" and "Effective To" fields. Currently they are produced in one column. SELECT wo.WORKORDERID AS "Request ID", wof.UDF_CHAR12 AS "Visitor Name", wof.UDF_CHAR11 AS "ID Number", wof.UDF_CHAR13 AS "Visitor Surname", wof.UDF_CHAR1 AS "From Company", longtodate(wof.UDF_DATE1) AS "Effective From", longtodate(wof.UDF_DATE2) AS "Effective To", std.STATUSNAME AS "Request Status", longtodate(wof.UDF_DATE3) AS "Card Issued Date/Time",
Query Report please need assistance
Dear Developers. Can you help me please. I need to add string with "type of request" in this query. Thanks a lot for the answer. SELECT wo.WORKORDERID "Request ID",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",wo.TITLE "Subject",sdo.NAME "Site",aau.FIRST_NAME "Requester",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.RESPONDEDTIME) "Responded Date",longtodate(wo.RESOLVEDTIME) "Resolved Time",longtodate(wo.COMPLETEDTIME)
Asset Management Report
Hello, I have been tasked to build a report on servicedesk plus that needs to provide information regarding the current mobile phone devices we have assigned to users. I am able to get the following columns easily through the GUI: Product Name | Phone Number | Asset State | User | However It has been requested that on this report we need to enter the Executive Officer that the user ultimately reports to, this information is sort of available on AD in the sense of we ca see who the user reports to
Schedule report error
Hello to all, we have experienced problems with scheduled reports for a specific technician only when report is scheduled with XLS format. This is the error message: java.lang.NullPointerException at com.adventnet.servicedesk.utils.ServiceDeskUtil.isUserContainsRole(ServiceDeskUtil.java:4621) at com.adventnet.servicedesk.reports.utils.CustomReportDesigner.addSiteCriteriaForRequestReport(CustomReportDesigner.java:1441) at com.adventnet.servicedesk.reports.utils.CustomReportDesigner.alterCustomReportSQL(CustomReportDesigner.java:423)
Requests and tasks for each project by status
Hello, I'm looking for a report that shows the requests and tasks that are associated to a project by status, like this: Project 1 Open On Hold Work in Progress Closed Requests 5 6 7 10 Tasks 3 4 6 11 Project 2 Open On Hold Work in Progress Closed Requests 6 3 1 22 Tasks 8 1 5 33 Can this be done? We're on v9.2 Build 9227
Query Report - Stale tickets
Hello, This might have been posted before and I apologize. I'm looking for the query for a report that shows all requests that are open/on-hold/[custom status] that have not been updated in over a week. In the columns I would only want to see RequestID, Subject, Tech, Priority and Last update time. Thank you in advance for your help.
SQL to find Last Login for Licensed users in SD+
We are using MYSQL thank you.
Report to show number of requests / incidnets
hi all im looking to build a report to breakdown how many requests and how many incidents we have assigned to a particular group Example Service desk Incidents 25 Requests 36 Also would it be possible to get this as a % on the overall total Thanks
Can someone give me a report query showing the project ID and project task id's
Project id Project Code Title Project Type Owner Priority Status Createdby Created date Schedule start Schedule end Actual start Actual end Projected On Site
Reports on the selfserviceportal
We have created some reports that we need to share with the requesters. Is there a option to do this via the selfserviceportal.?
SLA Breaches: Report showing breaches against technician that breached and not technician that resolved the ticket
Hi all, I don't know if this has been answered by other in the forum or within the standard reporting, but I could not find it and thought to ask the questions. We are using SDPlus 9.2 Build 9238 and are trying to identify the correct report for measuring technicians KPIs. The problem we have is that when we run the standard reports to show SLA breached we see the following issue: Technician A opened the call. SLA breached while call was in this queue. Technician B then took over the call and resolved
Matrix report query change
Hi, I'm trying to put together a matrix report which gives dates along one axis and has requests grouped by first incident vs service request and then request status. The problem is that the field that dictates whether it's an incident or service request (the IS_CATALOG_TEMPLATE field in the database's WORKORDER table) doesn't seem to be in any of the drop-down lists. I would like to go in and edit the query behind the matrix report, but when you click on "show query" and then "open with query
A report generation for this login is already running
Hello, Recently, multiple technicians reported the following error when trying to run a custom SDP report: Sorry, unable to execute the report, as a report generation for this login is already running. The technicians did not cancel a previously running report. We already tried the following: - deleting the report folder of the affected technicians on the SDP application server (\ManageEngine\ServiceDesk\reports) - increasing the maximum total number of simultaneous report users from 15 to 20 (SDP
Report of the Preventative Maintenance Tasks
I would like a report of the Preventative Maintenance tasks showing the task title (subject) and the schedule information. I am using SQL Server and running version 9.2 Build 9218
User parameters in reports?
I'm new to ServiceDesk Plus. We're on Version 9.2 Build 9227, planning our deployment to our user base, eventually possibly on SQL Server. In looking at a number of the existing reports, I didn't see any reports utilizing run-time user parameters, nor did I see a way to add parameters when creating a custom report. Is it possible to set up parameters so users can be prompted to enter, say, a date range, or specific Request IDs, etc., at run-time? And if so, is there any documentation for setting
First response to a ticket does not show up in report
I'm experiencing a problem running version 9.2 Build 9235. I generate a monthly ticket report and often (but not always) I find that the first response to a ticket does not show up in my report. If I manually cross-reference the request ID# I can see the response in the 'Requests' tab, but it's not affecting the Responded Date time-stamp in the report. In the attached screen capture, note the first response was within two minutes of ticket creation time. The report generated CSV shows the 'Responded
Queries
Hi Support, please provide answer for below points whether we can achieve this or not : · (Actual) Number of hours utilized (spent) by technician for each ticket. · Number of utilized and unutilized hours of the technician. · SLA violation report with time spent till the first response from technician · SLA violation report with time spent till the resolution since the available report is showing only elapsed time. Best Regards, Hani M. Nasif Systems Engineer Mobile
Technician Report | Including Last Logged In
Hey All, I am looking to run a MSSQL Query that will allow me to see if a technician has ever logged into the system and when that may have been. The following information would be great! Technician Login Name Email Address Last Login Time I ran across the following, and I think this works, but I wanted to toss this out to the community for confirmation on this being the best way to get the information I am looking for. https://forums.manageengine.com/topic/technician-report-21-11-2016 Thanks guys!
Support Group Report
Hi, Is there anyway to get a query or report that will show ever support group and all the users in that group ? Any help or advice would be appreciated. Regards Andrew
System log view
I want to output the system log viewer from DB. I know how to output from the errorlog table, but the occurredtime can not be converted to a date / time. Please tell me how to do it.
time spent = 00:00:00
Hi I have a problem about time spent. I changed my server 3 months ago. after that the system didn't calculate time spent and its bring 00:00:00 for all problems how can I solve this problem?
IT assets report based on Group
Hallo! I need a report that list all the IT assets that have been statically allocated to Groups. is there anyone that can help me? I wish to have Asset name, ip address, model, OS, service tag, site, location, user, Group grouped by Group Thanks Luciano
Report to extract all communications on a ticket in date order
Is there any report that would provide all the communications on a ticket including notes and emails in date chronological order ie requester communications and Discussion notes (see attached images for examples of correspondence) Your Version : 9.2 Build 9223
Tickets that have been resolved or closed where there is not technician assigned
I have a report that identifies al tickets that have been resolved or closed where there is not technician assigned Where the Request status is “Closed”,”Completed”,”Resolved” technician is “none” I can see in the Request History that the ticket has been closed Request History Created by System on Jan 2, 2017 01:03 PM Operation : CREATE , Performed by : System Updated by System on Jan 2, 2017 01:36 PM First Response SLA violated Closed by Melanie Stevens on Jan 3, 2017 07:37 AM Operation : CLOSE
Add commentary to Zoho Report Dashbord
Hi Team - We now utilize Zoho Reports to provide monthly readouts to our clients. However, what we normally do is generate the reports and then print screen them and place them into a power-point deck and add additional commentary. Is there a way to add commentary (free text) to the Dashboard or an individual graph? This way, we could use the Dashboard to present as its very interactive. We jsut need to be able to add our commentary. Thanks!
Next Page