[Free webinar] How analytics-driven IT service management improves employee productivity
Hello folks, Is your organization plagued with endless IT challenges and declining productivity? Analytics-driven service management provides an effective solution. Join our webinar today to overcome IT bottlenecks, and improve organizational productivity
ServiceDesk Plus built-in or custom report on Technician Work Log Data
Is there a built-in report or a custom report that can be created, where I can see all technician's Work Log Data for a selected time period (week, month, etc.)? We are starting to have technicians enter their "time worked" in the Work Log tab for all
time elapsed
Hello! the elapsed time is incorrectly counted in the report. request was created on 26/01/2023 06:22 AM resolved on 26/01/2023 08:31 AM but elapsed time is 00.09.00 The same elapsed time is considered if the request was created on Saturday and resolved
Where to find TECHNICIANID
I am trying to modify a report but I am unable to find the TECHNICIANID Below is an example of the script that I have and I tried looking in aaaUser but I'm unable to find the technician I am looking for. (select sum(ct1.timespent) from ChargesTable ct1
[Analytics Plus webinar] How analytics-driven IT service management improves employee productivity
Hello folks, We're back with an insightful new webinar on how analytics-driven IT service management can improve employee productivity . Date and time: April 27, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? When faced with a plethora of
query to list incident templates
running 14005 on MSSQL I found this thread Admin Report - Department List, Requester List ,Technician List, Incident Template List, Service Template List (manageengine.com) to be able to list all of our Incident Templates. However, management wants to
Missing Scheduled Report
We have a scheduled report, Pending High Priority Tickets by Technician (SEV 1 & 2), that I'm not able to find the schedule for. I see the report listed, but not the schedule or where I can alter the recipient list. I ran select * from reportscheduletask
Reports not working
There was a failure in the system, it was necessary to restore from a backup copy, previously applications were exported from the failed system ... and then imported into the restored system. Now, when creating reports, the same tickets that were imported
add ticket attachment to custom trigger notification
is there a way to automatically add the attachment(s) within a ticket to a custom trigger? thanks
Metrics? Looking for Time to Acknowledge
IT Manager here, I've nailed down how to handle tickets closed and time to resolve, but struggling with how to determine time to acknowledge. Has anyone figured that out yet? I'm fairly stumped.
Report Request - Conversation - Completed Tickets Completed in Specific Time Frame
Requesting a report which has conversations from/to/cc a particular domain "@general-data.com". We're looking for a count of tickets completed tickets in the 2022 year that meet the above criteria.
Bios Date format
When I run this report my Bios Date format is 20220317000000.000000+000. Is it possible to change this format like this DD/MM/YYY? SELECT MAX(WORKSTATION.WORKSTATIONNAME) AS "Machine Name", MAX(WORKSTATION.SERVICETAG) AS "Service Tag", MAX(WORKSTATION.MANUFACTURER)
Laptop Asset Report
In the SDP build 11315,we are not able to take the asset report of Laptops. In the asset web console we will be able to see the segrigation but in the reports laptop selection is not there. Please help in this case
SLA Reports
Hi Team, When i generate SLA Violation Requests by Technician my report comes out empty, am not sure what i have not set up for this. Any help would really be appreciated.
Query Report adding Asset State changes
Hi Everyone, I currently have a query that gives me Asset Name, Product Name, Current User, Asset Tag, Serial Number, Asset Tag, State, Previous State and the dates that these changes occured This is really useful at the moment for finding out how many
How are we view the performance of assets in servicedesk plus?
Is there a query report we can see the performance of the computers?
Custom report with IP address
Hello, I am trying to use the wizard to get an equipment report that also includes an IP and MAC address. I do not see this as an option in the report wizard. This is what I have so far from the wizard. Any help would be much appreciated. Thank you! -----------------------------------------
Project Management
How do i generate a detailed reprot for a specific project
Give technicians access to some reports.
Good day all. I would like to give my fellow technicians access to some reports, but adjusting that from the main role configuration gives them access to all of them or none at all. Is there way to limit the reports they can see? If I enable the access
Service Desk Custom Report - Export to CSV missing data
Hello, I have a custom report that I frequently export to CSV for easy manipulation & data analysis. I've run & exported this report many times. Today, when I ran/exported it, the CSV is missing data. The SD report returned 1775 tickets/records, whereas
ServiceDesk Report
I am looking for a query that will show me all workstations with installed software where the software name is "ManageEngine Endpoint Central" or "ManageEngine Desktop Central" and the last time that the workstation checked in. I believe that is "Last
How to Spool Reports On-hold On the Service Desk
Dear Teams, Kindly help to assist. How do I spool reports on hold only from the service desk.
[Analytics Plus e-book] Are you losing money on your IT?
Hey there, Are you unknowingly losing money on inefficient IT operations? As organizations fortify themselves against a looming economic downturn, removing costly inefficiencies in IT operations is critical. Read our e-book to uncover and overcome various
[SDF-70650] Adding custom dashboard report like defaults
Hi, I need to add custom dashboard report like default reports by filter them. Is it possible?
Scheduled report
Scheduled report unable to send, returns this error:
All Reports return JRException: javax.imageio.IIOException: Unsupported Image Type
Hey all New install of ServiceDesk Plus version 14.0 Build 14006 installed on Windows Server 2016 Standard All reports return the error: Message : Dear user, Unable to generate the report, So please contact servicedesk support for further assistance to
Creating reports for department request summary
I am seeking help in creating a weekly email report PDF that offers a summary of all service request submitted per department. Trying to create these via the custom report wizard seems to constantly return blank.
Export Full Service Catalog
Hi, Is there a query that I can run to export all catalog items with full details including all templates and custom fields? Any assistance would be appreciated.
Query that lists pending approval of a particular service approver With latest version (13.8)
Hello, I found a query from the following pitstop request: Query that lists pending approval of a particular service approver: (manageengine.com) That worked very well, but after I patched our SDP to 13008, no other entries are found with this query.
Report Workstation Keyboard and Mouse Serial Number & Type
Hello, I can see from the Hardware Tab on the the Workstation asset record you can view the serial number and type of mouse and keyboard connected to that particular workstation. Therefore, is it possible to run a report which pulls up the serial number
BIOS date
Is there any possibility to query the BIOS date? I can see the date in details of an asset but I cannot find the field in the database schema.
Report Workstation Monitor Serial Number & Type
Hello, I wonder if someone can help? I can see from the Hardware Tab on the the Workstation asset record you can view the serial number and type of monitor connected to that particular workstation. Therefore, is it possible to run a report which pulls up the serial number and type of monitors connected to all workstations? And if so how? Thank you in advance. Paul
report to get all technician and assigned roles in sdp?
Hello, I need a report to get all techniciat and the with Login name, created date and the assigned roles to each technician in the list. Please assist me with the query. I'm using PGSQL. Thanks.
SQL Query - Technician List
Hello. Could someone please provide a simple SQL query to get a list of all active Technicians in SDP? The methods I used to use have apparently become obsolete as table structures have changed with various SDP releases. (For instance, at one point,
CUSTOM QUERY
Please i need a query that shows the list of users with Admin rights on the service desk plus version 14000. I'm using a msql database Thanks
Survey Report Query
Dear Support Kindly can i have the query to get Survey report with the below templet . Also including satisfaction level summery dashboaed Ticket Number Requester Name Subject Group Technician Name satisfaction level (%) Comments Survey Given
[Analytics Plus e-book] The 3-step plan to reduce your daily IT workload by half
Are you struggling to meet deadlines and boost productivity? Nothing hampers organizational productivity like overworked employees and inefficient processes. Read our e-book to wield AI-powered insights to prioritize tasks, reduce daily IT workload by
Enhancement required to gather survey details from Archived Tickets
Hi Team, We need a feature either via reports or otherwise to help gather the survey details (for tickets having the survey completed) from Archived tickets. Currently even a day's delay in the next month causes Survey details to be lost in the extraction
IT analytics in 90 seconds: Cut costs with enhanced self-service
It's no surprise that repetitive processes and requests quietly drain your organization's resources. Curb the costs of frequent help desk requests by facilitating intuitive self-service. If you're not already using Analytics Plus, sign up or download
[Analytics Plus webinar] 5 things to keep in mind when planning your IT budget
Hello folks, We're happy to bring you our latest webinar on 5 things to keep in mind when planning an IT budget. Date and time: January 31, 2023 2pm AEST | 10am GMT | 10am PST Why attend this webinar? The benefits of an accurate IT budget range beyond
Next Page