Query to get WorkLog timespent For Request and Project
Version:10500 DB:PGSQL SELECT ad.ORG_NAME AS "Account", COALESCE(wtk.WORKORDERID , wo.workorderid) "Module ID", to_timestamp((ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time",'Request' "Module", CONCAT(COALESCE(TRUNC(sum(ct.TIMESPENT)/3600000,0)),'
Worklog time taken to resolve report
Hello! We have an report to sum up all our worklog "time taken to resolve" from our Requests. As we use more and more parts in the ME Support plus product we need to also get the worklog "time taken to resolve" from the other parts of the product. The current sql query: SELECT rctd.FIRST_NAME "Time Spent Technician",cd.CATEGORYNAME "Category",ct.TIMESPENT "Time Spent" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID
Simple summary report
Hello--I'd like to make a simple summary report that shows the count of open request categories and not grouped by anything. Essentially, something like this: Applications 15 Hardware 36 Reports 18 Security 12 I tried creating both Tabular and Matrix
Simple "billing" report
I am attempting to create a report that will list all closed tickets totaling the "total time taken" from worklog activities only. By using the query below, tickets with multiple work log entries are listed multiple times (one for each worklog entry)
Format dates
Hi, I want to format the dates in the reports to mm-dd-yyyy format but I can't find the way to do it and the LONGFORMAT function is showing in the format dd-mmmm-yyyy H:m. I already tried with DATE_FORMAT(FROM_UNIXTIME(mcdt.FROMDATE/1000),'%mm- %dd- %YYYY
[SD-105434] Scheduled report maximum recipients
Hello After the last update I noticed I could not add recipients to one of my scheduled reports. Prior to the update, the report had approximately eight recipients, now I can't have more than five or so. If the maximum length of the To field cannot be
How to export users?
We are working to set up some new features in our environment and have come to the realization that our list of users is extremely bloated. Before going in and deleting all the invalid accounts, we would like to be able to get an export of the current
Monthly Category Based Ticket Report
Hello, I created a monthly Category Based Report and scheduled it to repeat every month. In the incoming report, only the current week's report comes. As a template; I am using reports by All Requests / Requests by Category. In the Edit and Filter options
IT analytics in 90 seconds: Identify problematic asset combinations
Leverage Analytics Plus' correlated insights on IT assets and help desk incidents to effectively curb the usage of problematic hardware and software assets. If you're not already using Analytics Plus, sign up or download your free, 30-day trial tod
[Analytics Plus e-book] The IT managers' handbook for year-end IT reporting
As we're winding up this year, it's likely you're preparing your annual IT reports to present to your senior management. IT teams take up a sizeable portion of the organization's budget, and don't generate any active revenue—these factors make it crucial
Report to view the reopened tickets
Hi, Please provide us a query to generate a report of the reopened tickets. Also we would like to know where to make the ticket status has to be made the field mandatory as "closed" before reopening a ticket.This is because users are able to reopen a ticket which is just resolved not closed. Thanks & Regards Silsha
IT analytics in 90 seconds: Improve IT supply chain management
Streamline your asset procurement process by leveraging Analytics Plus' AI-driven forecasting engine. If you're not already using Analytics Plus, sign up or download your free, 30-day trial today.
Custom Reports for ServiceDesk Plus - Tracking Request Approvals
As a proactive ManageEngine reseller we were recently contacted by one of our customers who was interested in tracking the Approvals Requests made from requests in ManageEngine ServiceDesk Plus. They were interested in tracking the following information: When the authoriser received the request for approval When it was approved How long it has taken the approver to action the request What is the average time to approve Now the Reports module in ManageEngine ServiceDesk Plus doesn't currently support
Report Usage Sorry, unable to execute the report, as a report generation for this login is already running.
Hi all, im trying to run a number of reports and im getting the following error. It has been like this for over an hour. I have logged off and also rebooted my client, still the same issue. I'm guessing there must be a process running server side. Any ideas Thanks in advance
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
Report on hours when service desk requests are logged
Hi We use service desk plus, web version. I am wanting do get a report of calls logged by hour to help establish staffing levels - is this possible? I am looking for a bar chart by hour of day showing number of calls logged each hour - is this possible?
Custom Query on Task's estimated effort of technicians grouped by projects
Hi all, I would like to create a custom query report as below, but I want to show projects which are not status=closed only: Please help. Thank you in advance.
Re-opened report
HI One of my support groups are constantly receiving replies after the request has been closed. That is just how it works for that group. At the end of each week, they have to submit a report showing how many requests they closed. It's a little unfair
Asset Disposed on Date report
How can we generate a report of Disposed assets with the date and by fields?
ServiceDesk Plus Asset Description Report
Hello I've tried to create an asset report that include all Servers and Workstations actually present in our SD+ IT assets, that show basically the asset Asset Name and the Description present in the asset itself, but using the default report present
Requester Report Query - ESM
Hi, I was given the below query to pull Requester details off the system: SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department",
Reporting on resolution templates used
Hi, can anyone help with this one? Fairly new to ME, but I am trying to get a report where I can report on the Resolution Templates used when a ticket is closed. Nothing too complex - ticket number, resolution template name and a bit of flexibility on
Asset Ownership Assignment Date History
Hi, I need to generate a report of all asset ownership assignment date history report. Our Service Desk Plus Version is 11.2 Build 11203
IT analytics in 90 seconds: Curb ticket costs with effective ticket assignment
It's no secret that a service desk is often considered IT's biggest cost center. Curb help desk costs by streamlining ticket assignments using Analytics Plus reports. If you're not already using Analytics Plus, download your free, 30-day trial today
Report containing all instance technicians linked to their roles
Dear team, I'm recently working on some technician's management items and need to find all my technicians' (+/- 100) roles. Is there a way I can simply extract a list of these individuals linking them to their roles? This would be much needed for a system
Technician Roles and Permissions/Privileges
I had an inquiry from our leadership as to who (technicians) can view what data in our Service Desk system, and I scoured the forums and can't find a query provided that matches our current database. The HelpDeskCrew table is gone in this version, so
Technician X Role (Report)
Hello! We need a report that show all Roles assigned to each Technician in SDP. That is a simple report: Column 1: Technician User Column 2: Role Assigned With this report we can make a SOX audit in SDP. This is a very important report based in best practices and should be implemented in SDP in a future release. For now, could you please provide to us a query report? Thanks in advance and Best Regards!
Report request for progress on specific project
I need a query to give me detailed progress and updates on a specific project (projectid = 76) What are the updates on each task and comments
basic how to on widget creation
Hello! We are getting off the ground with our system, and we're looking at how to build widgets for our dashboards to help our monitoring of tickets. The majority of widget building topics seem to involve the self-service portal, which we do not use (we
Change Query Report
I am looking for a change report that would include who the implementor is, Change Type, change ID and status so that we can sort out who is doing what and what status it is at. Really only want in not closed.
[Free e-book] Solving IT problems using data correlation
Hello folks, We're happy to bring you our latest e-book on using data correlations to solve IT problems. In this e-book, we cover how data correlations help eliminate blindspots and provide 360-degree visibility into IT operations. We also demonstrate
SQL Query for technician audit trail
SD+ version 11.3 Build 11311 I am looking here (but can't find anything related) on SQL Queries based on tracking technician activities. Is there any existing SQL query I can use to know who have done what and where (like changing request status, input
Generate Report of All Users
I need to generate a report of all users from our Service Desk system. I need to get their name, email, department. Is there a way to generate such a report? I have not been able to figure this out.
Report for all Categories and Sub Categories and Items
Report for all Categories and Sub Categories and Items Is there a report that shows that?
Number of requests created by time report
Hi all. I'm trying to create a report to show in a bar graph the number of requests created each day going back 30 days or so. When I create the report I also get what appears to be a sort of legend off to the side which I don't need and also the bar
Custom report - Requests inflow
I would like to build the Dashboard report "Requests inflow by time" by my own via custom report to customize and schedule the report. How could I archive this?
Report Request - Solutions
Hello, Is it possible to get a query for the following report for Solutions please? Solution ID Solution Title Solution Views Created On Created By Topic Name Solution Status Public Status Many thanks, Lisa 13.0 Build 13005 SQL
How to work with dates and reporting
We're using SDP 13001 with SQL Server. We are needing to create some query reports as the report wizard is a bit limited for our filtering needs. How do we work with the dates? They seems to be stored as BIG INT and I'm not quite sure how to convert those
Custom report help?
I'm a newb with reports and am having zero luck... hopefully someone with more knowledge on ServiceDesk+ reports can assist. Starting with the basic report Simple Matrix report "Time spent by each technician on request" I would like to add the following
Filter data only over a month
Hi Everyone, I'm trying to make a report that only uses data that is over a month old, how can I do this? Thanks!
Next Page