line graph report showing total ticket growth for the year
Ok this is probably going to be embarrassingly simple but i can't figure it out. i'm trying to make a report which has a line chart or time series chart the only thing i want to see is the total number of tickets opened over the period of a year from the date run. my problem seems to be that the only way to make a line chart or time series chart work is to group it by something specific, which in turn, creates multiple lines on the chart which is not what i want. I just want it to view a single
Column aliases for non-custom fields
Hi. I'm developing a Reporting Services report using servicedesk Database. I'm not able to find the names of non-custom fields in the database (table columnaliases has column names for custom fields, UDF_CHAR1 for example). Is there a table in the database with those names? I'm developing the report using portuguese language. Thanks in advance.
SLA list report
Good day! We need SLA list report - smth like that: - service (incident) template name - Urgency - Impact - Priority - SLA name Please help.
Query report to show time spent by tech on changes and requests
Hi, I am looking for a MSSQL query that would show me the total time spent by technician for "Last Quarter" for both Changed and Requests. A consolidated report would be best but I could live with 2 separate reports. My company will be using this for after hours reporting and billing. We have a custom field on both changes and requests called "After Hours" that I will filter on later but I just need a starting point. Here is how I was hoping to have this formatted. Tech Change/Requuest ID Title
Need report
How to make report: Need average time on all requests by priority need to close\resolve request like Low priority - 20 requests - 2days 23:00 all time - 10:00 hours average time Normal - 5 req - 05:50 all time - 0:50 mins average time High - 10 req - 12:35 all time - 01:05 min average time if can't make this report in one, need two different with all time spent to resolve requests by priority and average time spent to resolve requests by priority
Problem using Frequently Asked Report (Query Report)
I used to get this kind of error where the syntax is default by the system: Can anyone advise. Tq org.postgresql.util.PSQLException: ERROR: syntax error at or near "'Total Number of calls created'" Position: 442 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
Custom Report: List of Open Requests
Hi, I would like to know if it is possible to create a custom report on which I can see the number of open requests, per technicien, after 2 weeks,1 month and 3 months of their date of creation? The objectives of this report is to see how many incident are still opened after 2 weeks of their creation and to see how many requests are still opened after 1 or 3 months from their creation date. Thanks. PatrickN
Report that shows Incidents and Problems
Hi. I would like to generate a monthly view of incidents and problems. Ideally this will be shown as a monthly view with daily inputs showing Request type numbers (service Request, Incident etc) and also problems created (not worried so much about the status of the problem) I can get each report individually as a line series chart but would really like to see both in one. Can this be done
Technician Performance Custom time frame
Hey guys, I cannot seem to build a query for this particular data set. Id like to build a report that has a list of tech's on the left and a list of months as the headers. EX: Jan Feb Mar Joe 12 14 11 Pete 10 115 3 I need to be able to adjust the date ranges from a few months to a year.. I have issues because the predefined values start with time.. and I cant quite get what I want from it.
Report on members of a cab
Hi, Is there a way to report on all CABs and their members? Thanks Lee
Query postgresssql
Dear Support, We have migrated from MYSQL to postgresssql. We have a report that is not working anymore.. SELECT sdo.DESCRIPTION "Site",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",wos.ISOVERDUE "Overdue Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time", wo.SITEID "siteid", qd.QUEUENAME "Group",ti.FIRST_NAME "Technician" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID
New query report on project module
Hi I want to extract all our open projects and I can achieve this through a basic edit of the SQL in the following post: https://forums.manageengine.com/topic/report-query-projects However, I would also like to retrieve the latest project comment and use this to build a weekly status report for active projects. Is this something that you could provide for mysql version of the DB? Many thanks Damien
Output reports to server location
Hi, Is it possible in Service Desk plus to schedule report output to a network folder / destination? Currently I can only schedule to email to an email account. Thanks, Ger.
Exporting Tickets with All Data and Attachements
Hi, Could you please advise me if it is possible to export all data with attachments from Service Desk Plus? Many Thanks, James
Report on Activity history
Hi, I'm trying to measure how many tickets have been udpated, worked on, actioned, transferred etc... over a specified period e.g, maybe a day or over a week etc.... The logical way seems to be to report on the activity history on a request as it stamps any activity including that of a techncian. Is there any SQL someone could help me with that would export all the activity history and list by the Request ID? e.g. I could export all requests for yesterday that had some activity on them.
Report Software installed by workstation and filtered by site
Hi Please help me with the following tabular report: workstation, Os installed, software installed (microsoft office), type (managed), asset state (in use) Grouped by Workstation and filtered by Site Thanks in advance Regard
How many requests were assigned by me
Hi, I work as a help desk agent and I want to know if is it possible to run a report to help me know how many requests I've assigned this year, Thanks.
Need a query please.
Need a query please, i have some additional fields for requester that are in Georgian language, i have listed all information i need from query. Request created time, subject, mobile, რეგიონი, requster, job title, ქალაქის ტელეფონი, ფაქტობრიბი მისამართი, email, employeeid, userlogin.
SQL for the first interation on a Request
Hi everyone! I'm trying to create a report (SQL or Tab "Reports") to bring me first the interation on a Request (the first time a technician contact a user, respond a user or close a request). I believe this interation can be made by two forms: 01 - In "Request" Tab, when send email by "Reply" or "Forward"; 02 - In "Resolution" Tab, when status is changed to "Closed" or "Resolved" and the request is saved. With the help of a profiler I've verified some things: When we use the option "01",
Work log report help
Hi, I'm trying to understand how we can create a reliable daily report of time spent for our technicians. They are having the problem where they add a Work Log on a call for the previous day (including start and end time) for example, 1 hour. This time is not added to the previous day but is added to the current day in the report we run. We just want to report on time that the technicians have added themselves to the worklog, regardless whether the call is open, resolved, closed etc. Under the
SLA report by Account
I would like to produce a matrix report of requests closed within the last month for a particular Account by Priority and Category showing number and percentage of requests closed within sla and outside sla. Is this possible?
Report - all requests with a particular title
Hi I would like to be able to report on all requests raised with a particular title im using MSSQL thanks Russ
Report for requests raised by user
Hi I would like to report on requests raised by a particular user. im using MSSQL please can you let me know if this can be done thanks Russ
SQL Help
Hi, im new to SQL and would really appreciate help with the following, I would like a report made to show me all machines that DO NOT have Adobe Shockwave Player 12.0 installed, the only fields I need in the report is the machine name Huge Thanks!!
Number of open requests in a given time frame
Good Day! I was tasks with creating a report to state how many open requests (any request that isn't closed or resolved) with in a certain time frame. The issue I'm running into is when I create a Matrix report off of Request Status, I can generate a report with a bar graph that breaks out how many open requests of each status we have which is exactly what we want. The issue is if I wanted to find out how many open requests there were last week Tuesday I can't pull that data due to having to specify
is in contract report
When adding an asset to a contract, there is a column called "is in contract". How can I create a report that shows all assets and their contract state? That field isn't available to be selected and I am not sure how to create it with a query. Thanks
Pending request in minutes
How can i generate report about ticket pending time?
Running a report on non-it assets
Hi, I would like to be able to run a report on non-it assets and show all of the respective detail/fields. Whilst I can run a basic report it doesn't show all of the fields that are assigned to the non-it assets. Please can you advise how this can be done. Thanks Graham
custom report for archived request
Recently upgraded to 8.2.0 Build 8215. I'm trying to customize a report to identify certain tickets from 2013. Tickets completed earlier than August of 2013 have been archived. I can successfully search the unarchived request. Can I design a custom report that will search and identify certain tickets in the archive? I didn't think it would be difficult but I can't seem to figure out a way to do it?
Exporting information/System Reports
Hello, Is there a way to export data or create a report for the following: -Accounts -Sites -Requestors -Technicians We need to enter this information into some of our new systems for company reporting. Thanks.
SQL 2008 R2 view creation
Hi, I would like to create an SQL view within my SQL 2008 R2 console in ServiceDesk database. I can see that there's already one called "sdp_DateDiff". Is it ok if I create other ones, will it not be erased in case of an upgrade? Thanking you in advance for your reply. Cédric
Is there a report that would generate work log details?
Need a report where i can get the work log details. I have not found away to do this. Thanks, Mark
Technicians in each Support groups
Dear, SDP Support Team I found a way to check what's the Support Groups of the technician they are associated. By clicking Admin->Support Groups->Select Group that I need to check then I will see Associated Technicians in each Support Groups. It's very useful for my audit stuff. But my problem is when I need to check all of Support Groups, I spend a long time to perform this task. Could you please create a query report that show all technician in each Support Groups. Thanks for helping me Best
Custom Query for a New Custom Report
When creating a Query Report its obvious where the SQL goes and can be edited. What about a Custom Report. Am I able to create my own SQL statement to use as the groundwork for a custom report? I'd like to create a matrix report with data and grouping that is not available in the provided drop-downs. Thanks!
Software Query
Dear Support, How to query that shows Software Name ; "Microsoft Visio" WS Name WS Model/Type User Name Last Login Last Scan On IP Address Site Please Help. Thx & Rgd SRC034
How to dump a report of the Solutions.
Hi, I'm looking for a way to dump the solutions to a csv or xls file. I do not see a way to do that in ServiceDesk. What is the best way to get the data from the Solutions module? Thanks, Mark
Same field name in Incident & Service Catalog when running reports
We're trying to run reports on "All Requests" which includes Incidents and Service Catalog items. Both templates have user-defined fields with identical names (i.e, planned completion date) but when we run reports, the fields are often empty when they clearly contain content within the request. Is it possible to have identical field names in both and still run reports?
Report to Show Open Tickets With Latest Updates
Hi Everyone, I have a requirement for a report that would show me all calls at a status of OPEN or ON-HOLD, together with the date of the last Technician update and what that update was. I need to use this to ensure technicians are interacting with our customers as this is one of our KPI's that over the lifetime of an open incident the analyst must communicate x times in y days. Does anyone have such a report ? Thanks Ian
Report for requests by "modified by"
I would like to create a report to show which technicians are modifying tickets. Where can I find the value for "modified by" in the database? This could be different than the assigned technician value, as in some cases a tech will update someone else's assigned request. Thanks
Need to modify Query reports
Hi there, need some reports: 1. avg time to solve a request where tech group = "group 1 and group2" I've got this query, could you modify it? SELECT MAX(pd.PRIORITYNAME) "Priority", TO_CHAR(((AVG(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "AVG Time Elapsed", TO_CHAR(((SUM(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "Total Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
Next Page