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 for Warranty Expiration on Network Equipment
Hello, I am trying help our network engineer out. He built a query for asset records on all of our network equipment, however, warranty expiration date is a field you can build into reports. I have tried to create a custom query with query editor to add
Servicedesk Plus escalation report
Hi, Can help to give me query base on below field. Naharuddin Great Eastern Life
Is there a way to view ticket details from custom dashboard report?
Hello, is there a way to view ticket details by clicking on a custom dashboard report? For example, from a tabular report in bar chart format? In other ticketing systems, users are able to click on columns and view the tickets within that column. That
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!
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
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?
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.
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,
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.
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
Missing Scheduled Report
We have a scheduled report, Pending High Priority Tickets by Technician (SEV 1 & 2), that I'm not able to find the schedule for. I see the report listed, but not the schedule or where I can alter the recipient list. I ran select * from reportscheduletask
How are we view the performance of assets in servicedesk plus?
Is there a query report we can see the performance of the computers?
Project Management
How do i generate a detailed reprot for a specific project
BIOS date
Is there any possibility to query the BIOS date? I can see the date in details of an asset but I cannot find the field in the database schema.
Report Workstation Monitor Serial Number & Type
Hello, I wonder if someone can help? I can see from the Hardware Tab on the the Workstation asset record you can view the serial number and type of monitor connected to that particular workstation. Therefore, is it possible to run a report which pulls up the serial number and type of monitors connected to all workstations? And if so how? Thank you in advance. Paul
Query to return active Category/SubCategory/Item
Hi guys, I've got a Custom Query that returns the Category, SubCategory and Item names from ServiceDesk Plus but I can't find a way to filter it so that only ACTIVE records show. I've observed that each related table has an 'IsDeleted' column, but in all records (active and inactive) that field appears to be empty. My query follows - would appreciate assistance on filtering to show just the active records: SELECT cd.CATEGORYNAME "Category", scd.NAME "Sub Category", id.NAME "Item" FROM CategoryDefinition
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?
Can we have high level Executive Report for Project Statistics ?
Hi Super Team, We looking forward your support to generate for us PGSQL query for high level Executive Report for Project Statistics as Project Bases. What we looking for is have report by the end with below Requirements and details (In attached file,
KPI report - total time of incedent record in status 'on hold'
Hello We have two request status 'on hold' and 'waiting for feedback' I need a report listing for each ticket the total amount of time the ticket has been in status 'on hold' and/or 'waiting for feedback'. Note that during the life-cycle of a ticket, a ticket can be multiple times in one of those 2 status, taking in account the account the service hours. Needed fields: request id, technician, group, title, total time ticket in status 'on hold' and 'waiting for feedback' Thanks a lot Marc
Monthly Report by SLA Type and Group
Can I get a monthly Report by SLA Type and Group? We are using ServiceDesk Plus 9.2 Build 9241 running MSSQL. Thank you, Steve
Requestor Last Login Report
Hello, We're beginning a cleanup of our SDP environment we've had for 5 years and we'd like a report that lists all active requestors with their last login time. Based on this we would eliminate users who haven't logged on it the last year. Can someone please provide the query script to pull this information? Thanks, Matthew
Assets history report
Hi ALL! We use 11.1 Build 11122 How i can make report about asset history (mean any changes of status/owner of Assets) ??
What is the table store information about preventive maintenance task
I need to pull a report of a list of pm task that are scheduled, their next schedule date etc. Thanks
SLA Report for Group
Hi All, Please help to create SLA report for Group. We are looking for Response time and Restoration time for each group. Below are the version details: ManageEngine ServiceDesk (Version 9.0 Build 9033 ) Database: Postgre Regards Jayakrishnan
Report to show number of breached SLA's for current week for certain group
Hi all, I'm looking to build a report which will show me the number of SLA's that have been breached for current week. Also would it be possible to group by technician Thanks in advance
CMDB Reporting on Relationships
I am using SDP 8.1.0 Build 8105 and want to be able to report on relationships in the CMDB from within the reporting module and not just on the CI items themselves. Is this possible?
Report Creation - Changes - Change Requests Pending Approvals
I'm looking to create a report of Approvers who have yet to respond to an approval request. How would I go about doing this?
Top ten requesters
Need report: Top ten requesters, to see who's the most problem user ;))
Unable to run Query
Good Morning I have upgraded our version of ServiceDesk from 10017 to 11100 and am unable to run some of my reports anymore. The one below is for our HD Productivity - Today report that was created. We are on PQSQL. Thank You select DISTINCT(re.first_name)
Bitlocker Reporting in ServiceDesk Plus
Hi, I'm hoping someone can answer this question. My company uses a multitude of ManageEngine products and they serve us well. We just acquired a new company who uses ServiceDesk Plus. I am trying to determine if SDP can report on whether a machine has
Common table expression
In PostgresSQL (PGADMIN) I can use ctes (common table expression or with) to create "virtual" tables for use in selects using more advanced filters, if we can say so. I tried to use this on servicedesk plus and I couldn't. I would need to filter the column
Reports for templates request
Hi I make 11 templates request in ServiceDesk , and I need to make a report to know how many request in SD by those template Regard
Report for requests assigned to a group (regardless if transferred to another group or not)
I would like a report that tells me all the requests that have been assigned to a group, whether they have been transferred to another group or not. We are trying to run metrics on our tier 1 support group but if tickets are transferred to other groups, we are unable to collect that data with the canned reports.
Convert CREATEDTIME to readable format
I am trying to run a custom report from our MS SQL Server and the dates are important. All of our ticket's CREATEDTIME show up as "1169135575865" I have the SQL statement below that gives me any ticket created between 1-1-2007 and 3-21-2010 which is working perfectly. Now I need a method to display the CREATEDTIME in a readable format such as 3/31/2010. Ultimately I want to group tickets based on CREATEDTIME into each month. WHERE DATEADD(s,WorkOrder.CREATEDTIME/1000,'01-01-1970') >= convert(varchar,'2007-01-01',21)
Report Constructor
Hi, we are testing free trial SDP for our organisation. Can we customise Report Constructor?
Custom report
Hi I'm trying to run some reports that will show me all of the tickets that exist where a custom Request - Additional field is not empty so that I can determine how often the field is used. Let's say we have a custom multi-line field called "Phone". I have tried running a report that filters the Phone field by: Phone Is Not 'None' (I've also tried without the single quotes.) When this report is run, it still shows me tickets where Phone is "Not Assigned". I've encountered this issue with both
Query to retrieve Technician and Requestor Ticket Convos - URGENT
Hi Folks - I need a MSSQL query to retrieve the Technician and Request communication History. I have tried this query but nothing is executing. select nw.workorderid "Request ID", nw.notificationid "Conversation ID", 'Outgoing' "Conversation type", DATEADD(s,datediff(s,getutcdate(),getdate())+(n.notificationdate/1000),'01-01-1970') "Sent on", aau1.first_name "From", nr.recipient_email "To", n.notificationtitle "Subject", nd.description "Conversation", sd.attachmentname "Attachment" from notificationtodesc
Create a Dashboard Widget from a Service Desk Report
Is there a way to create a widget using a report that's built in ServiceDesk. I know I've seen the option before on the report side, to add to a widget, but I've looked at several reports and don't see that option. Does it have to be a specific type of report or data to allow it? What makes the 'Add to Dashboard' button show up sometimes and not others?
Can I run a report showing the last login time of my technicians?
I want to run a report to see which technicians are using the system, is it possible to get a report of each users last logged in time?
Next Page