Report using query editor
I have this custom report but would like to insert a query that would include a ticket that has a specific line in "history" field or column.
Is there any way to report requests for dependencies??
57/5000 Hi, I use 'Request Dependency Marking' function on SDP to make dependencies for some requests and now want to extract this list of them. The request in the report should contain the PARENT request <ISPARENT> and the sub requests are dependent
Trying to find all asset history
Hi all, Is there a way to determine all the asset history a particular user has had?
Query report from request with SLA time and time elasped
Hi, I need to query from SDP with these columns: 1- request id 2- requester name 3- request create time 4- requester department 5- technician 6- request title 7- time spent in hrs 8- time elapsed in hrs 9- overdue status 10- SLA resolution time base on
Query to generate report on priority degraded tickets
Hi Team, We used below query to generate report on priority degraded tickets. SELECT wo.WORKORDERID "Request ID", wo.TITLE "Subject", qd.QUEUENAME "Group", ti.FIRST_NAME "Technician", LONGTODATE(wo.CREATEDTIME) "Created Time",
Scheduled query report
Hello! I'm looking into generating a scheduled report report that shows our tickets related to "Leavers" from the last 30 days (to be sent the 15th of each month). The fields to consider are either "Effective Date" or "Start/Leave Date". This is the query
Custom Report Help
Below is the custom query report that we created which worked fine for my team. However, we were requested by our Finance team to create one with several other pieces of info. We are good on all of it with the exception of the Level 1 and 2 approvers.
Report for Category and Subcategory
I would like a report to view my categories and subcategories so I can make decisions on which ones I can hide/delete or need to still need to be created. Is there a way to export a list of categories and subcategories or run a report so for this?
Need to create a report on pending tickets where last reply by requester
Hello, I need to produce a report of all pending tickets where the last conversation was by the requester along with the date and time they replied (i.e. technician has not yet replied to the requester). I have an existing tabular report filtered where 'Last reply' is 'REQ_REPLY', but it doesn't list or have an option to show the date/time of the requesters reply. It does show Last Update Time, but that could relate to anything. Running on MSSQL database. SQL for the existing report below SELECT
Service Desk Plus custom report add columns
Hello, I need to create a custom report for one customer. Could I add other columns in Service Desk Plus custom report? Thanks
All Requests Report with first Group and Technician assignment
Hi, I'd like to get a report that shows after what duration tickets have been assigned to a group the first time and to a technician the first time in two different columns. The report should consider the business hours defined. More or less what is shown in the history "Time Elapsed Analysis" in the bars "Group" and "Technician". The list should contain the following attributes in addition: WORKORDERID, RequestTypeDefinition.Name, PriorityDefinition.PriorityName, TITLE, CREATEDTIME, RESPONDEDTIME
Worklog query across Changes and Requests
Hello, I need a report of all worklog entries entered last month across all our modules: Requests, Projects, Changes. Columns: Time Spent Technician Time Spent Start Time Time Spent End Time Time Spent Description Contract (this is a Worklog additional field) I am hoping to turn this into a scheduled report to run on the first of each month, so the report would need to dynamically calculate the date-range for the report (prior month). Any help would be appreciated.
Log weekly hours of technicians based on time logged in
I'd like to generate a report that gives us the total hours our technicians are logged in to the service desk console. Preferably broken up by day with a full week total. i.e. Columns: Technician Name; Sunday Hours; Monday Hours; Tuesday Hours; Wednesday Hours; Thursday Hours: Friday Hours; Saturday Hours: Total Hours Database is PostGRE Thank you for any assistance you can give. Daniel
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.
Error Backup Scheduling Asset Explorer
Good afternoon, Has anyone experienced this error when accessing Backup Scheduling in Asset Explorer?
Weekly Trend Report Sorted by Category with Graph
Hey All I'm looking to make a Weekly Trend report sorted by Category along with a stacked Graph. I tried doing it with an Advanced Matrix report, but it doesn't give me the option to add a nice graph for visual representation. Does anyone know how I can accomplish this? I want to make it based on when it was open (weekly), and categories then shown in the graph, stacked category count.
Report for # of Tickets +30 min before assignment
Hi, We would like a report to see how many tickets stay unassigned for more than 1/2 hour. We want to make sure the dispatcher is assigning tickets in a timely manner. Thanks, James
Elapsed time reporting requests by technicians
Elapsed time reporting requests by technicians Separately for: Daily, Weekly, Monthly report.
Detailed report to show template usage
Hi, Would it be possible to get a MSSQL query report that shows template usage, similar to this one? https://pitstop.manageengine.com/portal/en/community/topic/report-to-show-usage-of-templates With a few more details: Add the names of technicians. Add a period of time to cover specific months (June - August this year, inclusive). Group by technician. Kind regards, Alberto
Report on Purchase Requests
Need a query to run the report of Purchase Requests which will give me the details of Purchase Requests by their status.
Scheduled Reports funtion sent duplicate email
Customer received 02 email same content when i set 'Scheduled Reports'. I check on Scheduled Reports, it just only one report
System uptime report
Hi, Our security policy is that all users should turn off their workstation, fort his I'd like to generate daily report to check sysUpTime of each workstation. regs
How to show date range on report
I'm using SDP 11125. I'm building a report and for one of the fields, I'm filtering by date for the last quarter. How can I get this report to show the date range being queried on the report so it's obvious what the date range is? Thanks!
Worklog reports
Hi all, I would iike to have query that sum all working hours from worklogs in tasks in requests, problems, changes and projects. Idea is to have insight in all technicians activities in specified period of time. I am using MSSQL as database.
report project and departament
Hel I get this report monthly but I would like to add the departament column or type of task that is the same for projects. Can you help me? Thank select max(tc.chargeid)"Charge ID", max(au.first_name)"Técnico", max(ct.description)"Descripción", max(pd.title)"Proyecto", max(md.title)"Fase", max(td.title)"Tarea", TO_CHAR((sum(ct.TIMESPENT)/1000 || ' second')::interval, 'HH24:MI:SS') "T. Empleado", longtodate(max(ct.ts_starttime))"Código", longtodate(max(ct.ts_starttime))"Start Time", longtodate(max(ct.ts_endtime))"EndTime"
Exporting all incidents
I need to get an export of all incidents and notes but the normal route i'm seeing being recommended by doing the New Custom Report --> All Incidents, isn't exporting all the data I need. The main portion I need is to be able to export the requester email address (email of who opened the ticket) and all the notes from the ticket. The ticket ID, Description, status, priority, created date and subject all export fine through the custom reports, I just need a little more info with the export. Is there
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)
Convert assigned time to date / time
Hi i would like to convert the following 1435092529026 in to date / time. What would be the formula to convert Thanks Microsoft SQL 2012 Service desk plus build Your Version: 11.1 Build 11118
[SOLVED] Audit Report
I need a report showing the following fields: Login Name, Technician Display Name, email, Job Title, Department Name, Associate Support Groups, Assigned Roles
All Assets and Managed Software by Full User name
I've seen some queries here that were close, but not exactly what I'm hoping to produce: Would like a report organized by User (full name, not login name) that lists ALL assets assigned to that user, as well as only "managed" type software loaded on their machines. Thanks much!
Date format in query reports
Hi All, Currently running SDP 11120, Postgres SQL (installed via SDP installer) Since upgrading from SDP version 9, one of my query reports isn't working, as it looks to_char in select statement isn't supported anymore, causing an error when trying to run the report (attached). I had previously used to_char to manipulate the date format, for example: to_char(to_timestamp(wo.CREATEDTIME / 1000) + interval '10 hour' , 'DD/MM/YY') "Created Date" Is there a different way to perform the same fuction now?
Last Ticket Update Information
Hi, I'm looking for a report that will show me the last date a ticket was updated, and what the update was (be that a note or a conversation). The aim is to check that tickets are being checked/updated each week. Would want to limit it to a set of Technician Groups, group by Technician and sort by last update date. Can't find a way to do this without code on the Service Desk. Running 11.1 build 11120 Thanks Ian
Report Constructor
Hi, we are testing free trial SDP for our organisation. Can we customise Report Constructor?
need Custom query report to find out total request submitted by organizational user and external user
I'm looking for a custom report SQL query that can help us find out the monthly request submitted by internal user and external user based on their primary email address. and the request need to be grouped by their email domain, like @abc.com The field requires request ID, subject, requester, request status. Thank you for your support. Build Information Your Version : 11.1 Build 11101 PostgreSQL Server Database version: 10.5
Report on closure notes per technician
Greetings Comrades, I have been hunting for a report in MSSQL which will show all Resolution notes for tickets closed in the last 7 days so that these can be reviewed with team members at their one-to-ones. The required column would be: RequestID Requestor Title Closed date Technician Resolution I'm hoping someone with a greater mind than mine can help!
Report - How to report on after hours
HI, Our CEO wants our daily request count at 5 PM everyday. We have daily closed request report that we send at 5 PM everyday. Problem is our technicians sometimes work after 5PM. How can we create a report that would capture the request closed after 5PM? Our report is set to daily - so when it is run at 5 every day it does not capture the closed requests after from the previous day.
additional fields
We define about 200 additional custom fields for request forms, But all often doesn't shows on Report module column , Why?
[SDF-88990] Time Elapsed Analysis - For Current Status
I would like to extract in a form of Query Report the time elapsed for current status of Request. As per below screenshot, i should able to see this request's current status is OPEN status for 28 hours and 33 minutes. Can you help to provide query to get this info. As of now, i can extract only the time elapsed between transition of Status.
Custom Report: Last Month This Year vs. Last Month Last Year Comparison
Hi, I need a report which would give the statistics of tickets comprising of "Last Month This Year vs. Last Month Last Year Comparison" ie., like December-2013 .VS. December-2012. The reported should be ordered Group-Wise and then Technician-Wise. The columns that need to be displayed should be: How to get this?
Report all Technicians
How I Can get Report all Technicians?
Next Page