Reports: All Closed Jobs
Hi, I need to run monthly reports on all closed jobs, would someone advise on how I do that or point me towards a resource. Thanks
Report for contract expirations that show a list of attached assets.
We're just starting to use the Contracts module of ServiceDeskPlus. I'd like to generate a report quarterly that shows a list of contracts that will expire for the upcoming quarter, and the list of assets that are attached to each contract. How do I do that? -thx Don
Tickets closed by another tech
I have a situation where technicians are closing other techs tickets as part of a clean up activity. I need to produce a report that shows which technician closed tickets groups by day, who that ticket was assigned to, the date the ticket was created, and who created the ticket. We use SQL server. Thank you. Created Date Request ID Technician Closed by Created by Closed Date 9/1/15 12345 Sarah Lange Robert Jacobs Joe Swanson 12/3/2015
Closed tickets reports
Hello, We currently have two levels of ticket closure in our service desk, a ticket is first put in the resolved state by the technician, and then it is closed by the user, if a ticket has been resolved by a technician but is not closed by the user, the system will automatically close it after a specified period. i need help generating a report that shows all the tickets closed by users and all the tickets closed automatically by the system. can anyone help me with this query? thanks in advance.
Reports - Generate only the graph / Top 5 categories
Hi, Service Desk plus : 9.1 - 9115 Database - MS SQL Could you please help out with the following questions 1) Can we generate a custom report with only the graph as the output? That is without the table data. - Example - the number of tickets opened last week, the number of tickets resolved/closed last week, total number of tickets opened last week 2) Please tell me how to generate a report with a graph on the top 5 categories raised last week / last month. please let me know if you
Track reassigned ticket
Hi, Is it possible to create custom view that shows how many ticket has been reassigned by me to 2nd technician. It will be very helpful to track and follow up. If not please provide a query to extract below report. ID Subject Requester From Technician(1st Technician) To Technician (2nd Technician) Due By Status My database is PGSQL with 9.1 build 9112 WBR, Utsav
How can we generate a Custom Service Catalog Reports with aditional Fields?
How can we generate a Custom Service Catalog Reports with aditional Fields? Thanks
store reports directly to a drive
Hi all, is it possible to store reports directly on a drive and not to send them via mail? Many thanks in advance Kind Regards Sascha
Hardware info report
Dear support, I need to create reports,Please help me out. Report to show Hardware information (Employee name ,department,Device type,Memory,CPU,OS,Disk space,card Network,card Screen,Serial number,type pd screen,serial number of screen)
Report - Service Request + Approval data
I need a report like this bellow: With Criteria: Approval Stage Status = Approved Request Type = Inclusão [Brazilian Portuguese word] Possibility to filter date Thanks for help SDP 9112 MSSQL
SOLVED: Report Project % completion
Hi Guys, How can I take one % of Project completion based on tasks % completion? Thanks,
Reports in SD
Good day, I have matrix report that shows count of workorders per place and per technician group. Everything was fine until some day. Now I look at the report and see some strange conditions in SQL query. SELECT sdo.NAME "Площадка",qd.QUEUENAME "Группа",wo.WORKORDERID "ID заявки" FROM WorkOrder wo LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition
Asset info Report
Dear Support, Can you please Provide us report to show employee name and the asset which is belong to him/ her Employee Name ,Asset 1 , asset 2 , asset 3 , asset 4 ,.......
Employee info report
Dear support, I need to create reports,Please help me out. report to show Employee information (Employee name ,Email Address, Departments,mobile no ,Phone no)
add link for requests id in Query report
Hi all, I create a query report by SQL. I want to add link for requests id. How can i achieve it?
Survey Query Report using Percentage Values
Hi, Can you provide a query to run a survey report based on the % of satisfaction for MYSQL? My version is 8.0.0 Build 8011. It would be good if it could include the date the survey was created, the requester, the request subject, the technician, and the percentage value of satisfaction. Warm regards, Abby
Please help me with what would seem to be a simple report.......
I need a report that tells me the average time it took to resolve tickets during a certain time frame. It should not include the time a ticket is on "hold" or "waiting on requester". It should also not include non-working hours. I would like the average time to be outputted by Group Please please help me.
increase the font size in customer reports
hi guys, How can I increase the font size in customer reports including the table and lable?
Question on Reports
Hi, Service Desk plus : 9.1 - 9115 Database - MS SQL Could you please help out with the following questions 1) Can we generate a custom report with only the graph as the output? That is without the table data. - Example - the number of tickets opened last week, the number of tickets resolved/closed last week, total number of tickets opened last week 2) Please tell me how to generate a report with a graph on the top 5 categories raised last week / last month. please let me know if you need any
Query reports specific fields
Good *insert time of day*! I have been looking for a query report that which presents me with the requestors name and e-mail, but only for those individuals which have created tickets which have been resolved/closed at the time of running the report. Anyone have an idea or solution to attain this information? Best regards, Niklas
Approval Report
I would like to build a report to a specific ticket that show me: - the user approver - Date when it was approved - Details of description about approval Versión : 9.0 Construir 9041 MySql
Report conversations
I would like to build a report to a specific ticket that show me: - Conversations between technician and requester - Date to these conversations Versión : 9.0 Construir 9041 MySql
Reports to list Top 10's
Does anyone have or can anyone provide reports that list the 'Top 10's." I'm looking to run weekly reports that list the top 10 requester, category, and subcategory. I'm open for suggestions, so if you have others you'd like to suggest please let me know. Thanks in advance, John
How to Setup Zoho Reports Analytics
I would like to try the Zoho Reports Analytics from SD+ but have not found setup instructions. I'm currently on version 9.1 Build 9114 and using a MSSQL database.
Report on Custom Fields for Users
I have added a field called "Begin date" for the users of the system so that one of my coworkers will know if they have recently been added to the system, but she needs to know this through a report. What would be the Query to pull that information?
Discussion Notes in a Report
Hi Is there a report which adds the ticket discussion notes? Ive created a few custom reports but can not find a field that will show this information and I need to see what the IT staff member has replied to the customer at a glance without going into every ticket individually Any help would be appreciated thanks Steve
Report Creation
Dear Colleagues, I would like to know on how to create tabular reports that has a graph, showing how many request are solved on the same day it was created. Basically our management need is to see how many we can resolved request on daily basis. I was able to create one but the problem is that there are request that was put on hold for like two days and then the technicians resolved it, making the count inaccurate. Our database is MSSQL Version 9019
ServiceDesk Plus reporting dashboard tool
We are using ServiceDesk Plus now. Any possibility to link up SD Plus reporting dashboard tool to our Accounting database and making report out of it?
how to create a monthly report for all incidents?
this report contain Incident name,requester,technician,solutions, create time and so on.
Exchange 2010 Mail Settings
I am unable to setup Service Desk Plus with an email on exchange 2010 everytime i try to edit the settings i get this. FAILURE :Email Settings saved successfully. But error occurred while trying to check connection with mail server - Problem connecting to mailbox. I was told by a support rep. that manage engine doesn't support exchange 2010, and had no estimated date that they would support 2010. Surely there is some way to make it work... please any help would be appreciated.
Time spent by Tech report - seems incorrect
I have ran a custom 'Tech time spent' report, but it assigns time to another technician's total time spent when time is spent on that technicians ticket by a different technician?? e.g. John Smith works on Joe Bloggs ticket and Joe Bloggs has that time added to his total time spent, when this should really go against John Smith's time spent total. Can this be fixed please?
Assingment report
Hello! We want to make a scpecial report for us. Our technicians are often reassign requests to each other. And we want to look requests, where technicians did reassign requests, who gave to whom. Report about reassign of reports. Something like... *id request*, *requestername*, *createdate*, *assingment technican*, *2nd assigment techincan and date of assign*, *3rd assigment techincan and date of assign*, *closing date*. How we can do that? Thanks for your help, in advance :)
Generate a report for timesheet management in project
HI, Can anyone tell me how to Generate a report for timesheet tracking for users in assigned projects.
I need a new custom report
Hi could someone help please, I need a query report which gives me the average technician score on surveys returned for the previous month. May also be useful if date range could be adjusted. SD+ version build 8216 MSSQL Thanks Charles
Report - Average Completion Time per Technician (not SQL)
Hi Team, I'm wanting to create a report (not SQL please, I'd like to know how to do this for other reports) that will show me the average completion time of tickets per technician. For example, defined for a date range: Name Average Completion Time John 6:12 Peter 4:34 Steve 5:09 This is what I've tried to do, but it just returns 00:00:00 for each technician: I choose Matrix and then TimeSpent on the first screen, then these options on the 2nd screen: Thanks guys!
incident history report
Hi All, I am looking for a way to produce a report to show me the history of a request. So when filter it to one "Request ID" the report will show the following. Request information and History/all update/notes etc. Kind Regards Rich
actual Inventory
Hi, I want to manage our inventory better. So I made a custom report based on the following filters: Assets in store Product type wich look like this: I would like to specify "workstation" more. We have PC's and laptops. I would like to split workstation in those two models. Is there a way I can seperate PC's and laptops from "workstation"? regards, Jordi van oosterbosch
Time Spent Report - Grouped by Request ID
Some of our tickets have dozens of worklog entries. I need to create a report that allows for grouping/summing total time per Request ID by technician. I don't really need the individual time entries from the worklog. I then need to compare that to the "Estimated Development Time" field we use. Note: I DO NOT have ME SysAdmin rights - I am just a power end-user. Also - is there an easier way for techs to enter time other than to go to Actions - Add Work Log Entry?
blank reports
I am trying to display a report of service requests by technician for the previous month and every way I try it it the report comes up with no data
Standard incident report
Hi all, I'm looking for a standard incident report that simply shows me what has happen on the a incident through its life i.e from when it was logged to when it was closed. I want the report to include who logged the called, who the call has been assigned to etc..etc.. Thanks for you help, in advance . Richard Overton MCP.
Next Page
