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?
History in the reports.
Hi. Please tell me how to view the change history in the reports. Someone deleted the report and now the running task is triggered, emails arrive, but they are empty and the task is not displayed in the scheduler. The report is also not in the list of
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
The “Enterprise” field is not displayed in the ESM catalog in ServiceDesk
While working with the ESM catalog in the ServiceDesk system, I encountered an issue: the “Enterprise” field is displayed on one instance of the system but is missing on another. P.S. In English, the word “Enterprise” translates to “Компания” in Russian.
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
Need to incorporate "Notes" info in ServiceDesk plus change MGT report
Dear Expert, please help to add "Notes" (CR submission stage) in below existing custom query. below query use for exporting CR data (DB - MSSQL 2022). select chdt.changeid AS "Change Request Number", ctDef.NAME as "Change Type", requester.FIRST_NAME as
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
Report license software by site and custom attributes
Hello, I'm working to create a custom report with status of licenses: installed, purchaed, allocated, available... this is the query: SELECT "softl"."SOFTWARENAME" AS "Software Name", "softcomp"."COMPLIANCETYPE" AS "Compliance Type", "swmfg"."NAME" AS
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
Can I generate this specific report using resources from a request?
I have a Service Catalog template called Employee Onboarding/Transfer that contains resources for the user to input the employee's name. I would like to generate a report that shows the following: Employee First Name Employee Last Name Requester RequestID
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
Next Page