Customize report layout
Hi, I need to change report layout. The main color of our organization is green. I need to change the default lines and text in blue color to green color. Can you help me? Thanks SDP 9.1 MSSQL
How to get only date part from a date field
Hello, I have a report where I use the query bellow. What I need is that the date fields (wo.CREATEDTIME, wo.DUEBYTIME, etc) comes only with date format "dd/mm/yyyy" (in my case, in Brazil). How can I get this? SELECT ti.FIRST_NAME "Técnico",wos.ISOVERDUE "Status do vencimento",sdo.NAME "Local",wo.WORKORDERID "Identificação da solicitação",aau.FIRST_NAME "Solicitante",longtodate(wo.CREATEDTIME) "Hora de criação",longtodate(wo.DUEBYTIME) "Hora do vencimento",wo.TITLE "Assunto",longtodate(wos.LAST_TECH_UPDATE)
Service desk or Desktop central report showing daily server disk utilization.
Hi Manage Engine team I'm attempting to setup a report that will allow me a daily update on the usage of our Server Hdds. This report would need to highlight servers utilizing more than 90% of any of their disks. Cheers Joel
Time spent for group on the same Request ID
Hi, I need a report with the time spent for group in the same Request ID. For example: On Request ID #2 for 30 minutes the Level 1 group was the responsible for this request, but at minute 31 the level 1 group assign Request ID #2 to Level 2 group. So.. i need a report like below Requet ID | Subject | Time Spent - Group 1 | Time Spent Group 2 Thanks SDP 9.1 MSSQL
Looking for the join between Projects and Associated request tickets
I am trying to create a report that groups by project and show all associated tickets ? Do you have a query for this ?
Operational Hours
Hi People. I need some help: I have multiple incidents and it,s have a time registered , but , no disciminate if that hours are in operational hours range. If posible to make a report what shows non-operational hours summary? I Hope be clear. Many tanks.
Report of Merged Tickets
Hi, Please provide us a query to pull out the report of merged tickets. Thanks & Regards Silsha
Reporting hours with Charts
I have 2 questions in regards to reporting: 1) When I use the reports that are out of the box, I attempt to use the Report for hours for technicians and it will show the "time spent" for each technician. However, I am not able to show the "time spent" in the graph. Is there a way to get the "time spent" to be the attribute for my X axis on the chart? 2) How can I query the requests and projects modules to show the true total technician hours? Thank you SDP: 9.1 Build 9103, DB: PostgreSQL
Pending status under matrix report
Hi we are getting pending status under matrix report on the below given format how can i create a report with heading instead of false is open and true is completed. Thanks Anoop PS Mob - 9995822232
Need a report to detail which computers/workstations a specific software title is installed on
How would i create this. I am new to sql queries.
Need report like this
TechName Total incidents Count Closed Within the day Closed Within 2 days Closed Within 3 days Closed More than 3 days Pending TechName Total Service Request Count Closed Within the day Closed Within 2 days Closed Within 3 days Closed More than 3 days Pending TechName Total Change Request Count Closed Within the day Closed Within 2 days Closed Within 3 days Closed More than 3 days Pending
SQL query required to show list of OU's selected for an Active Directory import
We have a large number of OU's for lots of sites, and therefore lots of sub OU's where the users are held so the list is enumerated over serveral pages in ServiceDesk. We are rolling out ServiceDeskPlus to individual sites over a 3-6month period. Therefore when my initial AD import settings will be changing, which means I NEED to know is what OU's had been selected previously. Currently it only shows the Last selected. The ideal solution would be to store the import settings by date so that we
Reports location
Dears I need some information of where is de location in DB for the customs reports. I need migrate some and can`t fin in any place. Can helpme?
Request Status Report
Hi , Would you be able to assist with a MSSQL report: Need to see the time taken to move between all request statuses per ticket. Eg: Requestid Sla Priorty Created Date RequestStatus1 Time spent in status RequestStatus2 Time spent in status RequestStatus3 Time spent in status 23088 Priority 1 3 Low 2015/08/09 12:52 Open 5Days : 45 min Pending Service Provider 6Day : 63 min Pending Service Provider 7Days : 12 min Thanks
Tech Assignment query
HI this was created a while back for me but i need the report to have the following: Category,Sub category & items also support team SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",std.STATUSNAME "Request Status",wo.TITLE "Subject",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",pd.PRIORITYNAME "Priority" ,woh.OPERATION,LONGTODATE(wo.CREATEDTIME) CREATEDTIME,LONGTODATE(wo.DUEBYTIME) DUEBYTIME,LONGTODATE(wo.COMPLETEDTIME)COMPLETEDTIME,aau1.FIRST_NAME
need Quick Report
I need a quick report of tickets per technician with - Opened and closed by only Customer Support Group members - SLA violations (yes/no) - Escalated (yes/no) - not assigned to any other groups - this year only Build 9103 Database : MsSql
REPORT NEEDED - Summery report by template type
We are looking to have a report made that shows us how many times a template was used in a month. I.E. - Jan Feb Mar Default Template - 3 7 4 Account Template - 5 7 9 I would like it to be a 2015. We are using MSSQL. Thanks.
Reporting specifically around SDP Technicians
I'd like a host of reporting strictly around SDP technicians. Ex. Technician List; Creation date/time, deletion date/time, modification date/time. List of Technicians with certain roles. List of technicians with change rights List of technicians who are project admins. etc. Thanks, Adam
Is summary row in a Query Report possible?
I have a Query Report that gives statistics by technician. Is there a way to add a summary line at the bottom, like this: Task Hours Request Hours Total Hours Response SLA Met % Resolution SLA Met % Number of Requests Last Resolved Last Week Cher 1 11 12 77 77 13 Sting 16 5 21 90 95 20 Teller 1 8 10 75 88 32 SUMMARY 18 24 43 79 87 65 I'm using MSSQL. I think I could use a UNION (with a name such that is it sorted to the bottom) but is there a better way? Thanks, Tom.
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
Hi, This report works in SQL on the server, but not in the report query editor. Can you let me know why I keep getting the message above? "java.lang.StringIndexOutOfBoundsException: String index out of range: -1" SELECT qd.QUEUENAME "Group",wo.WORKORDERID "Request ID",mdd.MODENAME "Request Mode",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department", Convert(varchar(10),CONVERT(date,(dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((wo.createdtime)/1000),'1970-01-01
Report with Dates but not Hourly TimeStamps
Hi, I'm looking to create reports with the date stamps, but no timestamps, or to at least hide the timestamps in the reports. Putting them in a separate column would work as well. We are using SQL Server. Here is my current report query, but I'm not sure where to edit this to display only the dates. SELECT wos.ISOVERDUE "Overdue Status",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",ti.FIRST_NAME "Technician",qd.QUEUENAME "Group",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",wo.TITLE
violations
Dear Suppoer we are looking report to show us "SLA violations (yes/no)" can you Please hep us out
Performance Reports
Hello, I have to produce two simple reports multiple times a day and at the moment I need to run a number of reports to be able to produce this. Could you please provide a New Query Report sql script that will show the below details. I would also need to be able select amend the script easily to show either a date range, or Today; Yesterday; thisweek etc. To clarify Resolved should include: Report 1 - By Technician Agent Open Events # Open out of SLA # Logged # Total Resolved # Resolved in SLA
Exporting a list of all techs, categories, groups etc
Hi, I am fairly new to Manage Engine but need to be able to export to CSV a list of all our techs/categories/sub-categories, groups etc, I have had a look through the forums but couldn't find anything so apologies if it has been asked already, I presume it is done by query but if someone could show me an example, I am using: Your Version : 9.0 Build 9035 Thanks Ross
Conversations for all open tickets.
I have this report which shows me the conversations for tickets within a time frame. What modification would I need to do in order to get the report for all open tickets? Thanks. SELECT workorder.WORKORDERID "Request ID" , workorder.TITLE "SUBJECT" , longtodate(conversation.CREATEDTIME) "Conversation TIME" , conversation.TITLE "Reply SUBJECT" , conversationdescription.DESCRIPTION "Reply" , aaauser.FIRST_NAME "Replied requester" FROM conversation LEFT JOIN workorder ON (conversation.WORKORDERID
Query for Requests including notes for a few specified departments
Hi Im looking to manipulate the below query to allow us to run a report that will show tickets w/ notes belonging to technicians of specified groups. SELECT wo.WORKORDERID 'Request ID',wo.TITLE 'Subject',aau.FIRST_NAME 'Requester',ti.FIRST_NAME 'Technician',qd.QUEUENAME 'Group',rtdef.NAME 'Request Type',std.STATUSNAME 'Request Status',DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000),'%d-%m-%Y %k:%i') 'Created Time',ns.notestext'Notes',DATE_FORMAT(FROM_UNIXTIME(ns.NOTESDATE/1000),'%d-%m-%Y %k:%i') 'Last
Report on requests from last month by Priority in procent
How can I create a report from all requests created last month and see percentage closed within priorities SLA's divided in day, week and month?
SLA Report
HI i am looking for a report/query which will show me the following info, First response sla fail (true value) with who the first technician was(initial assignment) and support team(group) query needs date parameters and category,sub category,item,as well so that i can easily breakdown in excel. Using SDP 9.2 and mysql. Thanks
Report with OPERATION: CLOSE Performed by ........????
Good morning, I would like to include in a report who closed the Requests. At the end of the request history, at OPERATION: CLOSE Performed by ........ we can find if the a request was closed by System Requester or A specific technician I can’t find the table-field to include this data in a report. Could you help me. Rdgs, Arantza
All open tickets with notes fields
Good afternoon. I have the query below which works great. It shows all open tickets that have notes. I am trying to modify this report to show all open tickets, whether or not they have notes, but want to retain the note-related fields. Any help would be appreciated. SELECT wo.WORKORDERID 'Request ID',wo.TITLE 'Subject',aau.FIRST_NAME 'Requester',ti.FIRST_NAME 'Technician',qd.QUEUENAME 'Group',rtdef.NAME 'Request Type',std.STATUSNAME 'Request Status',DATE_FORMAT(FROM_UNIXTIME(wo.CREATEDTIME/1000),'%d-%m-%Y
Push Notifications IOS
Hi, I am running the latest version of the service desk plus app and the latest version of service desk plus. However i don't receive push notifications. If I go into the app then i will get see the 1 comes up or however many jobs i have but i dont get an alert. Can you please tell me why this is? its all set up on my phone and on my helpdesk but dont get anything unless i go into the app. Thanks, Ryan
Request does not fall under your permitted scope.
here is the scenario. 1. Ticket is Assigned to Technician1 2. 1 task is assigned to Technican2 3. Role is Set as Assigned to him[Requests and Changes only] Now the issue is technician2 cannot open the ticket. with below error. "Request does not fall under your permitted scope. So you are not authorized to update the same." However if a change the role of technician to "All in group & assigned to him[Requests and Changes only." Technician2 will be able to view the ticket, However I don't want all
CSV export - dates are in general format
Hi team, When exporting a report to a CSV or Excel file, any date field comes through as general text and not as an Excel date. Is there a way to ensure a spreadsheet export contains dates in date format?
Report showing the incident backlog for specific group
Hello team, i will really appreciate some help with generating report which shows the backlog of open incidents on specific date in the past. As example the info i need will be something like: the number of open incidents we had on 12.07.2015 for specific Group. Its a bit urgent and any help will be much appreciated!
Overdue Violations
Hi, Trying to understand how the 'Overdue' violations are reported. We have two main SLAs we report on; 1 - First Response 2 - Resolved On Time If the call is with Technician 1, and the first response SLA is missed, it records in the call history. Say the call is passed to Technician 2 after the first response SLA is missed and technician 2 closes the request, then on the report we run monthly, shows the violation against Technician 2, which is incorrect as the violation occurs when the call is with
Amend ownership of scheduled reports
When I create scheduled reports, other administrators are not able to see them, edit them or stop them. This is a pain for clients for whom I have set up scheduled reports and their requirements change over time as they mature. Am I missing something? James Gander Gander Service Management IT Operations and Service Management Consultancy
Need help on a report for tracking asset receipts
Good Morning, Our internal Audit team has asked for a report that does the following: "A report should be developed showing assets received and the names of the Technicians receiving those assets" We are currently on SDP v 9.0_9039 using MSSQL. Any help is appreciated.
Still getting duplicate users / requesters
HI everyone, After updating to 8002, we are still getting new requesters duplicated when a ticket comes in. Each time we delete a duplicate requester, when the user submits another ticket, it just creates a new one with no login and no domain or any other information. The original requester is still there too. I also noticed service desk keeps picking up our domain name as a new domain. We've always had it setup as its' netbios name, "domain1". The full name being "domain.com". That one is still
Ticket report
Dear All, how can i get below report Avarege ticket open time per techincation? Technication effort time? thank you
How to report on Changes affecting Service Categories
How can we show all changes that pertain to a specific service? We don't see the option to filter by Service Category (or services affected). We actually have a CAB meeting. How can we show all items that are to be reviewed by a CAB? Thanks, Adam
Next Page