Reports by Solution
Hello Everyone Is there any query or built in functions to, make a report based on request solved by solutions Thank You Best Regards
Automatic Notifications
I was wondering if it would be possible to set up a specific notification. lets say the same person calls in multiple times for the same issue in a specific amount of time, is it possible to send an automatic notification on this? Here is our basic use of service desk plus, We have users across the nation who fall under managers and then regional managers. when they have an issue they call a specific department who resolves the issue and puts a ticket in. Now, lets say John Doe has to have his
Custom report of tasks witk costs
Hi team, I need a query where display me the following fields: Task ID Owner Time taken to resolve Other charge Start time End time Description Total Time Taken I need this report to Requests, Changes, Problems, Projects and tasks. SDP have version 9.2 build 9229 in PGSQL.
Query to show all products and all products associated to vendors?
Would it be possible to have a query to show products and a query to show all vendors and there associated products? Right now my acquisition team needs this in order to create some PO's but I can give them access to this list unless I give them Admin access in SD+. This would be a requirement for future releases of SD+, to allow full access to products and vendors based on certain role permissions. But for now if I could get a query at least I would be able to get by. SD+ version: 9.2 Build 9211
Having trouble getting correct information out of SDP for Breach reporting
Management is looking to have a report created that shows certain information I have attempted to go through the support channel, but can't get the information that is requested. I'm looking for a report/dashboard/chart etc to span a year period by monthly increments. Columns would be for: All requests (incident and service) opened during that month Number of requests that breached during that month Number of Requests that were closed while in breach status Number of Requests STILL open that are
Error al generar informe
Buenas tardes a todos. Al generar un informe se presenta el siguiente mensaje de error. Lo sentimos, no se puede ejecutar el informe, al estar ya ejecutándose una generación de informe para este inicio de sesión. Por favor me indican la forma de solucionarlo, la falla solo es con un perfil.
Sql Report - Access Permissions for user
Can someone offer support in generating a sql report based to find out the following information UserID Full Name Permissions i can run two queries 1: select AaaUser.USER_ID,AaaUser.FIRST_NAME,AaaLogin.NAME from AaaUser Inner join AaaLogin on AaaUser.USER_ID=AaaLogin.USER_ID 2 SELECT au.FIRST_NAME 'Technician', ar1.NAME 'Role' FROM HelpdeskCrew hdc LEFT JOIN SDUser sd ON hdc.TECHNICIANID = sd.USERID LEFT JOIN AaaLogin al ON sd.USERID = al.user_id LEFT JOIN AaaUser au ON al.user_id = au.user_id
Report support center.
We have a support center where they receive all issues. Then they classify these incidents to you according to different technical category. I wonder if there is a possibility of having a report incidents by passing user even if they do not resolve by day.
Daily Workload report
Looking for a workload report by time of day and week, for staffing purposes.
Modified departments not reflecting on reports
Hello We are in our 4th week with Service Desk Plus. Many requesters were auto generated and was not assigned to the correct department. We now have created the correct departments and assigned the requesters to them but this does not reflect on any new reports which still shows all requests on the same department. Is it possible to update it?
Software installed report by user (not workstation)
I am looking for a software report that will show me a particular installed software by user (not workstation). Such as "Tell which users have Microsoft Office 2016 Professional installed"
Changed department for a number of requesters and want a report on the new department
Hi, We recently changed the department a number of requesters belonged to. We now want to run a report of what requests these users have submitted since the start of using Service Desk. The new department name is 'External Customer'. So what we need is something like 'select all requests where department is external customer' Thanks
Service Catalogue Query
Hi, I´m running servicedesk plus version 9.2 build 9212, my database type is Postgres, when try running the query below i get an error, will be so kind helping me to get it right for my build and database type please SELECT serd.Name "Service Category", max(list.Templatename) "Template Name", max(qd.QUEUENAME) "Assigned Group", STUFF((SELECT ',' + tgm.QUEUENAME FROM TemplateToGroupMapping tgm WHERE list.TemplateID=tgm.TemplateID FOR XML PATH(''),TYPE).value('.','nvarchar(max)'), 1, 1, '')
Time Report
Hello! I am trying to build a report to pull the total resolution time for each ticket that is resolved for a given month. Unfortunately, when I try to pull the report, it gives me a new row for every work log entry, and not just one row per ticket. Any assistance or direction would be helpful. Thank you, Leslie Dunn Supervisor, Enterprise Help Desk D&W Fine Pack
Report to show breached SLA's
Morning all, im looking to build a report to show breached SLA's, which have been passed over to a different group after the SLA has been breached. Essentially we have a 2nd line which on occasion pass the incidents over to 3rd line, after the SLA has breached Any ideas? thanks Version : 9.2 Build 9209
Customized Report
Dear support , I want create report contains this columns Software Name , PC name , Current PC user , Site of the PC Can you send Query For this Report
New user request report
Hi everyone, Just wondering if there is a report that can tell me new users (imported from AD within past month) and any incidents they have created in that month. The idea is to improve new user support so we'd like to report on how many requests they are creating when they join our organisation. Thanks, Daniel
Detailed report
Hello, Can someone provide me with a query code to generate the following report: ASSET_NUMBER USER_NAME OS ASSET_TYPE DEPARTMENT LOCATION ASSET_CATEGORY LAST_PM_DONE_DATE HOST_NAME USER_ID USER_POSITION PURCHASE_DATE RAM HDD SYS_SPEC Thanks
Latest SDP release v9229 supports custom fields and service catalog for Analytics Plus
Hello there! The latest ServiceDesk Plus release v9229 is now available and supports custom fields and service catalog for Analytics Plus. By integrating with this build, you can view these data sets in Analytics Plus during the SDP sync. Now you can create reports and dashboards, based on this newly available information. Resources Read me document is available here. Latest service pack for ServiceDesk Plus can be download from here. In case you wish to download Analytics Plus, use this link.
Creating a ServiceDesk report showing the SLA compliance and violation trend using Analytics Plus
Creating a ServiceDesk report showing the historical backlog trend based on priority
Scheduled Reports
Hi Do you know of a script we can run to show all scheduled reports and times for all users ? Andrew
Project - Reporting time spent on tasks
I seen quite a few posts about similar things but I have yet to find one that works flawlessly for me. I nicked this one from another post and added "createdtime": select max(tc.chargeid)"Charge ID",max(au.first_name)"Technician",max(ct.description)"Description",max(pd.title)"Project Title",max(md.title)"Milestone Title",max(td.title)"Task Title",SUM(ct.TIMESPENT)/1000/3600"Timespent",max(ct.TECH_CHARGE)"Tech Charge",max(ct.other_charge)"Other Charge",max(ct.total_charge)"Total Charge",longtodate(max(ct.ts_starttime))"Start
Adding custom fields in reports
Hi, this text was written with the help of automatic translation. I'm sorry if it looks like nonsense =( If you change the status of the application with the "open" to "on hold "we fill the obligatory comment. Question: Is it possible to withdraw the comment in the report?
Custom Report to Show Me Call Closure Rate
Hi I am looking to write a custom report that can show me the rate of call closures. Eg. I want to know the precentage of calls that have been closed within 24 hours. My boss has set me a target of getting 90% of calls closed within 24 hours but I cannot see a way of setting up a report to show me the current percentage.... Can someone help please
How Can I export in csv file user/ticket/hour to resolve the site
I have this required. I need to be have a .csv file with this filed: user, ID ticket, Object request, Priprity, hour to resolution the ticket. I see in Tab Report, and I see so many csv model. Is it possible to be have a custom .csv file
When I want to create a custom report. The Pick Value list does not open in the advanced filter options
When I want to create a custom report. The Pick Value list does not open in the advanced filter options. We are working with version 7.5.0 build number 7504 So I can't select for example 'Request status' = Open Johan So
Report assistance
Dear Support, can let me know how I can generate a report for: Top 10 Incident/Request Reasons per month? 9.2 Build 9212 Thanks
Automatically escalated requests
hello , i need to show Automatically escalated requirements report and manualy escalated requirements report. how i can do this ? Please, help me. Best regards,
Inventory Audit Changes
I'm not sure when I signed up for this report to be mailed but it comes every day. The report itself is not very useful, it does show changes but it shows every computer regardless of a change. If it only showed the changed computers it would be much easier to read. How do I turn it off? The email is titled Inventory Audit Changes and the PDF says Audit Changes detected during the Scan.
Response Due by time Approaching
Hello, Is there a way to have a report shown on the dashboard, that shows Request Approaching Response SLA? Similar to the Dashboard graphic Request Approaching SLA. I can't create this dashboard report due to not being able to select a filter with Response due by time < 20 minutes. Am I missing something? What I need is for the technicians to be notified when the Response due by time is approaching. It would be great to have an alert to warn the technicians about this. Thanks for your help
How do I build a report to capture all open tickets in my groups queue for the day?
How do I build a report to capture all open tickets in my groups queue for the day?
Timespent by technician
Hi all Is there a way to create report like this, i try but i saw it just reports timespent log count instead of timespent duration. tech1 tech2 tech3 tech4 Time spent Mon Aug 01 00:00:00 EEST 2016 7h 15 m 2h 11m 3h 06m 7h 16m 19h 48m Tue Aug 02 00:00:00 EEST 2016 ... ... ... ... ...
Need per Month
I have this report that gives me current average time to resolution, however I need to get it by month. assistance greatly appreciated select top 50000 qd.QUEUENAME "Group",convert(varchar(10),(avg(wo.completedtime)-avg(wo.createdtime))/1000/3600)+':'+convert(varchar(10),((avg(wo.completedtime)-avg(wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((avg(wo.completedtime)-avg(wo.createdtime)))/1000%60)) "Avg Resolution Time" FROM WorkOrder wo LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
Reports will not run
I am not able to run any reports the message comes up (Sorry, Unable to execute the report, as a report generation for this login is already running. I have closed out of all sessions of the internet and opened them back up and still cannot get a report to run. I even logged out of SDP and logged back in and I still get this error. I had a couple of other technicians to try to run a report as well and they get the same error.
SQL Query for Ticket Resolution Notes
I'm running the query below to create a quick report but would like to enhance it to include the resolution notes. Which table has the resolution notes? My goal is to make sure tickets are being closed with a few notes regarding the steps taken to resolve the issue. Thanks for your help SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", cd.CATEGORYNAME "Category", wo.TITLE "Subject", ti.FIRST_NAME "Technician", pd.PRIORITYNAME "Priority", std.STATUSNAME "Request Status", std.ISPENDING
Missing data columns in report wizard
Hello I would like to have two different types of reporte for my technicians where they (and I) can easily check which type of tasks they have reported worklog time for in a specific day or week. For the Module Change I manage to get this two types with the builtin report wizard. Type 1: Detailed report of all changes with completed worklog time this week New Custom Report, Tabular Reports, Module Changes Columns: Change ID Title Change Owner Time Spent Technician Time Spent End Date Time Spent Date
Report needed for calls open more than 5 days
I need to generate a report that shows me all requests open for more than 5 days grouped by Group. Is this something someone has done? Thanks!
TimeSpent Report
Hi, I was wondering if it is possible to have a timespent report across the board instead of just on Requests. I need to keep track of time spent on Changes, Projects and Problems and this is becoming a big issue. The DB is PostGres and the HD version is 9.2 (9227)
Technician has no edit option on report he created?
I have a technician that created a report a while ago but back then he had the SDAdmin role and now he doesn't have it anymore but he has a role that gives him full access to reports and he can't edit that report anymore. I had him to create the same report with a different name and he is able to edit that one. What would cause him to loose the edit option on the report that he created since he lost admin access? Can he regain edit access to this report? We are running SDP 9.2 Build 9211 with MSSSQL
Next Page