Report with Date Parameters
I would like to use the following query, however, I would like to be able to pick up all open tickets based on a data parameter. Current Query: SELECT "sdo"."NAME" AS "Site", "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "cri"."FIRST_NAME" AS "Created By", "ti"."FIRST_NAME" AS "Technician", "wotodesc"."FULLDESCRIPTION" AS "Description", "sdo"."NAME" AS "Site", "std"."STATUSNAME" AS "Request Status", "wo"."CREATEDTIME" AS "Created Time"
All Open Tickets
Is there a report option that will allow me to run for ALL Tickets based on their STATUS, capturing the status of OPEN, CLOSED, ONHOLD? Thank you, I greatly appreciate it.
Crystal Report Availability
Is there a way to get a listing of tables and fields so that I can utilize Crystal Reports to build my own customer reports with my own set of parameters? Thank you.
Summary report showing strange dates
I have created a summary report of all tickets by technician. We have only had Servicedesk Plus since last December, 2016 but I get results showing data from December of 1969. Very strange. Any ideas on why that is occurring? I have attached what the output looks like. Here is the SQL query that the report generator created: SELECT ti.FIRST_NAME AS "Technician", ti.FIRST_NAME AS "Technician", longtodate(wo.RESOLVEDTIME) AS "Resolved Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
Query Script Required - Any help much apprechiated
Hi all, I need 2 scripts to run in the Query Reports which contains the following Colum's: All Users/requesters: Below are the types of data required for the extract, which are dependent on the risk level given to it: Risk ratings of 6 or 7 will require: First Name Surname Username (login name) Permission profile or access level (Tech Roles) Description of each profile or access level (Support Groups) Department Risk rating of 8 or 9 require the same as above, with additional: Full list of granular
List of incidents resulting from changes / Report of change related incidents / Incidents associated to change
Dear all I am looking for a report which shows me the numbers of incidents linked/associated to a Change. I have been searching this but couldn't find anything. Can you help me please? I know that you can Associate Incidents to a Change but how can you create a report about this? It would be very nice if the report could show the following attributes: - Change ID - Change Title - Incident ID (each Incident ID seperately in the case when several incidents were linked to one Change) - Incident Subject
How to verify if MS17-010 is installed on clients and servers
Hi, Update bulletin MS17-010 patches has been deployed to our clients and servers by WSUS, "KB4012216", "KB4012217", "KB4012218", "KB4012219", "KB4012220", "KB4012598", "KB4012606", "KB4013198", "KB4013429", "KB4015217", "KB4015219", "KB4015221", "KB4015549", "KB4015550", "KB4015551", "KB4015552", "KB4015553", "KB4015554", "KB4016635", "KB4016636", "KB4016637", "KB4019213", "KB4019214", "KB4019215", "KB4019216", "KB4019217", "KB4019218", "KB4019263", "KB4019264", "KB4019265", "KB4019472", "KB4019473",
Spam mail reports
Hi , Can i take report for spam filter ? I need to know how many spam mails are blocked by SDP spam filter. Regards
How do I view other tech's scheduled reports
We have standard reports that are sent weekly to departmental managers but only the tech who created the schedule can see it to make any changes.
Mac Address Search
Hello, I am trying to find a pc by Mac Address. I do a search in ServiceDesk and it won't search by Mac Address. Is there a report or a way within ServiceDesk to search by Mac Address?
Chat Feature Report
Is there a way to report on the chat feature to see how many times a particular requester utilizes the feature? Could you also provide the SQL for that report it would be greatly appreciated.
Report Script
Hi Everyone Please assist how do I get a script of a report that was created under reports tab. Please refer to the attached screenshot. Please assist. Regards, Delisile Mzila
Report to monitor call count in a queue over the week
I want to add a graph to show the calls open in a queue and how this changes over the week, preferably with Open and On-Hold calls amalgamated into the total count. Basically we want a call count of active calls at the end of each day so we have a visualisation to check if the queue is going up or down over the week, I can't work out how to achieve this though using the reporting function.
Do you know your incoming request velocity?
If there was an award for the most common help desk related questions asked, it would go to one of these- "Hey man, how many requests do we usually get on a daily basis?" "The helpdesk guys look very busy. Are we getting a lot of requests lately?" "There are so many unpicked requests in the queue. Do we need more people?" Ironically, this is the most probable answer you would get to all these questions - "Umm... I don't know.. I think so.. Let me find out" I can help you give a concrete answer using
How to Add custom fields Based on service catalog on a current report.
I have build a report using Create Report Wizard. I have copied the Query suing Show Query button. I would like to add to the report Custom Field based on Service Catalog. I have already found the Request Template ID, ColumnAlias and Service Definintion Number. I just want to add three filtered field from service catalog template (data alreade filed in a form). Thank you for you collaboration and support.
Report Security
Is there a way that I can display/allow access to specific reports/report folders to technicians. I have tested and for some reason the reports module is not that security driven. For Example. A Finance Technician can run reports for Infrastructure, although the setting for the role applied is "All in group & Assigned to Technician [Requests and Changes only]"
Query report all requests per technician.
Hi, I would like to generate the following report with all requests per technician. Almost same like query in topic* but then from all requests per technician in report. *) https://forums.manageengine.com/topic/query-report-i-need-monthly-report-request-status-per-technician Thank you very much for any reply on this topic. Best Regards, F. Jansen
Report assistance
Good Afternoon. Could I kindly ask on of the PostGre SQL Gods to assist with theis report? I's just like to edit it to reflect 'Current Month' instead of having to specify each time it is run. I'd like to turn it into a widget but makes no sense to edit all the time. Thanks in advance. Report Data is below. Jason SELECT ti.FIRST_NAME "Technician", qd.QUEUENAME "Group", count(wo.WORKORDERID) "Total Request", count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) "Completed Requests" , count(case
Need Help to create resolved ticket per site
Dear Support I have to make a SLA Resolved every month report base on site for Exp: Site Qty of Ticket SLA Resolved Site A 10 100.00% Site B 16 100.00% Site C 13 99.00% I have to make a SLA Respond every month report base on site for Exp: Site Qty of Ticket SLA Respond Site A 10 97.00% Site B 16 99.00% Site C 13
Account - Additional Fields
Hi, We have made use of the account addition filed and will need to report for it. (Using SQL) Can you please let me know which table stores this field? Thanks.
Interesting Report Creation Question (or at least its interesting to me)
I'm trying to figure out how to create the following report: Show all changes submitted or approved that take place on OR during a specific date (or date range) For example: There are a total of 10 PCCs in the entire system. The PCCs are scheduled for various start and stop dates/times. PCC Start End PCC 1 : Jan 1 Jan 7 PCC 2 : Jan 9 Jan 17 PCC 3 : Jan 1 Jan 23 PCC 4 : Jan 6 Jan 6 PCC 5 : Jan 12 Feb 02 PCC 6 : Jan 6 Jan 23 PCC 7 :
Query Report - Time from creation of ticket, to change of category
I'm trying to run a report that looks at the time it takes for us to 'pick up' an email request. When a new email comes in to our service desk, a ticket is automatically generated. The ticket is considered 'picked up' when our first line team amends it and adds the Category / SubCat / Item fields In the History of the ticket you can see the initial time it was created, and the time (and analyst) that applied them. Would it be possible to write a query report that shows: Created Date / Time Date
Collecting reports (Archived and non-archived)
Hi there! I am currently trying to see if I can collect reports of both Archived and Non-Archived tickets into one xls / csv file. At the moment I have one xls of all archived tickets for a specific date and then I have one xls for all non-archived tickets. I'm also terrible at Powershell. So it's been really hard trying to find a good enough script that's easy to learn for merging xls / csv together. Is there a way to lop both Archived and Non-Archived tickets all into one csv using the reports
Add notes field to existing Reports.
I would like to add the notes field to several reports that we currently have, but Notes (DiscussionNotes) is not an available choice. Is there a way to get that field added? Here is an example of the query for one of the reports: The DB is MS SqlServer SELECT "wo"."WORKORDERID" AS "Request ID", "rtdef"."NAME" AS "Request Type", "wo"."TITLE" AS "Subject", "wotodesc"."FULLDESCRIPTION" AS "Description", "wo"."COMPLETEDTIME" AS "Completed Time", "std"."STATUSNAME" AS "Request Status", "wof"."UDF_CHAR11"
Problem with Query Report - Java Exception
Hi When I copy the query by creating a custom report and then run it in the query editor i get the following error : java.lang.Exception: Only select queries can be executed - 'SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",wo.CREATEDTIME "Created Time",wos.LAST_TECH_UPDATE "Last Update Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE ((ti.FIRST_NAME
All complaints regarding a workstation
Hi Can I please get a query that shows all the requests that have been generated for a particular asset/workstation? For Example: PC-1265 Does not boot Heating up and so on ... Version :8.1.0 Build 8112 Thank You
Dahboard for level meduim high critical
Hi i'm looking to produce a dashboard so that it will display a dial showing that tickets are about to breach. I have one for all priorities and the moment, but would like specifically for those Thanks
Query Report filtered for Template Used
I have multiple templates that the service desk technicians use. One of the managers is asking if they can get a report but with only information from a specific template that the technicians use. The template that is being requested is named: Recon / Escalations Template Searching through the forums I was able to find a query that returned information on our custom fields that have been created for this template. The custom fields we are wanting to use are: aliasname: Agency Error tablename: WorkOrder_Multi_Fields
SQL Table Department Attributes
Hi, I am looking for a table that holds custom department attributes. Also is it possible to create a shared department attribute? Regards Mario
First response time violated issue
We are facing a problem that some of the requests created is showing first response time violated message. I know this depends on the SLA timings set. But my question is that what should I do in the request to avoid this problem. Actually there is no field in the template to enter the response time. Please help me. 8123 is the version.
Query assistance - Technician Support Groups
Hi Can I please get assistance in a query containing Technician, Support Groups and Reporting To fields. Thank you in advance
Status exceeding threshold - report
Hi all I am wanting to setup reports to flag tickets that have exceeded certain thresholds e.g. Any tickets with the status "Pending User Response" longer than 3 days. Unfortunately I cannot see a way to so this. What criteria would I use to set this up? For the time being, I have managed to get by (refer to attached) however I cannot automate this report as I need to stipulate a fixed date every time. Any suggestions are welcome. Many thanks, Graeme
Changing the Filter options in a custom report
I have a report that filters on selected "Requesters". How do I edit the filter list, without having to start over and select each requester again? Our requester list is very large (many thousands), and paging through the list to select requesters is very tedious. I need to periodically update the list with a few adds and deletes, but don't want to re-select each user every time the list changes. Is there a way to do this? Thank you very much. Jeff
How can analytics help you with continuous service improvement?
Continual service improvement (CSI) is at the crux of IT service management. CSI aims to continually improve the efficiency and the effectiveness of services, and processes. Broken down in simple English, CSI is comparing your current efficiency levels with your past performance and making sure you see an improvement. How can Analytics Plus help you do that? Let's say you want to find out areas that your technicians lack expertise. No matter how good your technicians are trained, there are going
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Hi guys, I've got this query that runs fine on the database, however, it doesn't run in the SD Reports module. The error I get is: java.lang.StringIndexOutOfBoundsException: String index out of range: -1 Here's the SQL: SELECT ownaaa.first_name AS 'Technician', chdt.changeid AS 'Change ID', ownaaa1.first_name AS 'Time Spent Technician', ownaaa.first_name AS 'Technician', chdt.title AS 'Title',
Report on all pending requests by age
Need help creating or modifying a report that will show all requests that are pending (Which are not closed or resolved) , sorted into these groups and this report will need to run every week: Percentage breakdown by age 90+, 89-60, 59-30, 29-15, 14-0.
SDP changes custom triggers！
How to change the field of custom triggers in SDP?
Weekend Reports
Is there any way to get a report made or run a current report that will allow me to pull up all tickets for the last 6 months for only weekends? Verision 9.3, Build 9309
SLA Definition Report
I am looking to create a report where I can get all the Defined SLA's with their respective filters and actions in to a report for audit purposes. Any Ideas? We use MSSQL and are on Build 9308 Regards
Workstation audit failed. Could not identify the cause
Dear sir, Yesterday I have upgraded 9.2(Build 9226) to 9.3(Build 9311) after that i am doing Manual pc scan some errors came.please check below. Error : Workstation audit failed. Could not identify the cause. please help. Thanks Viraj Potnis
Next Page