Reporting on Multi-Select Fields from SQL
If I have an Additional field that is a multi-select; what is the proper syntax to report on it from SQL? If you can show me an example using additional field UDF_CHAR39 I'd appreciate it
Re-order Reports folders
Hi - recently a new folder has appeared at the top of our reports folders - Reports on Projects. As we don't use the projects feature, could we send that folder to the bottom of the list?
Report Required for Technician
Can I have the following report please: I have a technician 'Hardware' If a request/complaint is made against suppose, workstation 'PC-2013' and assigned to 'Hardware' I want a report that shows all requests of this workstation that have been assigned to 'Hardware' ONLY. If possible I would also like the number of days between the requests. Example PC does not Boot 11/2/2016 RAM damaged 12/2/2016 30 ( days after the previous complaint) The day count is secondary. But the remaining details such
Not being able to generate reports when adding to the field "Value"
Dear all, We were unable to generate reports using the criteria suggested by the application, so we tried many others possibilities and still didnt get any result. The values we tried were None, "None", Null, "Null" without success. Can you help us get around this issue? Thanks in advance. Regards.
Asset duplicate entries
Dear Team, We are using MESD plus Version 9.2 (Build 9232). Whenever we are pulling asset report from SD. We are getting more systems as duplicate entry (Like: 123XXX_old.abc.in, 123XXX_old_1.abc.in, 123XXX_old_2.abc.in). Because of duplicate entry we cannot able to provide exact count of assets (In Use, In Store). How we can fix the duplicate entry from our SD. Also we are using latest Asset Explorer Agent to all client systems.
Aoftware asset report
I am trying to create a report of software scanned by the probe by workstation, is this possible in a single list form
SLA Porcentage column
I need a report that shows the percentage of SLA compliance per technician, that is, if I have 100 tickets and 30 we have not complied with the SLA will be 70% compliance and 30% non-compliance.
Failed Scan - > 90 days
Is it possible to run a report that will show any Workstations that have not been successfully scanned for a period of time? For example, I have the system showing me I have say 500 failed scans,is it possible to show which have not been scanned successfully for say 90 days, 30 days etc.? I'm trying to clean up my Assets.
Last Updated Issue
Hi , We were running a report where we would report on Last updated time. I understand that it would show the last time when a note was added to the ticket. However now we are encouraging the technicians to add worklogs as they track the time for the techs. But now the Last updated report does not show the true picture of the last update of tickets. Is there a fix for this? Below is the current query: SELECT ti.FIRST_NAME AS "Technician", wos.LAST_TECH_UPDATE AS "Last Update Time", wo.CREATEDTIME
Problems with technician email responses
Hello there. I have this scenario: We have only one email address configured at ServiceDesk Plus for all our technicians. Sometimes occurs when "Technician 1" sends a reply from a customer's message ("customer 1") which belongs to Request ID "X"; this reply is sent to another customer (not "Customer 1"), in another Request ID (not request ID "X"). This is a new situation, and we haven´t had another similar case but since a week ago. This scenario has been given at least 4 times more, with different
Query Report to export all details in Request Catalog templates.
Hi Team, Please help us to generate a query report to export the names of all the Request Catalog template along with the Category, Sub-Category, Group, Priority, Site, Level for each of the templates. Application details below: Database Name = MySQL@ @Database Version = 5.1.50-enterprise-commercial-pro-log@ @Current Build = 9224@ Thanks Ratul
Technician Activity Report
Hi All I would like to run a report per Technician to see what they have done whilst that have been logged into SD+ We are currently using SD Plus - 9.2 Build 9227 I can get reports on tickets closed and logged, but I need the detail relating to the actual activity while the technician is logged on, some of these activities could be - adding notes, replying on tickets, re-assigning tickets to others, etc. Main reason for this is that we have a number of remote Technicians and I need to ascertain
Help with report query
Hello, I'm trying to find a canned report from SDP but I am not able to find the report that I need. I'm looking for a report that will list ALL workstations (non server) and also list RAM, CPU (cores), and HDD. Can someone help me out? thanks!
Report Field Definitions
Is there a list some where that examples all the fields and how some are calculated for the report fields? Example is time elapsed, is this total time including weekends or just week days? Thanks
Query Report for Purchase order detail
I am running ServiceDesk 7.508, with a MSSQL backend. Is there a query that can be run that reports back the PO number, date ordered, po title, and Remarks section. It is really the remarks section that I cannot get to work.
My SQL Query Report
Hi, I'm trying to create a query report to display: Request ID Request Status Requester Dept Subject Technician Description Created Time Notes (All Notes if possible, if not latest) I've managed to find a report searching the forum, which works for the Notes field but I'm struggling to add all the fields I require. SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Support Rep",wo.TITLE "Subject",note.notestext "Notes" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
Need to Know if we could track the most commonly used Incident / Resolution / Reply Templates
Need to Know if we could track the most commonly used Incident / Resolution / Reply Templates As this would give us an insight on How efficiently we use our Service Desk and also we could look into other ways of enhancing our performance.
Can't get reports about custom fields
Hello, I have a problem to get reports about custom fields I have created under a specific service category. The report says that the fields are empty, but they aren't. When I create the same custom fields under the "Common fields" category everything works fine. Is that a bug? (We use the latest version of SDP.) Thanks for your help!
Reports
Hello, Do you have a query that I can run a report to export all open and on hold ticket and include all the conversation emails as well as attachments?
SDP closed request performance trend report on Zoho Reports
Has anyone been successful at creating a TREND report in Zoho Reports to display trend reports for closed request within a time period? The Trend reports I have been able to setup are not true reflection of the of the trend. They calculate percentages on the value DISPLAYED on the report and not on the total request count. Support has been unable to provide a solution to this. Has anyone else had any luck with this?
Assets Deployed Last Month
I am looking for a query that will display all assets deployed last month. The current one I have seems to be broken. I get the following error java.sql.SQLException: Invalid column name 'Barcode'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628) at net.sourceforge.jtds.jdbc.MSCursorResultSet.processOutput(MSCursorResultSet.java:933)
How to add PO to this report
Hello, I have a report but I would like to insert the PO number in on the second column. Would anyone be able to help? SELECT productType.COMPONENTTYPENAME "Product Type",res.RESOURCENAME,resources.SERIALNO "Serial Number",longtodate(res.ACQUISITIONDATE) "Acquisition Date",longtodate(ResourceStateHistory.STARTTIME) "Changed Date",aaa.FIRST_NAME "Changed By",rstate.DISPLAYSTATE "Previous State",ResourceState.DISPLAYSTATE "Current State",AaaUser.FIRST_NAME "Assigned User",DepartmentDefinition.DEPTNAME
How to verify if a record exists
Dear team, Just wanted to create a custom report. Let say I have 5 records supposed already logged: 101, 102, 103, 104, 105 And I want to know if they are still in the database (of course this is just an example because I have hundreds of records that I need to check) SELECT wo.workorderid, wo.title from workorder wo where wo.workorderid = 101 or wo.workorderid = 102 or wo.workorderid = 103 or wo.workorderid = 104 or wo.workorderid = 105 and I want to have something like below in return workorderid
Не запускается
Добрый день, скачал с сайта последнюю версию программы ManageEngine_ServiceDesk_Plus_64bit.exe, установка прошла успешно, при запуске весит окно запуска сервиса и больше ничего не происходит. e-mail: zverev@bmp-spb.ru
Purchase Order Report
Is it possible to pull a report of Approved Purchased orders based on who approved them?
Get Requestor Passwords- Query Report
How do I get a list of requestors along with their passwords? I have imported the requestors from Active Directory. I would like a query report to show the details along with the passwords. Is this possible ?
manage engine
Hello good time. I want to take a Report of manage engine different levels spend the time that I get to solve their problem . database is mysql I want to take such a task to solve worklog reports how much time it will take at different stages
SLA report percentage
Hi there I'm looking to run a report based on SLA's reached and breached. My Service Desk setup has 4 Priority groups P1, P2, P3, P4) and I would like to know out of all the P1 calls, how many (in percentage terms) have been completed and how many have not. As well for the other 3 priority status' mentioned. I would like to run the same report but for different time frames (such as "calls in the last month, year, week etc.) I have taken a look at the other posts on this forum and they are all grouped
Extracting Statistical Reports from SDP
Hello Everyone, I need some help in creating meaningfull and statistical reports from ManageEngine ServiceDesk Plus - MSP 9.0 Build 9004 (Database: mssql) I need to be able to create reports for the following: 1- Response and Completion time of the ticket per Support Group and technician (monthly and another one quarterly) in % For example I want to see a table that shows each technician response and ticket along with the completion time of the ticket VS its SLA time I also want to see a summary
Report Remote Computer TimeZone
Hi, How can I do remote computer TimeZone Report?
Software report
It's been a while, but I though I could run a tabular report that would was grouped by software and listed what workstations had it installed. I can't find one. Anyone know a query to run this? Thanks Chuck
Report to show assets not correctly assigned
Hi, would like to create a report to show where assigned assets do not match the last logged in user, is this possible? We manually assign assets (laptops) when issued to staff but sometimes the asset is not correctly updated by our technicians and so we need to flag these up for remedial.
Average Time between Technician Assigned and first response
Hi, Is it possible to have a report that shows the average time between a request being assigned to a technician and the first response time by that technician for each week. We are are using the PGSQL database. Thank you in advance, George
CREATEDTIME
Hi. I'm from Russia. Sorry for my English There is a standard query that shows outstanding requests for the current day: VICEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID WHERE (((((serdef.NAME = N'КХ НСИ' COLLATE Cyrillic_General_CI_AS) AND ((std.STATUSNAME = N'Открыто' COLLATE Cyrillic_General_CI_AS)
Scheduled Reports | HELP!
Hey All, I am looking for a way to view and disable all scheduled reports administratively. Is there a way to do this from the website? Or does it have to be done via DB Querey. If it is Query, what is it? We are running 9.2 9226. Thanks! Jeff Day
Help to change SLA violated query
How I change this code, to add date (week or month)? SELECT ti.FIRST_NAME "Technician", count(wo.WORKORDERID) "Total Request",count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) "Completed Requests" , count(case when (std.ISPENDING='0' AND wos.ISOVERDUE='1') THEN 1 ELSE NULL END) "SLA violated", count(case when (std.ISPENDING='0' AND wos.ISOVERDUE='0') THEN 1 ELSE NULL END) "SLA not violated" ,case when count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) =0 THEN NULL ELSE count(case when
Projects Schedule end date format
Hello, How can I: 1. Format the "Schedule end" date to show as MM/DD/YY 2. Order records by "Schedule end" date (Newest to Oldest) 3. Group records by "Project Title" 2. Add a link to "Request ID" to allow direct access to that incident from that report We use Service Desk Plus Build 9111 / MS SQL DB The current query for this report is: SELECT projectdet.TITLE "Project Title", longtodate(projectdet.SCHEDULEDENDTIME) "Schedule end", wo.WORKORDERID "Request ID", wo.TITLE "Subject", aau.FIRST_NAME
SLA Report with Time between raise and approval
Hi all, I need a report with the following info for a specific service request: - all the people involved: - requester - approver - technician - SLA involved - time between raise and approval - time between approval and assigning - time between assigning and resolved state Is this possible? ServiceDesk 8217 MSSQL Regards.
Service Request additional fields in reports, is it available?
I've created additional fields in both Incidents and in Service Catalog. When I create a custom report, and filter on Incidents, I can see the Incident additional fields. When I filter on Service Requests, the Service Catalog additional fields do not display. How can I display the Service Catalog additional fields in Reports? Or am I going to have to only use Incidents for Service Request functionality if I need to depend on additional fields?
the ME SDP integration with advanced analytics does it really work?
i have been trying making work for days, logged ticket with ME Support, but they couldn't figure it out either!!! is ther any one who did realy make it work, kindly share your experience and your feedback regarding the reports from advanced analytics? is it worth it ... for the record i tried the advanced analytics on premises, works fine however the generation reports, dashboard, ... are meaningless. well at least in my organization!
Next Page