History in the reports.
Hi. Please tell me how to view the change history in the reports. Someone deleted the report and now the running task is triggered, emails arrive, but they are empty and the task is not displayed in the scheduler. The report is also not in the list of
The “Enterprise” field is not displayed in the ESM catalog in ServiceDesk
While working with the ESM catalog in the ServiceDesk system, I encountered an issue: the “Enterprise” field is displayed on one instance of the system but is missing on another. P.S. In English, the word “Enterprise” translates to “Компания” in Russian.
Can I generate this specific report using resources from a request?
I have a Service Catalog template called Employee Onboarding/Transfer that contains resources for the user to input the employee's name. I would like to generate a report that shows the following: Employee First Name Employee Last Name Requester RequestID
Report notification
Why would the deletion of a private report generate an email notification to all technicians?
Technician not available in Task report filter
I have written a task report, and I have one technician who is not visible in the filter. He is a member of the project the task belongs to, and have added him as the owner of the task. However, when I create a task report, he does not appear in the list
Custom Reports with attachments
Hi, How to create a custom report for ticket which has attachments? Regards, Karthikeyan R
Ticket Transfer Report
Hello, I would like to create a report that: - Presents tickets re-assigned from a specific support group to any other support group - Has the ability to specify a date range for the data I have played with some queries but the date format is difficult
ServiceDesk Plus Asset Description Report
Hello I've tried to create an asset report that include all Servers and Workstations actually present in our SD+ IT assets, that show basically the asset Asset Name and the Description present in the asset itself, but using the default report present
Requester Report Query - ESM
Hi, I was given the below query to pull Requester details off the system: SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department",
Technician Roles and Permissions/Privileges
I had an inquiry from our leadership as to who (technicians) can view what data in our Service Desk system, and I scoured the forums and can't find a query provided that matches our current database. The HelpDeskCrew table is gone in this version, so
Custom report - Requests inflow
I would like to build the Dashboard report "Requests inflow by time" by my own via custom report to customize and schedule the report. How could I archive this?
Report of users field "Requester allowed to view"
Hello, Is possible to know which users in ServiceDesk Plus (version 11, SQL Server) have the following option configured? Requester allowed to view --> All their Department requests Thank you.
Request for Incident Worklog attached to project
Hello I attached some request to a project. Each request has worklog. I would like a request to calculate the sum of worklog time by project Thank you
Is There Projects Report for % Tasks Compliance ?
Hi Community, We are part of PMO and we looking forward to have below Measurements as Advance Report: (A) Task: 1- Tasks Assigned to Owner % Average of Tasks Assigned to Owner as per Project. 2- Tasks On time and On-Schedule (Not delay based on Scheduled
Reports - SQL - Concatenate using bar didn't work
Hello team, We changed from version 9416 to 11306 (some time ago). There are some SQL reports that we cannot create because there are some things in the query that are not allowed now. This line is falling (into the SELECT): (ROUND(((WorkOrder.timespentonreq/1000)/3600),2))||':'||(ROUND((((WorkOrder.timespentonreq/1000)/60))
Recently Installed Softwares Report
Hi, is there a report which lists recently installed sofwares in the below format? Software Name/Version/Computer Name/Date Installed
Audit or worklog of technician
Hello, almost any action are stored in history's e.g. history of incidents, changes, problems, tasks or whatever. Now is there a way to get a work-log (or may called audit log) of an technician to see the sequence of all changes/modification done by a
Email Note to Requester
As everyone is aware, it's been on the 'ask' list for years: https://pitstop.manageengine.com/portal/community/topic/e-mail-note-to-requester Wondering if this MSP custom schedule/script could be used to email requesters when a Note is added to their
Graphs not updating
Good afternoon, We have some graphs that hasn't updated since late October. They count the number of tickets received in the month. They have been working well since we set up them up at the beginning of the year. We are running Version 11.3 build
Weekly Technician Reports
Hello, We would like to create a report that shows the following data from the prior week. We would also like to only see Techs assigned to the Service Desk support group. Please see table below for layout Edit: We decided No. of tickets reopened
[SDF-91636] Reporting on Incident Tags
We are using the Add Tags feature to track expendables we hand out and I'd like to pull a report on Tags used with department within a date range. I don't see a custom report with Tags and I don't see Tags in the schema to create a custom query.
Change Management Query Not Working Please do the needful
SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", longtodate("chdt"."CREATEDTIME") AS "Created Time",longtodate( "chdt"."SCHEDULEDSTARTTIME") AS "Scheduled Start Time", longtodate("chdt"."SCHEDULEDENDTIME") AS "Scheduled End", longtodate("chdt"."COMPLETEDTIME")
Health Meter removed on SDP 11.2
Health Meter removed on SDP 11.2, why?
[SDF-85898] Time spent percentage
Hi, I'm using last service desk plus version and postgresql database. My question: is there any way to obtain a report with time spent by category at day with percetage values and not hh:mm? I would like to obtain what time percentage my tech waste per
Reporting on specific field changes
Is there a report, or a way to make a report that will show me tickets that have had specific fields changed? I'm looking to find tickets that have had their ResponseDueBy Time, and DueBy Date changed as well as who performed this change and when. The
Tickets on Weekends
Hi, How can i create a report that shows me incidents and service request created on a weekend. Dave
[SDF-43984] What can't I see scheduled reports?
If I create a scheduled report I can see it - if someone else does I cannot. WHY??? What if the other person quits?? If I am a sysadmin in service desk - I should be able to see everything!
Trying to find all asset history
Hi all, Is there a way to determine all the asset history a particular user has had?
Date format in query reports
Hi All, Currently running SDP 11120, Postgres SQL (installed via SDP installer) Since upgrading from SDP version 9, one of my query reports isn't working, as it looks to_char in select statement isn't supported anymore, causing an error when trying to run the report (attached). I had previously used to_char to manipulate the date format, for example: to_char(to_timestamp(wo.CREATEDTIME / 1000) + interval '10 hour' , 'DD/MM/YY') "Created Date" Is there a different way to perform the same fuction now?
[SDF-88990] Time Elapsed Analysis - For Current Status
I would like to extract in a form of Query Report the time elapsed for current status of Request. As per below screenshot, i should able to see this request's current status is OPEN status for 28 hours and 33 minutes. Can you help to provide query to get this info. As of now, i can extract only the time elapsed between transition of Status.
Asset first assign report
Hello to all, is it possible to obtein first asset assignment (asset and user detail) in a report? Our installation uses SQL. Thanks in advance
Matrix Report
Is this even possible to do with the MAtrix? In order to help track the team’s metrics in tracker, we need a report(s) that will accurately capture our daily work load. Please see the data we need to capture per associate. Associate Name Starting Ticket Inventory New Tickets Received Processed Closed Tickets Ending Ticket Inventory Ashaki 0 0 0 0 Duy 0 0 0 0 Kevin F 0 0 0 0 Lacy H 0 0 0 0 Liz R 0 0 0 0 Prasath S 0 0 0 0 Jennifer R 0 0 0 0 Not Assigned 0 0 N/A 0 Morning Report · Starting
CREATE A QUERY REPORT
I would like to create a report that allows me to see all the ticket data, such as the tasks, notes and responses that have been added to a request
How create asset report that contains hardware datail
Hello, Is it possible to run a query report that includes hardware details? especially the type of hard disk. thank's for your help Fabiana
SDP - User Access report
We expanded our SDP ESM on-site to additional Departments. We would like to be able to track user engagement by reporting on user logins to the site. Is it possible to build a report tracking user logins?
Requests Report showing Reporting To
Hello, We are looking at creating a report with the following. Reporting To Requester Department Request # Subject Date Created Category Sub Category Technician We are using Version 10 Build 10009 MSSQL database
PGSQL database
Can someone help with a query report for a PGSQL database for the guidlines below? Response time - the time between ticket creation date and the first technician response Resolution time - the time between ticket creation and closure dates Average number of tickets created per day Average number of tickets closed per day
Audit report by specific workstation name
Hi, I wanna to get audit report by specific workstation name. I need this query DB: Postgres Build: 10.0.13
[SDF-56484] Scheduling reports - Based on data availabality for the report.
Hi , 1. We have a few scheduled reports that is intended for reminding the technicians/ users to change the status of the tickets to appropriate Status. 2. Irrespective of the tickets avaialable as per the set conditions in Scheduled report, the mail is forwarded to the mail IDs as updated in the scheduled reports. For eg: even if there are no tickets for which action is to be intiated, the mail is forwarded with NIL data. 3. Can you pl let us know, if we can curtail forwarding of scheduled reports
Time Spent Calculation
I'm using MSSQL as my platform. I would like to know how to calculate my own time spent between 2 dates. Clearly SDP does this for me in the WO_Group_Info, WO_Tech_Info, and WO_Status_Info tables, but this is NOT what I'm looking for. I would like to know the underlying code that does the math and logic. I would imagine that something within the system if factoring in HoursOfOperation, DaysOfOperation, HolidayDefinition, Hold_Period_Group and/or Hold_Period_Tech. I've looked through the functions
Next Page