How to change Excel Report format?
Hi, is there any way to change the Excel Report format to not showing the header (such as: company logo, report title, etc.)?
How to change Excel Report Format
Hi, is there any way to change the Excel Report format to not showing the header (such as company logo, report title, etc?
Query to list all templates that use a particular field (or custom field)
Good morning, I'm looking for help creating a query can display a list of all templates (both incident and service request) that contain a field. In this particular case, it's a custom field, but it would be useful to be able to produce a list of all templates that use a field regardless of the field. My use case is that I've been asked to modify a custom field, but with about 100 templates, I don't know which templates contain this field. Thanks in advance for your assistance. -Adam
Ticket burn rate and the art of help desk planning
Ticket burn rate is the percentage of tickets resolved as compared to the total incoming tickets for a given month. You can tweak this report to give you weekly stats as well. There are a variety of situations where the burn rate report is helpful. One such scenario is when you have to make staffing decisions. A burn rate of above 80% shows that your technicians are able to resolve most of the requests within the same month. Anything below 80% is an indicator that your helpdesk may need more hands.
Project Report with Associated Tasks (additional question)
https://pitstop.manageengine.com/portal/community/topic/project-report-with-associated-tasks I need to change that up a bit. I replied back to the answers on here, but never received a response. If the question is marked answered, are you notified of any additional comments - just for future reference. I need a report that only has the following: Project Title Project Status Project Owner Project Scheduled Start and End Milestone Title Milestone Owner Milestone Status Milestone Schedule Start and
How can I get a list of all templates that are enabled
I'd like to know if there is a way to get a report or query that lists all of the Service Request templates and all of the Incident Templates that have not been deleted or disabled. Thank you, Adam
Query report - tickets onhold without response
Hello, We need to have a query report that shows tickets that are onhold and have not been updated for more than 7 days. I found this report online which is kind of what I want but 'Waiting for User' should be 'Onhold' and I am concerned about the last update time rather than creation time. SELECT wo.WORKORDERID AS "Request ID" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE ((std.STATUSNAME = 'Waiting
Tech Attendance report
I would like a report to show a tech's availability based on calendar entries for vacation/ sick time etc. columns: tech name (selectable - select one or multiple names) month (selectable - current or previous) date reason for not being available i.e. on vacation, sick, personal time etc. total of each "reason" running 9.0 build 9008 MSSQL
Custom Report Filtering Problems
I have created a report to show all overdue cases and I have 2 questions on the filter options 1. to show to correct data, I set the filter with the sequence: Request Status is "Open" OR Request Status is "Onhold" AND Overdue Status is "yes". If I change the sequence to Overdue Status is "Yes" AND Request Status is "Open" OR Request Status is "Onhold", the result is difference and the data is wrong 2. I saved the report, and next time when I tried to run the report again, the filter option will automatically
Audit Trail Report
Dear all, Is it possible for me to get an audit trail report from the Service Desk system? Of who has done what at what time and such details? Will appreciate any insights to this. Regards, Davis
Question/Advice Sought Regarding Customer Facing Dashboards
I would like to be able to provide a dynamic dashboard to my requesters that displays all open incidents. This would allow anyone who is a requester to access it and see all issues that are being addressed at moment. Has anyone done such a thing in this product and does anyone have any advice on how to accomplish this?
Query that links software list with purchases of that software?
I need a list of software and the purchases with pricing for each software in our list. I can get a simple list of software via: select sw.swmanufacturerid, sw.softwareid, mfg.name as 'Manufacturer', sw.softwarename as 'Software Name' from softwarelist sw left join softwaremanufacturer mfg on sw.swmanufacturerid = mfg.swmanufacturerid order by 3,4 I can get a list of software purchased/received via: select po.purchaseorderid, po.poname, po.vendorid, org.name as 'Vendor' , poe.quantityordered as 'Qty',
Custom report on tickets with no update for a day
Hi there! Does anyone know how to create a custom report that can report on the 'Last Update Time'? For example I'd like to schedule a report every day to show the team a list of tickets that need to be updated today, because they haven't updated the customer for 24 hours for example. I believe I'm running MS SQL, as I used another member's custom report for something else and that seemed to work! Any guidance is very much appreciated! Thanks!
Requester report
Hi. I need a report showing requesters and the status of an "Additional field" . How do I do This? Regards Jens
Reports involving "User additional fields"
Additional fields are usually accessible from the report editor, but not "User additional fields". I have created 2 fields pointing at the persons organisational affiliation and need an advanced matrix report showing: created time requests per Year/month grouped by "field1" then by "field2" Is that possible to achieve? /cli
i need report according to template
hi i need to make report according to template and show all fields Version: 9.4 Build 9407 postgresql
Project Report with Associated Tasks
I need to be able to create a report for Projects - which should include all tasks/milestones, any work that was done within that task, dates created/assigned, Due Dates, Length of time opened, % Complete, Date Completed, Project Name, Assignees, etc. In other words, an all inclusive report on Projects. Is this something you can help me with? We will use Projects heavily in our company.
Sorting Option Through Reporting Program
I've ran a couple reports and for whatever reason, the ticket numbers or created dates aren't sorted correctly - meaning that they aren't in order. Is there a way to sort it in this reporting program, rather than trying to export it into Excel and then sort it? Thanks for the assist, HL
create report for request status
hi, we need to create report which have only two status in history "Create by" & "closed by"(without "resolve" or "onhold" just created and after close ) and both status is given by the same user. (see attach file) we need to show report like this (see attach file "Report 1")
Scheduled Reports saving to a folder
I want to create a report thhat list of all the PO raised today up until the time the report is run. This report then need to be exported into a cvs and or excel format so that I can import this into the finance system. I have seen a query in the community that gets the information, I just need to work out how to just get todays orders. But I cants see a way I can automatically run this report on a schedule and save the file to a folder that the finance system is monitoring. Any ideas how I can do
Report that returns the orders in which a technician participated
I need a report that returns the orders in which a technician participates and the state is resolved. All report i test show the last update state, i don´t want to take the last update of the order, you should look at the whole history. I have MSSQL - ServiceDesk version 9.3 Thanks and regards!
Tasks Auto Assign
It has been brought to my attention that tasks that are assigned to a group are not being assigned to a specific technician. Also I have also noticed while testing this bug that tasks being assigned to someone who is set Away are not being re-assigned to their backup technician.
Query Report
Hello, customer would like to have a report with the time of any actions/updates that happened on every requests, like the ones you get if you click on the History tab of a request (see image). Anyone that knows in which tables are these info stored and can give me some hints on how to build the query to extract them into a table? Thank you in advance Marco
Query Report Not displaying all ServiceDesk Info
I'm running the below report and getting results but only showing one of the 2 groups we have and only showing 1 of 4 priorities, I can't work out why it's not displaying everything. ServiceDesk 9.4 9400 MS SQL SELECT qd.QUEUENAME 'Group',pd.PRIORITYNAME "Priority" , convert(varchar(10),(avg(woh.operationtime-wo.createdtime))/1000/3600)+':'+convert(varchar(10),((avg(woh.operationtime-wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((avg(woh.operationtime-wo.createdtime)))/1000%60)) as Average_Resolution_Time
Report to detect if AntiVirus is installed
Hi. Newbie here. Looks like I have to write a custom report to see which workstations do or do not have antivirus installed (McAfee). Can anyone share a custom query or direct me to the right place on writing my own? Thanks.
Request resolution time by age tier - A powerful KPI to measure help desk performance
Request resolution time is (perhaps) the most powerful indicator for a help desk to measure its overall performance. This is because request resolution time is directly associated with the efficiency of your help desk. The faster your help desk resolves request, greater is the efficiency. As per the definition, request resolution time is the measure of time taken to resolve a customer's request. It is usually measured in hours. For instance, a request raised at 8am in the morning and resolved at
Report Service Desk Plus
hi, asap i need report like this (please see pic). service desk plus Version : 9.3 Build 9303
What do you use to create your reports?
Hi!. Again, I'm very new to ServiceDesk Plus. How are you all creating your reports? I realize that it may depend on the report itself and how much data you're trying to retrieve. Are you just creating custom reports through ServiceDesk Plus or do you have another program that you use to pull data - like Crystal Reports or Business Objects? Some examples of reports that we run currently are: SLA breaches - those that have breached for Response and Resolution (by Support Group and Tech) and First
Requester name, mail, login in category report for last 6 months
Hi, I'm trying to create a report that queries the following items: (We're on 9.3 build 9335, MSSQL Server 2008) Requester first name Requester login name Requester email address Category is: 'BS&CP - Development & Database' or 'BS&CP / SAP' Request status is closed Request created within last 6 months Column that shows the number of requests grouped by requester (optional) I'm not very firm with SQL so any assistance will be greatly appreciated! Best regards
CMDB report
hi i need know Which program is installed on which computer ? there is one way to see but i need it in report. thank you
Tickets Aging Analysis
Hi guys, I am currently looking to run an analysis the tickets aging against its status. Like the ticket's status "in progress" for how many days, or the ticket's status "pending user action" for how many days? Is there a way to do that? Thank you.
Customizable audit report
Hi, i need to create a Customizable audit report like Audit history by Changes, but only for workstation and software changes... Can you help?? Regards..
Category, Subcategory and Item reporting
Hi I have written a sql report to display category, subcategory and item details and would like to ignore the greyed-out records but I cannot work out which tables I need to access to achieve this. I tried isdeleted fields but they refer to genuinely deleted record. BUILD 9317 MSSQL Report so far: SELECT "cd"."categoryname" as "Category Name", "cd"."categorydescription" as "Description", "sd"."name" as "Subcategory Name", "sd"."description" as "Description", "id"."name" as "Item Name", "id"."description"
En-mass Create Daily Report?
Is there a way to use the "Query Report" function to create a single report that would send an email to each Technician, their individual number of "Open Tickets" without having to create a whole new report for each Technician? I'm looking for one report that would email around 27 people just their number of "Open Tickets" in the email sent to them, not the same report with everyone's stats sent to everyone. Unless me and a colleague who were at a conference in NY last year, 2017, heard incorrectly,
Creating request open and close report
Hi there, We need to produce a weekly report of requests that are created and then closed by a particular Group. i.e we want to know that over the past seven days, 89 jobs were created and assigned to a particular group and 68 were closed by that group. Is there a way to do this with the custom report creator?
Custom audit report
Is it possible to have a servicedesk plus audit report for assets changes by technician? Specifically, I am adding an inventory management group and I want be able to report on the changes those technicians make to assets. Ideally the report would run nightly for that day. The standard asset change audit report shows a bunch of scan changes that I dont need to report on. SDP build 9330, PostgresSQL
Request for a custom report
I am using SDP 9.3 build 9332 running MSSQL. I would like a custom report to show me the average time it takes each technician to close an incident or request. Can anybody help with that?
Report on tickets raised outwith business hours
We are trying to create a report on incidents created in our ServiceDesk over the last year in our out-of-office hours, however the report function requires specific dates and will not search for time ranges only. We require 3 reports on the number of incidents with a level of "SCOTS", "STEPS", "TELEPHONY" "WEB" created between 01/01/2017 and 31/12/2017 in the following time ranges: Report 1: Mondays to Thursdays - 00:00 to 08:30 and 17:00 to 23:59 Report 2: Fridays - 00:00 to 08:30 and 16:30 to
Reporting on Custom Fields
Hello, I've just discovered that the only Service Catalogue custom fields I can report on using the wizard are those created under the 'Common Fields' service category. I don't have the option to report on any fields created under specific service categories. Is this a bug that is due to be addressed soon, or do I need to look into pulling these reports using queries? If I need to run queries I'll need some advice please! Build 9324 MSSQL database Thanks, Frank
Trying to build a report showing all incidents created by requesters only, not technicians.
Good Day, I'm trying to create a report that shows all incidents created since Aug 1st, 2017, but I want to filter out requests created by technicians. I only want to see requests from those that are just requesters. Is there a reasonably easy way to do this? Thanks,
Next Page