SURVEY REPORT QUERY
Hi, We are using the freeware version 14.1 of service desk plus, we intend to procure the product soon and are in consultation with a provider. The most important thing for us at the current stage is to have a Survey report view that looks exactly the
Report All Users list
Dear All, Please help me create query MySLQ to create report Requester list (include all Requester and Technician) - All field data. Thanks & best regards Tung Tran
Report for Software by User and Software by PC
Hello, I have the following Use Case: I need to know which Users have Software with "Citrix" in the Name installed. Those users could technically access Servers from one of our client companies and therefore need a higher office licence. So in short,
[Free e-book] Beyond performance: A guide to measuring your IT technicians' skillsets
We prioritize tracking and optimizing the performance of help desk technicians, but often fail to account for how closely performance is tied to technician skillsets. Identifying individual skill levels of technicians is vital in understanding and improving
Request for Report on Change Requests and its Tasks
I would like to generate a Report with the columns : a) Change ID b) Change Requester c) Change Title d) Change Stage e) Change Status f) Task Title g) Task Owner h) Task Status i) Change Implementer j) Change Reviewer Please note, we are using SQL server
How can I export or create a report of all my services in Service Catalogue?
Hi, I would like to export or create a report of all my services in Service Catalogue, including the services within the categories, etc Thanks, Alexandre.
Reports
Hello , Is there a way that we can do a look back at the following, so we have a benchmark: How many tickets were submitted on average per week year to date? How many tickets were submitted on average per week over the last 90 days? these would be two
Technician not available in Task report filter
I have written a task report, and I have one technician who is not visible in the filter. He is a member of the project the task belongs to, and have added him as the owner of the task. However, when I create a task report, he does not appear in the list
Need a report on tickets not assigned directly to the service desk
Hi I'm trying to find a report on the number of tickets that are assigned directly to other teams but not to the "Service Desk Support" default queue. We are on prem version: 14.2 Build 14201
Report to show tickets open vs closed
Is there a way to report on tickets received (open), versus tickets closed daily or weekly for individual support groups? We are currently using SDP 9.0 Build 9017 and the Database is MS SQL. Thanks, Robert
[Free webinar] How to measure the success rate of help desk initiatives
Hi folks, We're back with an interesting webinar on measuring the success rate of help desk initiatives. Date and time: August 31, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? It is no secret that prioritizing continuous improvement is
Help with Query Report on Solutions
Hi Team, Example: Parent Topic -> Topic -> Solution Below is a query report that I use today to obtain certain details re. the usage of our Solutions and I would like to add Parent Topic Name and whether the Solution is Private or Public. Is this possible?
Introducing free report bundles
Hi there, Are improper change implementations causing an avalanche of incidents? Are asset procurement delays hindering productivity? Who are the slackers on your help desk team? Get immediate answers to all these questions and more with Analytics Plus'
[Free e-book] 5 real-world interconnections that IT teams overlook
As organizations grow, IT teams tend to expand into sub-departments that focus on specific functional areas, such as service desk, network operations, security, and more. With time, these specialized teams often lose sight of how strategies implemented
Report to show ticket count history for specific technicians.
I need a report that shows me the count for tickets resolved by specific engineers between certain dates in a table format. Is this possible?
Role report for PostGres
Hello. I need a report that will show all technicians and their roles, please. Now what would *really* be cool would be another report that shows roles and their permissions. The auditors are going to ask for that too. I'd hate to have to give them screen
Technicians can see certain reports
Is there a way to have each technician see certain reports? For example, everyone should see their daily/weekly time spent reports but shouldn't see the reports of other technician
Business Rules - Reporting
Hi, Is there any report that can be done that exports all the details of the Business Rules you have configured ? Would be really handy for triage of issues. Regards Andrew
Custom Reports with attachments
Hi, How to create a custom report for ticket which has attachments? Regards, Karthikeyan R
[Free webinar] A guide to consolidating IT operations data into a unified dashboard
Hello folks, We're back with an insightful webinar on consolidating IT operations data into a unified dashboard. Date and time: July 27, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? Are you struggling to pinpoint the root cause of IT downtime?
Asset Reports with specific fields (not appearing) in Custom Reports Choices
I am trying to make a custom report for my assets. The problem is that I cannot select some fields that I need. Here is the Original Query SELECT MAX(workstation.WORKSTATIONNAME) AS "Workstation", MAX(compGrps.NAME) AS "Computer Group", MAX(chassisType.NAME)
Query for Workstations Division to Desktop & Laptop
I have some assets in my warehouse including worksations (desktop/laptop), PC monitors, switches etc. I run the following query in order to retrieve some data about my warehouse. The problem is that in the exported xls I cannot divide the workstations
API and scipt
We want to automate the task creation for respective tickets, but the API is preventing us from doing so with a script. Now, we are attempting to do it in PHP, but it's giving us an error with the input data. The only time we succeeded to enter data,
Task report query
Hi, Service Desk plus 14.2 I am looking for a report on tasks - comparing scheduled time v actual time. Broken down into groups
Reports of Changes
Hi I'm looking to have two reports created that focus on Changes. Report One. List all the Changes logged into Service Desk within the last month. With the headings Title ChangeOwner Category Priority Change Type Stage Status Report Two. List all the
Report showing all tickets resolved in the last week
Hi, I was hoping to get some help with a report I've been struggling to create. The task is to create a report that shows all the tickets that were set to resolved in the past week. Results should show ticket subject, and the user that set it to resolved.
Timestamp
How to get the timestamp when the change ticket is submitted for review from implementation stage. timestamp is needed in a report form. Please share the query to download the same.
Query report for Solutions with creator site information
I got below query for my 'Solutions' report. I would like to add 'site' and 'support group' of 'creator' of that solution. SELECT solution.solutionid "Solution ID" ,Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",Creator.FIRST_NAME "Created
Service Approver Report
Hi, How can we create a report to generate a list of service approvers by category? Thank you!
Project report
Please share SQL query to get report with below columns Project ID: Project name: All associated milestone with their info such as title, dates, status , comments etc
History Tab query report
Need a query to pull the following for all tickets: Request ID Requester Category Urgency Priority Created Time DueBy Time Request Status Completed Time Technician All entries on history tab On-prem version 14.0 Build 14006. PGSQL being used. Anyone have
how to create report users login/logout per month
In the SDP we need a report of users login and logout that shows time/date and IP Address of users logins and logouts in month (ALL LOGINS, NOT LAST LOGIN). What is the table required for this information and its column? If possible, send us the query
Onhold tickets report
How to create a report that includes the time for which a ticket was onhold along with the dates from when to when.
Receiving "Internal Error" message when attempting to view Scheduled Reports
We created a custom report and attempted to save it as a weekly scheduled report. - The initial test was successful, and the report was emailed as intended. - However, now whenever I try to access the scheduled reports window, I Receive an “Internal error”
More rows in reports
I feel like I'm probably missing something obvious but I have a couple custom reports, however, when I run the report I only seem to get five items per page. Is there a way to increase this number, I can't seem to find something obvious.
Time Tracking?
Hello, we are interested in this product, but we need Time Management. I see that the MSP version of the software has Time Management features, but we are not an MSP. We need the ability for our engineers to track time on tickets, projects, requests,
Take a break message - is incorrect.
HI Sorry not that big a deal but FYI this is incorrect. Should say 'Take a Break' 'We will notify you if there are any new requests."
[Free e-book] Reduce IT expenditure by 50% using unified IT analytics
Silos in IT operations can cost your organization time and money as your technicians juggle multiple tabs to try and find solutions to problems. Unified IT analytics can source data from multiple IT monitoring and management apps, as well as business
Ticket Transfer Report
Hello, I would like to create a report that: - Presents tickets re-assigned from a specific support group to any other support group - Has the ability to specify a date range for the data I have played with some queries but the date format is difficult
Charts in reports do not center properly for printing
I created a custom report and added a chart. No matter which chart I choose, it is moved to the right of the center. When I go to print, part of the right side of the chart gets cut off.
Next Page