How can I see items that I've approved?
Is there a way to see all items that I've approved in the past? Here's my business case: Homer Simpson is set up as an Approver in our system. He can see items that are awaiting his approval, but we can't find a way for Homer to view things that he has already approved. The custom view builder and custom report builder allows us to filter based upon Approval Status, so we could see items where the status is Approved, however, Homer can't set a view to show requests where Approval Status is Approved
Error in Form Rules Creation Criteria
The first time I tried to create a custom form action it allowed me to select all users, but now trying to create any rules, it only allows it to apply to technicians, as shown in attached picture.
Modifying Sub reports
There is a sub report called "Workstation Add Fields". I see this includes 1 field that I have added, but not others. How do I edit the fields included in this report? Thanks Chuck
Creating a helpdesk timeline
I grew up watching this popular show, CSI: Crime Scene Investigation. I was fascinated by the entire process of solving a crime, from the time detectives first arrive on the scene of the crime, to identifying the criminal. One of the first things that detectives do in order to solve a case is, establish a timeline. A timeline of events that lead up to the crime. Establishing a timeline is so important because it helps them identify possible suspects and reasons that culminated to the crime. A timeline
How do I create an Average Response time report in ServiceDesk Plus?
I want to run a report that shows: All tickets created within a given date range for a certain support group. I also want to show the response time to each ticket and then average response time for each agent as well as the group as a whole. Can someone assist with the steps to create a report like that? Best Regards, Brian Mansfield
Modify Query
SELECT (SoftwareList.SOFTWARENAME) "Software_Name", MAX(aaov.NAME) "Site", MAX(SystemInfo.WORKSTATIONNAME) "Workstation" FROM SoftwareInfo LEFT JOIN SoftwareList ON SoftwareInfo.SOFTWAREID=SoftwareList.SOFTWAREID LEFT JOIN SoftwareType ON SoftwareList.SOFTWARETYPEID=SoftwareType.SOFTWARETYPEID LEFT JOIN Systeminfo ON SoftwareInfo.WORKSTATIONID=SystemInfo.WORKSTATIONID LEFT JOIN Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
Last successful scan report
Hi, Is it possible you could generate a query in MS SQL format for me, so I can produce a report? 'Resource Name' and 'Last successful scan of a workstation report within the last 90 days'. ServiceDesk 7.6.0 Build 7602 Thanks Mark.
query report for all scheduled reports
I am reporting this as a problem, because the query report is a workaround only. We were informed that the SDP admin cannot see all scheduled reports in the user interface by design. This is very bad situation, when SDP admin don;t have any control on scheduled reports e.g. by technicians who are no longer working. Please create query reports which can provide the below information across ALL scheduled in SDP reports: Report name \ Next Scheduled Date \ Recipients \ Techncian Name (owner)
Preventive Maintenance
Hi, Does anyone have a Report Query that can export all the details of the Preventive Maintenance, especially the schedule details ? We have this, but just need to see if we can add - well, everything else..... Select top 50000 swo.WORKORDERID "Scheduled WOID", ti.SCHEDULE_TIME "Next Schedule Time", aau.FIRST_NAME "Requester",sdo.NAME "Site",dpt.DEPTNAME "Department",cd.CATEGORYNAME "Category",scd.NAME "Subcategory",icd.NAME "Item",res.RESOURCENAME "Asset",qd.QUEUENAME "Group",ati.FIRST_NAME "Technician",swo.TITLE
Create query report to reference custom fields
I want to create a query report to reference the custom fields. How do I do that? My main goal is to create a very detailed report on all our machines, including IP address, host name, and several of the custom fields. Any help would be appreciated.
SDP admin is unable to view all scheduled reports created by various technicians
Guys, this is confusing that the SDP admin cannot see all scheduled reports regardless who has created them. It is causing various system maintanance issues, SDP admin cannot delete or change those reports if e.g. they are targeted to wrong recipients. Please work on this ASAP. /Mar
Timespent for Archived Requests
Hi, I would like to understand how to generate a report for time-spent on archived requests. Do we have it on the system or is query an option? Thanks!
Where are the additional fields ?!?!
I'm trying to create a new report using queries but Iam stuck ... in which table the servicedesk store the additional fields informations ?? I found one table. ServiceCatalog_Fields but I only got the weird names such as GUDF_CHAR16 !!! How the servicedesk knows that GUDF_CHAR16 is the additional field X or Y ?????
Form Templates?
Hey everyone, My hospital is in the process of switching over to ManageEngine and I had a quick question. I am working on setting up the incident templates. What I am wondering is if there is a way to set the templates to be in a form instead of being sent through email? Basically we want a way of tracking them and creating reports if possible. This may be a weird question but I want to see if it's even possible to create these types of forms or not? Any help would be greatly appreciated as they
Custom service catalogue field through to report
Hi There, I have created a new custom field named 'substatus' (UDF_CHAR3) which I need to add to an existing report. How do I go about this? Rhian
The problem of safety of SD
We have 9.1 9107 of August 31, 2015 The possibility for an unauthorized user (even without a login and password) to have access to any server file by a specific link. You can download the log file of the operation of the CD, and there is a possibility to download any file from the server. Has this problem resolved in new versions? If there is an opportunity to say, in which version. Thank you in advance.
Report
Hi, I need help. I have 3 lines of support. I need to make a report on how many requests processed the first line of support. There are applications that close the first line. But the report on closed applications does not suit me, I need to understand how many applications I received on the first line, how many they processed and transferred to the next support line. Is it possible to make such a report? MSSQL 2008r2.
Can we print label for IT Inventory
Dear Experts, We need to print label, discription of label are (a)PC or Laptop with model code (b)Serivce Tag #...... (c) Location (d) Department (e)IP (f) Monitor (g) Printer (h) Bar Code (i) Inventory Year 2017 - 2018 - 2019 - 2020 - 2021 Can we generate these type of label from Manage Engine?
Report - Measuring First Call Resolution
I'm looking for a report that can measure FCR. Anyone have any ideas? I don't see a canned report. Thanks!
QUERY Request: Actual time spent by technician
Hi there, I'm quite new to SQL and I'm trying to find a query that would show the actual time spent by the technician. So far, the queries that I've found online only shows the actual time spent of the group (or time elapsed) and not the actual work of the technician themselves. ME SDP: Version 9.3 Build: 9307 Database: MSSQL Version: 11.0.3153.0
Need help with Custom Report
Hello all, I am having an issue when creating a new Custom Report. I have read through the forums before submitting, and found several posts that were similar, but I was unable to find any posts that matched what I needed exactly. I would like to create a scheduled report that automatically emails out with the following: All requests from the Current Month and Previous Month. The Current Month would be calculated from the current system date/time. Report would be a Tabular Report, with the following
Batch Reports
I would like to run a query which generate batch report of each department from mentioned dates, so instead of running each department's report, it should automatically generate and send in .zip file , if its possible !
New Query Report
Hi, I have created a new query report to extract all users information and create a phonebook. I have added 2 'User Additional Fields', one called 'Extension' and the other one called 'Status'. I have the following query already: SELECT aa.FIRST_NAME "FullName", dept.DEPTNAME "Department",sdorg.NAME "Site",aacontact.LANDLINE "Phone",sd.JOBTITLE "JobTitle",aacontact.MOBILE "Mobile" FROM AaaUser aa LEFT JOIN UserDepartment userdept ON aa.USER_ID=userdept.USERID LEFT JOIN AAAUserContactInfo aausercontact
Computer with client doesn't connect to a server
Good Day! I have a pre-installed ManageEngine client on a computer. But, when I make scan using IP-address, or DNS-name, I get next error (see a log-file in attachment). I need Your expert help. Best regards, Mikhail Vinnik
Export reports with usable dates
How can I export a report from Service Desk with usable dates? Currently, if I export the report either via XLS or CSV, the date is not in a date format that is readable by Excel, so I can't do any calculations or graphs based on the data. This is quite frustrating as I need to combine data from different platforms for reporting purposes.
Manufacturer by device by Site report
Need to create a report for a specific Manufacturer on each device by site e.g. Changeable criteria Manufacturer sorted by Site "Site" Software Workstation Hospital "McAfee agent" "asset name1" "McAfee agent" "asset name2" "McAfee agent" "asset name4" Clinic
Aged Calls per Technician and Unassigned
Dear All, Please how can I amend the MS SQL query below to include: WorkOrder ID Created Time and have the ability to generate the report on a monthly basis SELECT AAAUSER.FIRST_NAME,COUNT(WORKORDER.WORKORDERID) 'Inbound',COUNT(CASE when DATEDIFF(day, DATEADD(s, WORKORDER.CREATEDTIME/1000, '01-03-2017 00:00:00'), getDate()) <= 10 and DATEDIFF(day, DATEADD(s, WORKORDER.CREATEDTIME/1000, '01-03-2017 00:00:00'), getDate()) > 5 THEN 1 ELSE NULL END) '5 - 10 Days', COUNT(CASE when DATEDIFF(day, DATEADD(s,
Duplicate Users Report Not Working
I'm currently look at our existing reports and we have a report that works in SDP 9218 but does not work with SDP 9302. MSSQL select * from vw_rpt_DuplicateUsers order by FIRST_NAME
Report to calucalte average resoltion time
Hi all, im looking to build a report that shows the average time for resolving a ticket is this possible Thanks Database postgres Your Version : 9.3 Build 9304 Latest Version : 9.3 Build 9306 [Details]
Error report day off
Hi everyone! I tried all reports from https://forums.manageengine.com/topic/off-hours-report All of them is incorrect. I try to make little report, to understand how work "EXTRACT(hour FROM to_timestamp(createdtime/1000)::TIMESTAMP with time zone)" and i get some results: report: select longtodate(workorder.createdtime), workorderid, EXTRACT(hour FROM to_timestamp(createdtime/1000)::TIMESTAMP with time zone) as "HOUR" from workorder where createdtime >= <from_thisquarter> and createdtime <= <to_thisquarter>
Add Service Catalog custom fields to custom report
I need to add a field called "Partner Case Number" in service catalog catagory named "client support" to available columns when creating custom reports. Using SDP 8.8008 MS SQL backend Custom Query for custom report build to include this in: SELECT icd.NAME "Item",wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",icd.NAME "Item",wo.TITLE "Subject",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.COMPLETEDTIME) "Completed Time" FROM WorkOrder wo LEFT JOIN
tecnician assignment report
I need to run a report that shows when I technician reassigns a ticket and to who?
Cant add/attach multiple files in service portal
Cant add/attach multiple files in service portal
Access your favourite Analytics Plus dashboards from within Service Desk Plus's console
'If Analytics Plus is integrated with ServiceDesk Plus(SDP), can the dashboard view in SDP include the dashboards created in Analytics Plus? ' Yes, now you can. From ServiceDesk Plus version 9300 onwards, there is a provision to customize dashboards, that have been already created in Analytics Plus. By simply adding the URL of your Analytics Plus dashboard or report you can view it on ServiceDesk Plus's visual interface. So, what are the benefits of this feature? Analytics Plus gives you
Name of the e-mail table
Good Lords I need to know what is the name of the table in which the emails of registered clients are stored. I would greatly appreciate it. Greetings.
Reporte Personalizado
Estimados buen día a todos, Estamos requiriendo realizar un reporte personalizado donde se pueda obtener la información detallada de los tiempos invertidos y agruparlos por Grupos y por Técnicos, esto con mayor énfasis en los tiempos vencidos (SLA Vencidos) En el historial del Ticket se observa la gráfica donde se detalla esta información, esta información es la que necesitamos, ideal si fuera en modo gráfico o en modo matricial. (Adjunto captura de pantalla) Agradezco de antemano sus aportes. Saludos,
Ticket open calls report.
Hi, I want to make custom report which is having unassigned technician having all request type excluding request types(Projects, Changes &Activities).
Report - Time Elapsed Analysis
Hi, How to create a report for the information : Time Elapsed Analysis - Status, Group and Technicians Displays elapsed time expert at the request passed through it.
Report conversations for archived requests
Hello, I am working on a query report for archived request conversations and I am having issues finding the right tables. Requests module Archived requests module NotificationToDesc ? Notify_Workorder Arc_Notify_Workorder Notification Arc_Notification Notification_Recipients Arc_Notify_Recipients ConversationDescription ? Conversation Arc_Conversation ConversationRecipients Arc_Conv_Recipients Who can help me to find the conversation/notification description field? Best regards, Demetrius
Report Query - Software Report by workstation with IP address
I have a query I found on here to list all workstations with specific software installed. It works fine, but now I need to add the IP address of the workstation and can't seem to get the query correct. Here's what I have, missing the IP address: SELECT (SoftwareList.SOFTWARENAME) "Software_Name", SystemInfo.WORKSTATIONNAME "Workstation", MAX(aaaUser.FIRST_NAME) "User" , MAX(deptDef.DEPTNAME) "Department", MAX(aaov.NAME) "Site", longtodate(max(SoftwareInfo.FILECREATEDTIME)) "Installed On" FROM SoftwareInfo
Next Page