List Support Groups and 'Unpicked' notification to
Hello, I am trying to create a query report showing who receives the Unpicked notification for each group. I tried the query below, but it's not giving the correct results. select distinct queuename "Support Group", au.First_Name "Unpicked Notification" from queuedefinition qd Left Join queueEscalation qe on qd.queueid = qe.queueid Left Join aaaUser au on qe.escalatetoid = au.user_id I'm not quite sure what I'm missing. Any help is appreciated. Thanks, Sheila
Unassigned Time Report
I need a query to show me how long you were a ticket without being assigned. Ideally that allows me to select a specific support group, select a time range and is the last month. SDP Professional 8108 MSSQL Fields: request_id Date / time create Date / time assign Hours / minutes without to assign Group Category Subcategory Thanks a lot! Mauricio
Number of emails
Hello, I have a department who use SD+ and would like to count the number of emails received a day, this includes replies to existing calls. How can this be reported as I can currently only see how to count the amount of emails that are new calls from a day? Any help is appreciated Thanks, Mike
Software on workstation query
Hello, I have this query that reports on a particular software installed on all systems. How could I get the report to also show the model of workstation or if it is a server or workstation? Thanks. SELECT WorkstationName 'PC Name',softl.SOFTWARENAME 'Software Name',softl.fileversion 'Version',aaaUser.FIRST_NAME 'User' FROM SystemInfo sys LEFT JOIN SoftwareInfo soft ON sys.WORKSTATIONID=soft.WORKSTATIONID LEFT JOIN SoftwareList softl ON soft.SOFTWAREID = softl.SOFTWAREID LEFT JOIN SoftwareType
Report on templates used
Is there a report I could run to see the count on the number of templates being used over the past month? I am trying to remove some old templates, but want to make sure they are not being used.
Conversations and the NotificationContent table
I need to build a summary of requests with all details and contact associated for that job. I am building a report of a list of outstanding (open & on hold) requests with: Technician assigned to, requested by, time& date logged, request description and subject, work log technician, worklog description and time, conversation summary and description. I just cant find out how to join to the table [NotificationContent] which I beleive hold the coversation descriptions. Can any one help me out?
Report Needed - Average Time to Close Ticket by Month by Request Type
Need some help in producing a new query report for Average Time to Close tickets by Month and by Request Type.
export requesters
hello i need to export the requester list from SD+ with all the information they have (id, department, phone, site,.....)
Updating Site Info
We have a list of sites in our financial software, and I would like to copy it into SD+ via a daily SQL job. In which tables can I find the address, site name, and phone number?
Audit chnages report
I need a report with Audit Changes of computers with filters: Change type like: "system" change details starts with: "(WORKSTATIONNAME) changed from" Audit time: las 7 days Is it possible?
report pulling all fields in purchase order
hi, i m looking for a query report which could get all fields in the purchase order, including product type, description of each item and remarks. thanks.
How to change the header of the Report's header?
Hi Dear Support, I have a task to add to query report some information in the header. So I had no problem to wright query report and at the moment it looks like a table. Now I need to add some custom information in the top part of the report: several text lines and dates period, which were used in the query. Please advise, how can I do this? We are using MESDP 8.0.0 Build 8017. thank you in advance, Irina
Request Type field not listed in TimeSpent reports
Hi there, As far as I can tell, when creating TimeSpent reports (or editing existing ones) there is no way to access the Request Type field, either as a column to include, or criteria to filter on. This seems strange as most other Request fields are available in this module. Am I missing something? Is there a technical reason, or is this just an oversight in the reporting module? Thanks, Richard
Forgetting to add completed work log
We've got technicians who forget to add work logs, is there a report that can be run to identify which jobs have not any work log added?
Reporting on re-assigned/escalated tickets
Can i please get the MSSQL Query for the linked report : https://forums.manageengine.com/topic/reporting-on-re-assigned-escalated-tickets
First Response Violation Report
Is there a way to get a report of the % of First Response Violation's over a given time frame? If not is there a way to get any type of report on the First Response Violations?
reports
hello i created multiple support groups, how can i create roles where each support group can only generate reports related to its group
Help with Report needed
I need two reports One report that shows me the non-closed service requests that are NOT linked with a Change (sorted by Service-ID) One report that shows me the non-closed service requests that ARE linked with a Change (sorted by Change-ID) I was able to create the basic reports, but i couldn't figure out how the Changes were linked in. Thanks in advance.
Custom Report Help
Hi, I need help creating a custom report. I've tried looking at the SQL but i can't get this to work I need a report with the following columns Asset Tag Resource Category Product Type Product Vendor Name Resource Name Location Cost Replacement Cost Where cost is the purchase cost of the item and replacement cost is a custom numeric field of assets I need the report grouped by site e.g. site1 xx xx site
Edit report for date on installation and deinstallation of Software
Hello Community! I would like to ask you to help me with a report. I need to find out, when a Installation and also the Deinstallation was done. Here is the report to find out, which software was installed: SELECT workstation.WORKSTATIONNAME "ResourceName", workstation.MODEL "Model",workstation.LOGGEDUSER "Last Logged In User",sl.softwarename "Software" FROM SystemInfo workstation LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID LEFT JOIN SystemInfoDomain sysInfod ON workstation.WORKSTATIONID=sysInfod.WORKSTATIONID
Work logs are not being counted as time spent
Several of my tickets are coming back with Time Spent 0:00 when there is a work log of 1 hour. Several of these have this. How do I set work logs and a report that has Time spent to read the same thing. Or do I need to use a different field? John
Is there a way to recover deleted Reports
Is there a way to recover reports that were accidently deleted from My Reports?
Need a query report for MySQL
Hi, Is it possible you could generate a query in Mysql format for me, so I can produce a report? 'Resource Name' and ' all scans of a workstation report within the last 30 days'. Something like that: WK Scan date Status Workstation1 01/06/2012 Successful Workstation1 02/06/2012 Successful Workstation1 03/06/2012 Failure Workstation1 04/06/2012 Successful Workstation1 05/06/2012 Successful Thanks, Maria
Interface bug when using russian language
Screenshot attached
Bios Date missing from Report Builder
I had been using an older build of Servicedesk for some time and recently upgraded it. After the upgrade, I noticed that the field "Bios Date" was missing from the report builder and I was wondering how I could add it back to the selection options available when building reports. I saw a report in the forum here with the Bios Date included, but it was a Query report and I am not interested in using SQL to build reports and would rather use the GUI.
Pie Chart in Contracts Report
When I run a Contracts report, the pie chart on the first page shows parts of the total number of contracts. I would like to have the pie chart show the total value by Company Name. I don't know how to change that with the EDIT report function. But maybe there is a way?
Custom report for all ticket activity in a week.
I am running ServiceDesk Plus, version 8.0.0 Build 8021 with MYSQL. I have one custom field, "customer" I would like a report that will report all activity on a request for a given period. If I am able to run it as a scheduled report, I would run it weekly. The goal of the report is to compare activity in SD with my regular notes and improve my billing process. I don't know of a field that would indicate a request was "touched" or not, but I have been looking without success. The report should
report
Dear all There is a question that I have. In the report tab I want to report some data from those fields that I have created by my own in Service Catalog. but I cannot find Service Catalog additional fields in the report available columns. Where can I look for them and ho can I create a new report we those fields that I need to add in columns to report Any Idea? Regards Negin
Report of requests created through self-service portal
We want to track how many requests are being generated through the self-service portal over time to see how much users are creating their own tickets versus contacting the service desk. How can we do this? Is this a custom report?
Weekly Report
I am looking to create a report with the following average time to close incidents by week, by technician All reports seem to be day or month based
Abg Hours to Closed By Request TYpe
Need a report that will show average hours to close by Request type
Reporting Raw Data
I'm looking at producing a monthly reporting suite from our Helpdesk that I can pass to the business stakeholders and circulate internally within the department. The reports built into ServiceDesk Plus seem tp produce tabular data. Is there a way to also get to see the raw data, so I could bring that into Excel and write some customised pivot chart reports, to work alongside some of the inbuilt reports ? Is there a report to give me the raw data (ie. All fields for a given date range) or is it
Feature Requests
1. I'm looking for approval process for problem management.There are approval processes in incident / purchase / change management. But I cannot find the approval process for problem management. If it is not there, can you add this feature please? 2. On the report module, I want to see the which device (PC, server, projector, monitor, etc...) is getting most of service / IT request on it. How can I do it?
Monthy Report on Opten Tickets Over 90 Days
We are looking to generate a monthly report on the number of open tickets older than 90 days. I was able to generate a matrix report of tickets opened sorted by status over created date on a monthly basis using the Report Wizard, but we are just looking for an automatic report every month on the number of open tickets over 90 days old (as of the report time) sorted by current status. Thanks
report of acces to the system
How I can create a report that tells me which users have accessed the system in a date range such as a month?
Report to show tickets open or edited in the last 8 hours
Hi, Can someone help me create a report that will list all the tickets that have either been created, or last edited within the last 8 hours? The report creator only allows me to specify dates and I'm not terribly good with the query editor! Thanks!
Weekly report - Requests - Problems - Tasks
Hi, In Reports tab, I cannot find weekly report for Requests - Problems - Tasks. Someone, please help me "Query" for them above. Thanks, regards!
Report against archived request
We auto archive requests over a year old. I dont seem to be able to run/produce any data against archived reports. So for example If I run > report by all requests > requests by department > then select a time filter of 1/1/2011 to 31/12/2011 - it only reports on calls made after 11 july 2011 (i.e those not archived). If I run the same report against the first 6 months of 2011, or any period prior to archive data, it reports nothing. How can I run reports agianst archived calls ?
Where are service desk plus 8.0.0 Build 8009 conversations/messages stored in the database?
Could anyone say where the conversations/messages in service desk plus 8.0.0 build 8009 are stored in the database. I check the Conversation tables and found that only the messages that were sent using Microsoft Outlook are stored there. I also need the messages that are sent using Service Desk. I need these messages because I'm building a report that would return all conversations along with some additional information. Thanks for any help.
Request Technician, Fault Location, Group and Affected Person Table.
Can anyone say in which Table or Tables I can find the Technician, Fault Location, Group and Affected Person associated with a Request. I need these to display on a customized report. Thanks. SP
Next Page