Email each Technician with outstanding Calls
Is there a way which I can email each Technician with his/her outstanding Calls/Tasks automatically? Regards
Asset Report with request custom's field added to it
Hi all, I need to Join to an asset report's some custom fields from service request's template. Can you help me please? Sdp build 9224 Best regards Antonio
Does anyone know how to run a report that shows tickets that have been re-assigned?
For example, if I assign a ticket to a technician, and that technician assigns to someone else, is there a report that shows this data?
Report on unsuccessful Changes
Is there a way to pull a report on changes that were unsuccessful/failed and were reverted back to a previous stage? I understand that workflows are customizable across customers but this is a useful stat to show changes which were successful on their first attempt. SD 9217 Enterprise MS SQL ------------------------- Canada
Request for detailed Report
Dears, Can you please provide me with query in order to create report in SDP with these fields: 1. List of all Projects, Changes and Tasks (grouped in categories), 2. Status of Project, Change and Tasks (Open, Closed, etc.) 3. Name of technician involved, (User) 4. Total time spent separately for project, change and requests on SDP for each technician. Thanks in advance, Driton S. Bejtullahu
Report for Additional Fields of templates
Hello Can someone tell me if I can get an additional template field in my report ? I have added a field 'Sent to Vendor' which is set by the technician responsible for Vendors. I want a report in which I have the Workstation number and the Send to Vendor field. For Example Workstation Sent to Vendor PC-1921 Premier Systems
Free Webinar on March 14th - How analyzing data patterns can improve IT service delivery
Given that data is an important organizational asset, it is key that users get to access them easily, in order to make important decisions. Analytical tools help in combining data from different sources and analyze them to reveal useful insights. Join our free webinar and know how you can use IT analytics to decipher data patterns, and improve IT service delivery. View more details here Schedule: March 14th Time : 10 am -11 am GMT| 2pm-3pm AEDT | 11am-12pm PDT
***open task by a technician***
Hello, I need a report with all open tasks (not requirements) by a technician. how does it work? many thanks
technician notifications since 9301
Hi Guys, Since upgrading to 9301 sometimes when a users responds to a case the assigned technician doesn't get an email alert. Any idea? Thanks
Reports with Division
Hello I need to write a query report for Received and one for completed request for the month and quarter based on our divisions. We have our department field populating department but I want to report on the level below - currently its populating from AD but there is no standard fields available for Division. Can anyone provide me with a sample query report please
Report Creation in ManageEngine ServiceDesk Plus
Hi, I am having a tough time creating reports. The 'Custom Reports' wizard you have is severely limited in that you can only select a certain area for report creation. For example, I am trying to create a Microsoft Compliance for our company. For that I need to filter all computers, servers, virtual machines that have Microsoft products, I also need to have processor info for each. This is not possible using the wizard in its current form. So that leaves me with the query report. Now, I will
KPI Report
Hi All I was wondering if someone could help me. We are using the ServiceDesk Plus application and I have been asked to produce some monthly reports. Could you advise if it is possible to produce a report which displays the following information Average time to close a ticket Jan Feb Mar Incident Request no of tickets closed (average time to close) no of tickets closed (average time to close) no of tickets closed (average time to close) Service Request no of tickets closed (average time
Description in approval requests
Hello, I have this query in MSSQL that reports all approvals and the approval details. Is there a field that could be added that shows the original description when the approval was created and sent to the approver? We go through a lot of audits, and the approvals work well, but there is no context as to what each approval is for. I know it is captured in the Conversations, but can't find a good way to pull that detail into a report. We are on SDP 9117 with MSSQL Thank you. Dave SELECT wo.WORKORDERID
Mail fetching running but stops fetching
We have a SD build 8127, upgraded from previous versions. Before upgrade there was no problems, but now mail fetching stops every two or three days (status in Admin-mail server is RUNNING, last attempt time freezes). Pressing "Stop fetching" and then 'Start fetching" doesn't help. We can only restart windows service - this helps.
Report on the manual extension of Due Dates
I need a time bound report for those incidents and service requests, whose due dates were manually changed and by who
Report time spent by a member of a project
Good afternoon I need your help please. I need to generate a report indicating that this project involved a member of a project and how much time is spent. Also generate a comparative report on the planned and actual project progress, tasks and milestones. Thanks
Last login time query report
I am looking for a query to show the last login time of technicians of specific support group. Right now I have this query but it shows all technicians, I would like to limit the results to a specific support group: select aal.NAME "Logged User" , MAX(aas.USER_HOST) "IP Address",LONGTODATE(MAX(aas.OPENTIME)) "Last Login time",MAX(au.First_Name) "Technician" from AaaAccSession aas LEFT JOIN AaaAccount aacc on aacc.ACCOUNT_ID=aas.ACCOUNT_ID LEFT JOIN AaaLogin aal on aal.LOGIN_ID=aacc.LOGIN_ID LEFT
Manually run scheduled report
Hi, I'm setting up some scheduled reports and wondered if there was any way to run it manually to test it? I can see various options to schedule it and can change the schedule time? I was wondering if there is a way of manually running it without having to muck about with the schedule run time? Thanks
SLA Breach calculation
Dear All, Greetings! Can anyone help me with my below query on SLA breach. I just want a query to find out the amount of time a ticket has remained "open" after it has breached the SLA. The report should exclude the time the ticket has been under "onhold" status even after breach. Regards, Rama.
Report File (.XLS) Corrupted
Refer this link that i was post before https://forums.manageengine.com/topic/report-file-xls-corrupted#49000008308667 Why i cannot open report .xls file after i download it, and it said "excel found unreadable content....". Before it was okay.
Share Dashboard
In the new version is the option to share the desktop with users. But it seems only to share with technicians and not with requesters. Do I mis something?
Report by Technician
Report by Technician contains worklog informations about tickets (directly associated to a ticket). How can I extract worklog informtation created without tickets (i.e. task work logs)? Thanks
Report
hi all, i have this report, this report show me all incidents avg. but i want I priority avg, II priority avg and etc. it is possible? please help me thank you SELECT ti.FIRST_NAME "Technician", qd.QUEUENAME "Group", TO_CHAR(((avg(wos.assignedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Assigned Time", TO_CHAR(((avg(wo.resolvedtime)-avg(wo.createdtime))/1000 || ' second')::interval, 'HH24:MI:SS') "Avg Resolvedtime Time", TO_CHAR(((avg(wo.RESPONDEDTIME)-avg(wo.createdtime))/1000
Scheduled reports
Is there a way to view other technician's scheduled reports? I have quite a few scheduled reports that have been created with my account, however if an alteration needs to be made to these reports and I'm not in the office then they can't be accessed by any other technician. Is this possible? Thanks
Issues with Zoho Synchronization - Failing - Support File attached
Hi Team - Zoho synchronization has been failing and even when looking at the log files, I dont know why. Nothing has really changed from a back end perspective. Attached is the support file. Can you let me know what you find? Thanks!
Aging Tickets per Technician per Group
Hello, I found the built in Query Report for aging ticket by technician: SELECT AAAUSER.FIRST_NAME,COUNT(WORKORDER.WORKORDERID) "Total Pending Count",COUNT(CASE WHEN DATE_PART('day', now() - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)) <= 2 THEN 1 ELSE NULL END) "0 - 2 Days",COUNT(CASE when DATE_PART('day', now() - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)) <= 5 and DATE_PART('day', now() - FROM_UNIXTIME(WORKORDER.CREATEDTIME/1000)) > 2 THEN 1 ELSE NULL END) "2 - 5 Days", COUNT(CASE when DATE_PART('day',
custom report for requests by assigned technician
Can I generate report for the request by how many technician is assignment to it and how long the request is stayed assigned to each technician ?
Report on Tasks worklog for tasks not associated with a ticket.
Hello, I have been able to create a report of exactly what I need for worklogs and task worklogs for anything associated with a user request. It looks like what I have below. Request ID Assigned Technician Requester Time Spent Time Spent Endtime Subject Description Time Spent Description Resolution 879 Marco A User 01:00:00 05/11/2015 05:32 PM Unable to start computer Computer tower light flashing yellow, unable to turn computer on. all connections checked Troubleshooting PC. Unable to power
Need help in new schedule report
I want to show aging of open tickets(date difference between Ticket created time & today's date) in scheduled report in Service Desk Plus Tool, Is there any way?
Reports: unable to execute the report...
It happens quite often that our technicians are getting the below error message. How can the SD+ admin get to know what kind of reports are running in background for concerned technician?
Reports available in selfserviceportal
We have created a report for the requesters. Is there a way to add this to the selfserviceportal from SDP.
Report That Shows All Tickets Last Updated 7 Days Ago
Hi team I'm looking to build a custom report that shows all tickets open/on hold/waiting on client or waiting on vendor that have not been updated in 7 days. I'm looking to add the following fields in the following order: Request ID Requester Request Status Subject Technician Created Time Due By Time Last Update Time I tried building a tabular report myself and could not filter out the last 7 days. mssql database ver 9.0 build 9009 Thanks.
Asset Mangement
Is there a way to scan/report the local administrators from the computers via Asset Management, or the free version of ADManager? We have over 250 pc's and looking for other options to gather the information.
Customizing Scheduled Reports
Two questions about the Scheduled Report feature 1) Can you specify multiple recipients? 2) Is there any way of embedding the date in the file name, such as by adding a wildcard like %date, %time and so forth? Sang Park
Query Report
Dear developers. I really appreciate your help with my requests. And I'm very sorry to bother you again. Please help to build report. We need a report with the following parameters. It should contain the number of notes the request ID, group, specialist, the number of reassignments, overdue or not, and the ability to adjust the data LONGSTODATE. Thanks a lot. God bless you.
Query Service desk plus
I need a report that allows me to view the filters made by each of the user groups, this through a query. MSSQL, Version 9.3, Build of ServiceDesk Plus 9300
Parent child relationship for request
We needed a report where all linked requests come together . Alternatively an automatic key word based grouping should be available
Report to show First Response Overdue Status
Hi im looking to produce a report that shows First Response Overdue Status, and also who sent the first time response email Thanks Postgres Version : 9.2 Build 923
Ticket type not recognized command in report. [updated]
Hello, Maybe you can assist in a query, what I need to setup. At the moment we have a script (see below) it's nice as I can see handled tickets. But I'm in a need for more advanced script. The need is ti to have it scheduled every 3h or at least once in a day. And the report should contain something like: As the current query I need to manually change dates to see handled tickets and remove duplicates after exported to excel, and it groups the tickets under technician. Can you help to make it so
A new scanned workstation and server
I want to create a report that extracts only newly discovered devices by scanning.
Next Page