custom report - logged time per technician per project/ticket // per month
Hi could u please help me write a custom query for our windows installation with MYSQL. I'm looking for a report that gives me an overview for the work logs per technician be it Project or Request. TicketId or Project ID + Title Work log end date. Technician
Report that shows amount of time from creation to close.
Good day, Reports are being asked for that need to show Work order ID, technician, site, subject, date open, and date closed. Specifically, though, I'm being asked for: A list of the last 20 tickets that were closed within 24 hours. A list of the last
Technician Reports
Hi There, We are using Service Desk Plus 13.0 We are trying to generate a report which shows all of our technicians. We need to know when they were added as a technician, when they last logged in, their email address and their reporting manager. Any
Query Report: Violated SLA Requests violated by technician
Hi, I need to report from Requests that SLA is breach by technician name and mobile. Like this: technician Mobile violated requests ids John Doe +13322554499 106,125,130 Sara McLin +15588997744 100 Jack Been +17744558899 170,161,101,152 What should I
Monthly trend reports by category (graph) and Request Summary reports
I've been using Service Desk Plus (on-prem) for a long time and I can run some basic reports based on Time Spent, SLA, and Request Summary, etc.. I'm looking for additional reports that will provide me more insight into our tickets. I tried playing
[SDF-87697] How to create a report from Service Templates and Business Rules
HI Friends I need to create report from Service Templates to find out that which business rules are related to which templates. in fact, I need to find out that which templates has been set as criteria in Business rules. I found this tables: requesttemplate_list
How do I generate a Report to know How many Service Categories & Service Templates are present in SDP?
How do I generate a Report to know How many Service Categories & Service Templates are present in SDP service catelog?
Query to get back tickets in a specific status for longer then 3 days...
I have tried all of the suggestions and solutions from years ago, but they don't work. Most of the queries from Version 11 no longer work in version 13. PG and 13010 I am trying to create a new query that returns all of the tickets in the status "Awaiting
Generate engineer login hours only from yesterday to today
Hi, I would like to generate login hours report but only per today or from yesterday to today, not per month. I have try to modify the query AND ( acs.OPENTIME IS NULL OR acs.OPENTIME > < from_yesterday > - < to_today > ) but the generated report still
Relationship Report
I would like to create a report to find all items associated to a specific user. We are creating an asset type called Information Asset, which is a database of users who have access to company websites and i need a way to create a report showing who is
Request Queue Hopping
Is anyone monitoring this forum anymore? Your Version: 13.0 Build 13000 Database Type PostgreSQL 10.17 Requesting assistance to build a report to identify queue hopping of requests. Report #1 (Details) Request ID
Checklist - Include in Tech Report?
Hello, If I want the answers to associated checklist items to be pulled in a technician report, how would I go about doing that? Thanks, N.
Query Report for Request's History data
Hello, I am deploying a new instance of SDPlus and the customer is asking me if it is possible to run a report that gather the same data that are available on the History tab of a request (see attachment). Could someone help me on identify what tables
Report - Actual time spent from OPENED Requests on report
Hello. I am needing to be able to generate a report that brings me a list of all the requests where the Actual Spent Time value is greater than 8hs. I have a monthly indicator on requests with more than 16 hours of work and I need to be able to have a
Report of users field "Requester allowed to view"
Hello, Is possible to know which users in ServiceDesk Plus (version 11, SQL Server) have the following option configured? Requester allowed to view --> All their Department requests Thank you.
Unused categories, sub categories and items
I'm looking to run a report of unused sub cats and items over the last year. A previous question had a link to a thread which no longer exists. How can I run this report please?
How to use Last update time instead of created time?
I want to show a report that shows me pending requests that have not been updated in X amount of days. Below is the query, but its using pending request by created time. SELECT QUEUEDEFINITION.QUEUENAME,COUNT(WORKORDER.WORKORDERID) 'Total Pending Count',COUNT(CASE
Report on Asset's Supported by relationship with Support Level.
I'd like to realize a report showing the relationships between Workstations or Servers and Support Group including Support Level. Is there anyone who has already tried to get this?
Project worklog reports
We need to run worklog reports on our projects and we need to be able to filter by the following parameters: Project ID Project Title Who did the work (Worklog owner) The worklog time logged (Time Taken To Resolve) Worklog Start Time Worklog End Time
How To Link To SDP Report Wiith URL?
How can an SDP customer created report be linked to using a URL? ManageEngine ServiceDesk Plus 8.0.0 appears to only provide access by manually navigating through a number of SDP page links: "Reports" (http://hostname:8080/CustomReportHandler.do) | followed by clicking the report name presented on the current reports list. A URL path is needed providing direct access to customer created report. This path can be emailed as a URL link. What is the actual path to a SDP report?
[E-book] A how-to guide on measuring the ROI of IT
Despite keeping the business operational and diligently contributing to revenue, IT is often mistaken as the cost center of a business. Learn how analytics gives you the visibility to quantify the contribution of IT. Download the e-book now.
Average time to resolve report - all techs
Hello - searching the forums here I'm just not quite finding the exact query I'm looking for. We recently migrated to ServiceDesk Plus from our old on prem spiceworks. Needing help creating a simple Average time to resolve query, this is what I used
VIP User Report
I don't see a report we can run to see which users have been marked as VIP users by our techs. Would this be a custom query? Or are there 'Requester' report types that can be used to create this report that I am missing?
Custom User Report
I have added several custom fields to my users - I am now looking to have a report run which will list all of the users including these additional fields. For example, one of my new fields is called 'Has Credit Card' with the option to leave blank or
Report for Awaiting response tickets over x days
Hello, Is there away I can get a Query report for request which are awaiting a response for more than 30 days With no response from user
Tickets history report
I need to pull a report for 2020 and 2021 that how many tickets created and the ticket details. Please let me know if there is a sample query to pull those reports. BTW I m using MSSQL.
how to select requests that created between 18:00 to 23:59
Hi, I need to query report for all requests that created in night shift between 18:00 to 23:59 with these columns: - Request ID - Requester - Subject - Technician - Created Time (Date and Time) - Status Thanks for helping
Software Report - DesktopCentral Agent
I have been creating some reports in SDP using information that DesktopCentral is feeding into SDP workstation assets. I now want a report that shows what version of the DesktopCentral agent is installed on all In Use workstations. The report is showing
REPORT REQUEST - SOLUTIONS
Hello, Please can I request a report for solutions: REPORT 1 - SOLUTIONS VIEWED Date Viewed User Viewed Solution Title REPORT 2 - SOLUTIONS OUTCOME Date User Outcome (Yes Resolved Issue / No) Comments MSSQL Build Information Your Version : 11.3 Build 11307
Custom Software Report
I'm trying to create a custom Software report. I have this so far but i cannot figure out how to get the total install count. SELECT softwarelist.softwarename "Software_Name", Max(swmfg.NAME) "Manufacturer", Max(softwareinfo.fileversion)
Need a query to export the SDP complete requester list.
Need a query to export the SDP complete requester list. System : SPD build 8127 SQL: MSSQL 2008 please help to provide this query. regards kunal
[Analytics Plus e-book] 6 help desk practices that are damaging your customer experience
Hello folks, We're happy to bring you our latest e-book on help desk practices that hurt customer experience. Often, help desk implement new initiatives with the objective of reducing workload and speeding up processes. However, not all of these initiatives
Stopping a long running report
is their a way to stop a long running report in the reports portal
Query report to extract Technician data
I need a query report to pull a list of all licensed technicians along with a list of their associated groups. I want it to show me technicians that don't have any groups so I can clean them up as well. SDP Plus Build: 11118 Database: MSSQL
Infographic: How to turn IT data into money-making decisions?
Did you know that technology leaders who leverage analytics make 4 times more profitable decisions compared to their peers who don't? Download our infographic to learn how IT leaders from various business sectors use their IT data to drive innovation,
Approve Statu Report
Hello, We have two approved requests in the servicedesk. I need a sql report where we can track the approval status of two-step requests. The report can list the last month's data Can you help me? Request ID, Requester, Service Category, Site, Group,
Query problem
Hi every body, I have issue with query report, support team sent to me new query report for check approve status,for excample who is approve the ticket,when i paste aquery it give me the error what is the issue? Thanks in advance
Report
Hi Support team, How can i take report in custom report who is approve my request, shortly approve detalis, Is not by query report by custom report i know it is possible in query reports. Thanks in advance
query issue
Hi every body, I have issue with query report, support team sent to me new query report for check approve status,for excample who is approve the ticket,when i paste aquery it give me the error what is the issue? Thanks in advance
Query Report on Specific Software Installed Systems
I have tried hacking together a few of the queries listed on here, but I can't seem to get it to work. I am needing a report to show the computer name, assigned user, and asset state (preferably grouped by that) for all workstations that have the software
Next Page