Request status times report
I was asked to set up a report that shows the amount of time that a ticket was in each status. Open: How long was the ticket Open until it was set to "In Progress" In Progress: How long was the ticket In Progress until it was set to "Resolved/closed"
Report - Tickets older than X time and tickets with no replies
Good afternoon friends, Our COO asked we devise separate reports which will show him two things. 1. Any open/assigned/unassigned tickets which are older than 10 days 2. Any tickets that are open/assigned/unassigned that have no response. I'm fairly certain
Group By for Query Reports
Is is possible do Group By Query Reports like you can on Custom Reports? I have wrote a Query Report to replace an existing Custom Report for Pending Requests to give more control over how the data is formatted. For example only displaying a portion of
Report on Notes
Hello. Could you tell me if there's a way to generate a report to track open tickets that don't have a note? We'd like to create a dashboard that displays tickets transferred from one support line to another without a note added.
Custom Reports for Service Request Resources... When?
Are there any plans to add the ability to customize reports with questions related to Service Request resources?
Report Not
Dear ME SDP Team, I generate a report and export it as .xlsx. why did it always saved as .zip file. and everytime i tried to extract the zip file, it would return an error right now i couldn't export any kind of report. it is always exported as .zip Can
Query Report for Asset Change History
Dear Support, I need report for asset change history for tracking of Asset Movement, I have report which only displays the first user and assigned date. I need the report for complete asset tracking from first user towards current user. (Ex: 1st assigned,
Can you make the figures in a Chart by Summary Type or is it only by count of records?
It looks like the values in the Charts are based on the number of records and not the summary type. Is there a way to get the Summary Type values to be displayed on the Charts? For example, if I create a report based on Time Spent, and I want to Summarize
Online/offline technicia report
Hi, can anybody tell me is there any way to check whether technician being online manualy changed to offline by button in user profile? Maybe report or sql query with name, last name, login, time from to online, and time from to offline best regards,
SDP User assets history
Hi, I wonder how can i generate a report of user's assets history, including assets that are re-assigned, expired, disposed? including Asset name, Product, Product Type, date of assignment/ unassignment? Thank you. Drason
Asset Report with Firmware
Hello, I can see that some of the assets we scan have an entry for firmware, but I can't figure out where that's stored in the database. I have this query report, which pulls everything I need except the firmware. Any idea what I need to add to it? Thanks!
REPORT ON CHANGE SHOWING CHANGE IMPLEMENTER
How can we generate a report on a change implemented by a particular user? We tried with custom reports but there is no column like change implementer. A query can work as well
DueBy Date Report
Hi ALL I need custom report based by next rules: 1) Request age: => 12 Hours 2) Request Status: Not Closed and Not Resolved 3) Field "DueBy Date" is empty / Not Assigned Report must contains next Columns: Request ID Request Status Approval Status Request
report from requesters and than email requesters
Dear All, We would like to have a SQL Query report with below columns: a) Request ID b) Subcategory c) Region d) Requester c) Email requester d) login requester and also add filters: groups, service category, service request, request status, subcate
Cost of service - reports
Hi, I am interested to understand where we can use Service cost attribute: There is an option to define cost per each service. Is there any report that can show us total cost per closed requests?
Report for Marked Tasks
Would it be possible to get a report made for open Tasks that are marked and not yet assigned? It's difficult to keep track of these so sometimes if a task does not correctly change to assigned when it should it'll go untouched for a while until we accidentally
Reporting on Assets - DB growth
We want to get a report out of our SDP's CMDB to detail the growth in the number of servers for the last 3 weeks. Next step would be to correlate with previous periods to estimate how fast that number grows, so we can then order the correct number of
Extract all requests/changes in .csv
Hi, greentings We need to extract a complete report of all requests and changes registered in the on-premise SDP What is the recommended procedure?
Looking for how to see the time tickets are in a specific request status on closed tickets for each month to compare data over time.
Hello, I am trying to see how I can run a report on all tickets that were created in a specific month, such as January 1-January 31st. I'd like to be able to get the average time those tickets were sitting in a specific status, such as "on hold", or "awaiting
Reporting by combining request status columns
I am getting a category based report. In this report, I want to combine the columns of open, pending and some others in the request status under a different name Open + Pending => OPEN 3 + 2 =5 Closed + Resolved => CLOSED 2 + 2 = 4
Requester allowed to view - need report
Hi ALL We use SDP 14840 with MS SQL DB I need report about data of setting "Requester allowed to view" of each user - how to ?
ServiceDesk Plus
Hello, We would like to run reports, sorted by technician, of open tickets (incidents and requests) that a technician has had assigned to them for over 3, 7, and 14 days. Three separate reports would be fine. Is there an existing report template in ServiceDesk
ServiceDesk Plus Notification for Ageing Tickets >15 Days
Hi Team, Is there a way we can have this feature in ServiceDesk Plus? Either: 1. Each of our Technicians will receive a report on a weekly basis that says "Hey, this ticket is more than 15 days. Please check." and there is a table or ticket numbers displayed
Query for asset state change in last week
Hi, I am looking for a query report, where I can check which assets state were changed from In Store to In Use in last one week or last one month? Thanks!
Maintenance Reports
Hello, I need to have reports of the maintenance tasks that have been performed and also of the ones that are schedule (for example for the next month or year), but in the reports I can't find any report template related to Maintenance. How can I get
Query to Generate Report of all Technicians in SDP (MSSQL)
I just wanted this to be listed here in the Pitstop, for future reference, and in case others might need it (Running SDP On-Prem v14.6): select au.FIRST_NAME as "User Name", al.NAME as "Login Name", dd.DEPTNAME as "Department Name", sdo.NAME as "Site
On-Premise Chart Reports for KPIs and SLAs
As we are migrating to the cloud, our PowerBI reports, and their connections are broken at this time. We are looking for help building reports on the following KPIs and SLAs with charts for better visibility. KPIs Closed/Received >92% Example: % closed
Can I remove the time from 'created time' field?
Is it possible to remove the time from 'completed date' (or other date/time fields)?
Exporting a project to CSV, including tasks, milestones, timelines, roles, and time details.
Es necesario exportar un proyecto completo a CSV con todos sus atributos en el módulo Proyectos de ServiceDesk Plus. ¿Cómo puedo hacerlo?
Custom change report
Hi I want to create a custom report to show following information Change ID Title Change Requester Change Owner Change Implementer Schedule Start Scheduled End I've try this query => https://pitstop.manageengine.com/portal/en/kb/articles/change-rl but
Maintenance Report with template field information
Hi, Team, A customer of mine needs a report with information on some of the maintenance template fields already filled. I can get a report with the title, next scheduled time, requester, category, and subcategory, among other fields. I also need to add
Requesting the ability to report on Roles with assigned users
HI, I need to produce a monthly audit report of Roles that list the users in each role, rather than list users that are assigned to roles SDP version 14830 SQL DB Is anyone able to assist please. Thanks :)
Trying to run a report that will show Work Timer entries when NOT added to Worklog
Trying to run a report that will show Work Timer entries when NOT added to Worklog I see they do show in the history of the request. Is there a way to find those? Thanks in advance.
Request for Custom Query Report
Dear All, We would like to have a SQL Query report with below columns: a) Asset ID (unique) b) CI Name c) Software's Installed Our current built of the Application is 14720 Regards, Wajahath Farooq
Task Advanced Matrix monthly summary report
We are able to create a great Advanced Matrix report for Requests that shows the count of the number of requests closed per support group per month and would now like to create an identical report but for Tasks. When we select Matrix Reports the Tasks
Report to show usage of Templates
Hello, Could you please provide a New Query Report sql script that will show how many times each of the templates have been used? Version : 9.0 Build 9032 Many thanks, Lisa
Reporting time on line for technicals
Buenos días, Como puedo obtener un reporte con el tiempo en línea de los tecnicos usando la herramienta?
Urgent Request for Report on Default/Generic Accounts and Password Change Dates
Dear Support Team, I hope this message finds you well. I am writing to request a report or evidence from the logs that includes the following information: A list of default or generic accounts, with particular emphasis on the Administrator account from
Maximum Number of Additional Fields
Hello world! We have been building out new ticket templates for more of our departments to utilize the Service Desk in Manage Engine. Yesterday we reached our maximum number of additional fields and can no longer create new fields. I know we can clean
report for audit successful and failed login attempts
we have ServiceDesk Plus v 9.0_9017 - MSSQL database we need a report (event in last month) with login attempt on service desk application (successful and failed) with 4 column : date and time (ordered), event... successful or failed login, username,
Next Page