Report on Assets/CIs change
Hello SDP, I would like to create a monthly report that shows all changes on our CIs (any attributes change). IE: If the servers or Routers or any CIs has a new location or has been decomissioned or has new OS version, etc... Any help on this is welcome.
How can I run a report of TIme Spent by technician that includes work logs in Changes?
How can I run a report of TIme Spent by technician that includes work logs in Changes? I have added columns for Time Spent and Time Spent Technician but it does not include Time spent in work logs in Changes module only work logs from Requests modul
reports time worked
Hello. We want to try this product. But there is a question. I have 4 specialists who work from 9 to 18. Every day from 18 to 9 and on weekends, one of them is on duty. While on duty, he receives requests manually and resolves them. But the time spent
Report needed - Tickets submitted by NON-TECHNICAN users
I need to be able to easily pull reports on how many tickets are submitted from end users via the self-service portal as opposed to by technicians. We have around 80 techs so manually creating this is tedious. I was very surprised that this wasn't already
Scheduled CSV IT Asset Import
Hello all, Is there any way to schedule a CSV import file? I'd like to import a daily inventory of our IT assets coming from different sources such as Vsphere, Commvault, etc (it would be separate files). I would also like to do the same for the relationships.
Asset Reporting on Relationships
Hello SDP community, I'd like to create a report query on our scanned software and include the workstation on which it's installed. Would you be able to share a query example? I currently used version: 14.2 Build 14200 Thanks in advance for your support.
[Free e-book] 5 tips to avoid common IT budgeting pitfalls
Hello there, The path to creating an accurate and effective IT budget is fraught with various pitfalls that often go unnoticed. While there are several blueprints for creating effective IT budgets, these often fail to account for the common mistakes that
Query Report for All Assets
Hello, My Name is Eng. Emad, from National Guard Health Affairs King Abdullaziz Hospital Our Domain : kamc-hs Please see the attachment. Would you please help me with the Query Report for All Assets illustrating the following: Asset Product Type Asset
[Free webinar] 5 strategies to avoid service desk technician burnout
Hello there, Experiencing declining productivity and efficiency? Your solution may not lie in enhancing technician skillsets, but in tackling the underlying signs of technician burnout. Our latest webinar walks you through effective solutions to identify,
Generating Report
Hello I need some assistance on how to get a detailed report for the following "% of the total incident tickets that met our SLOs opened" is there a canned report that I can use for this total and I can export and create the pivot tables to get the percentages?
Exclude Deleted Requests from Pending Requests Report
Hello, I have a custom report that groups pending requests into age bands. Over time, we have noticed that the "Total Pending Requests" is somewhat higher than the real total. Having simplified the query, the reason is that Deleted Requests are included
Query Report - Software List by User
Hello, We are trying to create a report that, based upon a specified user, will generate a list of software that user has access to. The Software Details query is close, but there is no way to specify what user I want a list of softwares for, it just
[Free e-book] The CIO's handbook for analyzing IT budget spending
Hello there, Don't let generic reports and a lack of visibility impact your IT budget and spending. Gain a powerful edge over standard budget reports with our latest e-book, and witness streamlined IT budgeting, reduced cost wastage, and increased ROI.
MSSQL Query Report for Nuanced Remediation Time
Greetings, I need to build a query for Incident Reports that will provide a report that results in the following information: - Escalated completion time: The amount of time between when it was assigned to its final Support Group vs its Completion Time.
Reporting Business Rules
Hi, I need to keep tracking the times that our Business Rules have been applied, maybe you can help me with a query where y can manually set the name of business rule that i'm trying to report. Thnx & Rgrds!
Reports - Date Picker
We recently upgraded to version 14304, and the date picker dialog in the reports module is no longer there. Did something change in the update and remove this? I've had a few technicians asking me about it.
Report Query - show outstanding tasks for all Technicians grouped by
Hi There, Looking for a query which will show all outstanding incidents, requests, tasks, changes and problems for all technicians grouped first by group then by technician. We are using SDP version 14.3 14304 on SQL Thank you :)
Service Catalog report
Can i get a report for all the active Service in the system including the category, subcategory and the 5 levels of approval?
Technician Login Report
Hi is it possible to run a report on which technician has logged into Service desk in a given week ? The report should be able to pull this data for the last 7 days or 10 days and must show the data broken down on a daily basis. Thanks
Solution Reporting
I've scavenged for scraps of reports related to varying topics, especially ones related to solutions and how they are used in our environment. Great examples of this: How many new solutions were created? How many people used a single solution ID? Also,
how to remove duplicates in the report for the total count of changes
SELECT "chdt"."CHANGEID" AS "Change ID", "chanf"."UDF_CHAR1" AS "Affected Services", "catadef"."CATEGORYNAME" AS "Category", "cmDef"."FIRST_NAME" AS "Change Manager", "ownaaa"."FIRST_NAME" AS "Change Owner", "orgaaa"."FIRST_NAME" AS "Change Requester",
query for specific change ID's for stage history
query for specific change ID for stage history
Measure and reduce ticket volume in 5 quick steps [Free webinar]
Hello folks, When your help desk is inundated with tickets, it impacts technicians' ability to deliver sustained results. Catch the warning signs of a struggling help desk, and formulate effective strategies to streamline workload management. Register
Export Service Catalog (Only Active Templates)
Hi, How can I export to excel only my active Service Catalog templates? I don't want the old templates that are disabled to appear as we have many test templates which are not active and kept for testing only. Can you help me with the correct query?
[Free e-book] The ultimate guide to overcoming help desk hurdles
Hello folks, Is your help desk struggling? Are frequent issues affecting productivity and service delivery? Wield proven strategies to overcome widespread inefficiencies that weigh down most help desks. This e-book addresses the following major challenges
[Free webinar] 5 ways to measure and reduce your help desk's workload
Hello there, Is a near-constant flurry of tickets weighing down your help desk operations? When operating in a perpetual fire-fighting mode, we often fail to spot technicians' woes. Our latest webinar lays out strategies to catch the signs of a struggling
Help with Report Build
Can someone please help with a report that will show tickets that are older than 30, 45 & 90 days old? We are on version 14.3 Build 14304 using PostSQL Thank You
Wich password to export reports
when exporting reports it asks for a password. what is it?
Trend Report Monthly ServiceDesk Requests
I'd like to create a report that shows how many tickets were created per month over the last 12 months and display a line graph with the results. How do I do that?
Some scheduled reports have failed with error Not enough port available after upgrading from version 12000 to 14006
Hi All, After we have upgraded the SD from 12000 to 14006, we have a problem to run some reports by schedule. When we run the report manually and then send it forward by email, it works just fine. But when we schedule a report and send it by email, we
Technician report
I'm running SD+ woth postgre I'm attempting to setup some reports on a dashboard showing inflow/outflow of requests and I'd like to show: # of tickets in the individual technician's queue # of tickets the individual technician has been assigned/picked
Stop timer of multiple number of requests/ calls and restart the timer at a predecided time automatically
We want to stop the timer of multiple number of calls/ requests at a particular time. After lapse of a pre-decided time period, all the on hold calls for whom the timer has been stopped, should become active by the starting the timer automatically without user/ administrator/ technician intervention. Please advise on how to make it possible in the present software.
[Free webinar] How to make the help desk your first line of cyberdefense
Hi folks, We're happy to bring you our latest webinar on making the help desk your first line of cyberdefense. Date and time: October 30, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? Cybersecurity is no longer restricted to security teams.
Custom time worked report for tickets.
Tried messing with some of the pre-set reports and custom reports, but can not get exactly what I need. I would like to track the time worked on a ticket from when a tech picks the ticket up to close. On hold status would stop this timer. I know there is a time spent out there that records from the time the ticket is placed until closed, but I would like to see if the above is possible. Ticket comes in at 8, tech picks up ticket at 9 (timer starts), tech works an hour then places on hold (stop timer).
Report - bug
off lately, i have noticed issues while creating and running report the data gets mixed up or displays wrong report. for example. If i open browser in incognito mode and create a report, lets say to check the Service Request raised in the month of Aug
Report on "Users last seen in Requests"
Hello! Simple question here, we would like to generate a "Users last seen in Requests" report. Preferably something similar to the default "Users last login and logout time" report, with the "Last Login/Logout Time" and "IP Address" columns swapped for
Reporting against Tags
We have a few user groups who would like to set specific tags against tickets, to allow them to better gauge how those tickets are affecting a certain part of the business, such as closing out financial periods and if the ticket is affecting that closeout.
How can we add Criteria to View only Open, In Progress and On Hold Tasks on Change Requests?
I have prepared below Query but I can't able to add a Criteria to view only Open, In Progress and On Hold Tasks associated to the Change Request. Please anyone can help me to add the Criteria on the "Task Status". Query : SELECT "chdt"."CHANGEID" AS "Change
Report to show in what templates Additional fields are used?
Is there a report or a way to find out in what templates (Incident and Service Request) all the Additional fields are used?
Exclude non-operational hours from a report
Hi there - I am looking for a way to remove non-operational hours from a report showing average response time per support group: SELECT qd.queuename "Group", convert(varchar(10), (avg(wo.respondedtime)-avg(wo.createdtime))/1000/3600)+':'+convert(varchar(10),
Next Page