Report to show reopened tickets
Hello, There is a common requirement to generate a report that shows reopened tickets. I see no method of achieving this out of the box. Is it possible via a Query report? Can you provide a query if possible. Thank you.
[Free e-book] 5 IT practices that you should stop right now
Hello there, Is your organization still clinging to outdated and inefficient IT practices? It's time for a change! Identify inefficiencies, strategize for improvement, and propel your organization towards sustained profitability. Our latest e-book reveals
Report(s) for administration purposes
I've been asked to create a report that will give us all the template names (Incident and Service Request) and the groups that they are routed to. The report subjects seem to be limited to requests, changes and assets. We need the report above as a reference
Exporting all ticket data types
We have used resource info questions heavily in service request forms. I have a request now to export all this data for specific forms. I know that these types of questions are not usuable with the built-in reporting function and also not found in ZOHO
A Query Report that will show that if a ticket has gone through a specific support group.
Service Desk Build: 14.3 Build 14304 Requesting for assistance to create a query report to show me tickets that has gone through a specific group. Here is how my ticket flows, after a ticket has been filed, it will go through a support group for approvals
Escalation tracking
Hello All, Is there an effective way to track escalations that you all use? I am looking to be able to track and report on automatic and manual escalations.
Report on CIs that do not have any relationships
Hello SDP, Is that possible to get a report on CIs that do not have any relationship?
Manage Engine Reporting
All I am in need to extract these reports. Although I have been using some good reporting format which already have been configured but these three, I am struggling with! to calculate the SLA met is to be based on Tickets opened in the month or b. Tickets
How to calculate work hours lost from inefficient service desk practices [Free e-book]
Hello there, Don't let your technicians' time slip away! Explore innovative strategies that identifies wasted work hours, maximizes outcomes, and drives process optimization. Our latest e-book covers proven strategies to address time-consuming inefficiencies
Is there a way to view ticket details from custom dashboard report?
Hello, is there a way to view ticket details by clicking on a custom dashboard report? For example, from a tabular report in bar chart format? In other ticketing systems, users are able to click on columns and view the tickets within that column. That
Query for Tickets opened by hour by group
It is possible to add the group to this query? SELECT YEAR(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01 00:00:00')) 'Year', CASE WHEN MONTH(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (CREATEDTIME/1000),'1970-01-01
Report to show support group changes
Dear Team, Is it possible to create a report in SDP or advanced analytics that shows all requests that have been transferred from one support group into another support group. I want to see how many times that this happens over a period of the previous
Notification on expired certificate
Hello SDP, Is there a way to generate a notification (warning) on assets (that have an attribute as "expiration date field") before it's reached? Thanks in advance for your support.
Issue with Query Execution
Dear Support Team, I hope this message finds you well. I'm reaching out regarding an issue I'm encountering with executing a specific query. I have been trying to run the query on our PostgreSQL database to retrieve information about tickets that are
Help with a report
Good morning community! We would like to make a report that contains the number of tickets that were open+on hold for every single day from one date to another. For example, now we can have the report for every single day but separate, so if we need to
Users profile change query
Hello SDP, Is that possible to create an audit query about all changes such as (add/remove/update dept, site, merge, etc...) on users profile and who or what performed the change?
[Free webinar] How to eliminate service process inefficiencies and save costs
Hello there, Optimized technician efficiency, increased chatbot adoption, and enhanced service delivery—these transformative outcomes await you at the end of our latest webinar. This session covers proven strategies to eliminate widespread service process
Requested for Query Report
Hi I need a report where we get the detail who have assigned the tickets to technician if we are using the Email to ticket concept.
Custom SDP Report
Dear Team , I am looking for a report that will show me all the support groups, the owner and group technician in charge I have this report, but it doesn't show me what I need select qd.QUEUENAME "Support group", au.FIRST_NAME "Technician",AaaContactInfo.EMAILID
Adding notes to report
Hi I would like to add a column for notes to the below report. Running postgres sql. Thank you! SELECT "wo"."WORKORDERID" AS "Request ID", "pd"."PRIORITYNAME" AS "Priority", "lvd"."LEVELNAME" AS "Level", "aau"."FIRST_NAME" AS "Requester", "ti"."FIRST_NAME"
[Free webinar] How do you measure the business benefits of IT initiatives?
Hi there, Struggling to quantify IT’s contribution to productivity? Transform your IT from a sideline function to a strategic powerhouse. Join the session and discover strategies on substantiating IT's value as a key contributor to organizational efficiency:
[Free e-book] 5 inefficient asset management practices that are costing you
Hi there, Are asset inefficiencies silently draining your IT budget? Uncover hidden asset inefficiencies, optimize procurement practices, and derive maximum value from every IT investment using powerful analytics. Our latest e-book provides data-driven
Report notification
Why would the deletion of a private report generate an email notification to all technicians?
Report for last login date of a technician
Hi, Im after a report for the last date a technician logged in, This is so we can manage license numbers 14.2 Build 14200
export Report without logo.
The reports can be exported as a CSV file without the header or logo. ??. All I need is the field and record names. I attempted to use SQL to perform a select directly, but all I get are html characters when I export the fields description and resol
Query report to see associated additional fields
Hi, I need help with a query report that lists all incident and service additional fields and which templates they are used in. We are nearing the limit for additional fields and this would help determine witch ones we can remove. Thanks!
Please use alias for UserAdditionalFields table Check logs for details.
I have a problem after upgrading to the latest version. I have a query that works perfectly from pgsql but in servicedesk it fails me. Can you help me ?? Please use alias for UserAdditionalFields table Check logs for details. SELECT to_char(to_timestamp((wo.CREATEDTIME)/1000),
Creating Trend Reports for Request Analysis
I currently run a monthly report that summarises request resolutions by each of our support groups during the previous calendar month. This works well, but now that we've had SD+ for some time, I would like to create a trend report to compare this information
Report on year to Date Open Tickets by Age to include Status
Trying to identify if this query is including tickets in an Open status. Looking to identify any that are in Resolution or Closed status: select wo.WORKORDERID"Request ID", qd.QUEUENAME "Group", aau.FIRST_NAME "Requester", wo.TITLE "Subject", ti.FIRST_NAME
[Free webinar] Reduce service desk expenses in five quick steps
Hi there, Cost reduction strategies involve time-consuming plans, and often fail to curb IT expenses effectively. Discover five immediate steps you can take to optimize service desk expenses, while improving service desk efficiency and productivity. Join
REPORTS WITH NO DATA
Is there a way to prevent the scheduler from sending reports when there is no data? Our managers only want the reports when there is data. There should be some way to skip sending it when there is no data.
Query to get Request Ageing info.
Version : 14304 DB : PGSQL OUTPUT: SELECT LONGTODATE(wo.CREATEDTIME) AS "Created Time", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", pd.PRIORITYNAME AS "Priority", std.STATUSNAME AS "Request Status", cd.CATEGORYNAME
How to extract template down to item with SLA using query
I want to extract data on the existing template til item with SLA
[Free webinar] 5 quick steps to drive service desk cost optimization
Hello there, Reduced budget wastage, streamlined asset management, and enhanced service desk efficiency—this is everything you stand to gain at the end of this webinar. Join the session and discover data-driven strategies that bring significant improvements
Supercharge cost optimization in your service desk with report bundles
Hi there, Are inefficient asset purchases draining your IT budget? Should you repair or replace? How does workforce expansion impact IT spending? Discover data-driven solutions to optimizing service desk costs within minutes. With the latest report bundle,
Custom Report: Last Month This Year vs. Last Month Last Year Comparison
Hi Team, We are using MSSQL and I am looking for an SQL query for generating a report that will provide me with information on 13 months rolling Last year last month vs. This year last month. The report should have the following details: 1. Total tickets
Custom Email notification after 5 days of created request
Hello everyone! I need to create an email notification, after 5 days of created a request and not was closed. I not see nothing to do this, and i don't know how to do it with commands. Thank you
Problem with saving on exiting report
Sometime we run exiting report but when we save, it save overwrite on another report.
When was a report last run
I know this was asked about 14 years ago, but didn't see any good answers. We have a lot of reports created by various people over the years. How can I tell when was the last time a report was run, so we can go about removing those that are obsolete and
Export technicians details
Hello, I would like to generate a report containing the technicians' details, such as: * Name * First name * Last name * Primary email * Department name * Phone number I have tried multiple queries, but unfortunately I was unable to find the email addresses.
Next Page