templates query
HI i am looking to run a query that shows the templates used by volume so that i can see which templates are used more than others. the available columns in a incident report do not contain the templates option to choose
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
Reporting on worklogs MSSql
I have a query which displays request ID, subject, and technician. How would I add worklog information to that? In what tables are they stored?
[Free e-book] Six strategies to eliminate costly inefficiencies in your IT service processes
An organization's IT department is its powerhouse. However, IT can still be affected by service outages, service performance issues and inefficiencies. Discover how advanced analytics for IT service management can provide visibility into IT services,
Pending Approval report for specific approver and request status
How can I edit this query found on here under another post to only include request status of Waiting on Approval and approver name equal to a specific user? Thanks for your help. Build in use 12.0 Build 12000 SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME
Recently Installed Softwares Report
Hi, is there a report which lists recently installed sofwares in the below format? Software Name/Version/Computer Name/Date Installed
Getting error java.lang.StringIndexOutOfBoundsException: String index out of range: -1 while running query report
Statement:- I am tring to generate report which contaiing only 100 characters out of description Query : SELECT "wo"."WORKORDERID" AS "Request ID", substr(wotodesc.FULLDESCRIPTION,1,100) AS "Description", "rrs"."RESOLUTION" AS "Resolution" FROM "WorkOrder"
"Not Assigned" Technician Login Report
Hello, I have a customer that us runing the following query: select qd.queuename as "Support Group", sdo.name as "Site", au.FIRST_NAME as "Technician Name ( First Name )", LONGTODATE(acs.OPENTIME) as "Last Login Time", al.NAME as "Login Name" from queuedefinition
Reporting on the Re-Assignment of Tasks and Requests
We are using tasks in ServiceDeskPlus because there are requests that require multiple teams to work on separate requests. Our management team would like to view how teams are sharing work through tasks or redirection of requests. Is it possible to run
Conversion to Service \ Incident
When we a looking into the manual pages we can find very helpfull function to convert incident to service and vice versa. https://help.servicedeskplus.com/requests/converting_to_service.html https://help.servicedeskplus.com/requests/convert_service_to_incident.html
Audit or worklog of technician
Hello, almost any action are stored in history's e.g. history of incidents, changes, problems, tasks or whatever. Now is there a way to get a work-log (or may called audit log) of an technician to see the sequence of all changes/modification done by a
Email Note to Requester
As everyone is aware, it's been on the 'ask' list for years: https://pitstop.manageengine.com/portal/community/topic/e-mail-note-to-requester Wondering if this MSP custom schedule/script could be used to email requesters when a Note is added to their
Task Report by scheduled end date?
I am looking to create tasks with due dates? Is that what scheduled end date is for? And if so, how to query scheduled end date for a report? I want a report titled "tasks due this week" thank you
Report on Requests,Problems,Tasks per Technician
I would like to create a report showing, for each technician, how many Open Requests, Problems & Tasks they have. I have reports for all Open Requests, all Open Problems & all Open Tasks but they are separate reports. What I want is to join this information
Querry for pending requests until a specific month
Hello together, i need a querry to show the following records: All request types with request status = open until 31. August 2021 23:59 . So this means that i need a way to look into the past how many ticket was still open until this date/time.
User Inventory Report
Hi I want to create a report showing all the inventory (laptop - IP Phone - printer - etc.) and software (autocad - microsoft - windows 10 etc.) Can you help me?
Report for specific users
Hey! I am looking to create a report that runs weekly that pulls information from a specific group and then puts the information into a summary form with the date of the ticket, the ticket summary, how many days overdue, the agent assigned, and the priority.
can i please get a report created which lists what tasks are open for a change and who they are assigned to
we have many changes open in our system with tasks assigned to relevant staff to perform the work. I would like a query report that lists the following in relation to the change requests: Created date Task ID Change ID related to Title Description Status Owner Group Scheduled Start time Scheduled End Time % Completion Thankyou
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/Technician Activity Report
Hi, Please can I request a new query. I would like to be able to report on the requesters and technicians use of the system. How often they have logged in during a stated date range (Today, Last Week, Last Month etc), and I would also like to report
Report - Technician Details
I need a report with below Columns for Technician Report. Support Group - Technician Name - Technician Email Address Servicedesk Plus Enterprise - On Premises. Version 11.3 Build 11307 MS SQL
How possible to generate/create a custom report by the performed date/install date/creation date of any asset in CMDB?
I want to run a report, I wonder which users and devices were added to the domain at a given time, exactly when the first time scan was for them.
Search by Description in Archive
I'm trying to find some information on old tickets in order to take care of some current issues. I tried building a report on Archived tickets but I'm not seeing "Description" as an option. Is it possible to build a query to search through archived tickets
Graphs not updating
Good afternoon, We have some graphs that hasn't updated since late October. They count the number of tickets received in the month. They have been working well since we set up them up at the beginning of the year. We are running Version 11.3 build
Checklist Query Request
Hi, Please can I request two querys in relation to Check List data. Report 1 - Associated Checklists Showing any Checklist that has been associated with a call. Date Filter on Associated Date (Today, Yesterday, last week etc.) Fields required: Request
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
How Works an SLA Report (Time information)
Hi there, I'm performing a report with all requests made in a month. What I want to know is: ¿When you made a report to know the SLA and the time used to resolve and close a request the report will only show the requests that have been closed? I mean,
Query report about pending approval for more than 10 days ago
Hi, I want to get requests that status is "pending approval" and create time is more than 10 days or two weeks ago. I want to get a report every week without a change query. I want to have a query report with these columns: Request ID Requester ID Subject Created Time Approval Status Request Status Approvers Build No: 11.1.21 DB: MS SQL Thanks for helping
Import IT Assets from CSV file?
We are considering purchasing ServiceDeskPlus with Asset Management included. My supervisor has requested I create a CSV file of our IT assets to import. To simplify our getting started process I wish I could get a blank CSV with only the needed headers
Report showing the incident request with all its associated tasks?
Has anyone been able to create a report showing information from the request with all of the tasks associated to that request under it? There is the "All Activities" online ability to see this but no report that I can figure out how to create.
Change Management query report - Audit requirements
Hi, We have a specific audit request for the following report - Change management register of all changes from 1/10/2020 to today. If possible ensure report has change type, open/closed dates. As much info as can be extracted We use 11.3 Build 11308 Postgres
[Free webinar] Building a unified analytics platform for ServiceDesk Plus, Desktop Central and OpManager
You may know from experience that applying new security patches causes a spike in incident volume. But do you know what's the correlation factor between security patch updates and incident volume? Likewise, do you know the correlation between technician
Looking for a report that shows how many times XYZ User called in for a recurring problem
Hello, I'm looking for a report or custom report option that will tell me how many times John Doe called in over a 3 month period of time for XYZ Issue. Bonus points if I can run the report for all users and then the output have John Doe -> Outlook issue
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) ??
Please help to modify query report
Hello Can anyone advice me, how to modify this request in order to change period from REATEDTIME >= <from_lastweek> AND wo.CREATEDTIME <= <to_lastweek> to display requests created within current year? Here is original query: SELECT wo.WORKORDERID AS "Request
Active technicians login report
Good morning, It's possible to get a report of only my currents technicians who have login, and their last logout time? Im using PGSQL and and version 11.1 build 11134 of SD.
Can't create new report folder - BUG REPORT
Hi On the latest version - when I create a new report folder - it doesn't show. I can see it under 'manage' and move the order but I can't see it listed on the main page. Tried it on both my dev and prod servers - same result UPDATE - You have to create
Generate a list of printer with IP address
Hello, Grateful if you could advise what is the mistake in it. All are generated from SDP in this custom query except the [ MAX("networkinfo"."IPADDRESS") AS "IP Address" ] part. SELECT MAX("productType"."COMPONENTTYPENAME") AS "Product Type", MAX("resource"."RESOURCENAME")
[Free webinar] Building a unified analytics platform for ServiceDesk Plus, Desktop Central and OpManager
Data-driven IT management is key to propelling your IT forward, achieving cost and process efficiency, and ensuring seamless operations. The challenge lies in bringing IT data from several applications into a single console for analysis. Analytics Plus,
Introducing blended analytics for ServiceDesk Plus and Desktop Central
Hello folks, We're delighted to inform you that you that we've just launched blended analytics for ServiceDesk Plus and Desktop Central. With blended analytics, users can correlate critical service desk and security metrics, and understand how changes
Next Page