What is the table store information about preventive maintenance task
I need to pull a report of a list of pm task that are scheduled, their next schedule date etc. Thanks
Preventive Maintenance Report
I am trying to create a report to show all of the preventive maintenance and when they are scheduled. The sworkorder table gives me the Title and description. However I cannot find when it is scheduled and who it is assigned to. Many of these have not get generated workorders because they are annual and have not come due yet. Does anyone have a query to get all the information associated for Preventive maintenance?
[Case study] Morgan-Keller Construction leverages Analytics Plus to visualize the need for an in-house IT team and proactively plan support for remote workers during COVID-19
Morgan-Keller Construction is a privately held general contracting and construction company with roughly 400 employees. Half of these employees work out of the corporate office in Frederick, Maryland and take care of planning, budgeting, and marketing
[Webinar alert] Is your IT team ready for the hybrid work model?
Hybrid work—a combination of remote work and work-from-office—is becoming the norm for several organizations. This presents a unique set of challenges for the IT teams, who have to prepare to tackle these new challenges and ensure efficient service desk
SLA Report for Group
Hi All, Please help to create SLA report for Group. We are looking for Response time and Restoration time for each group. Below are the version details: ManageEngine ServiceDesk (Version 9.0 Build 9033 ) Database: Postgre Regards Jayakrishnan
Custom Query to export category details
Hi, Can anyone help me with some custom queries for the below scenarios: 1. Needs to export all category , service categories, subcategories and items. 2. Needs to exports all incident and service catalogs under all the service categories Servicedesk version: 10.5 Build 10513 Database : pgsql Thanks Ahamed
Need Report
Dear Team, I need a report with below mentioned columns. Date Filter Today, Weekly, Monthly Date New Tickets On Hold Tickets Closed Tickets Backlog SDP Version 11.2 Build 11205 Database : MS SQL
How to populate information from details of incident into request
We have a need to populate information gathered from the details of the service request into the associated tasks. The example I can give is a new-hire request. When this goes in, the HR department fills in the necessary information, assigns the editor
Reports Problem [Hard Disks, Capacity]
When generating a report, there is no way to add rows / columns with information about hard drives.
Query raport Technical with role and support group
Hi, I need create query raport Technical with role and support group. SDP: 111140 MSSQL 2016 How create this raport? I try use query from knowledge but not work (sql problem). regards Mat
Report on Technicians and SLAs
I'm attempting to create a custom report, but I have very limited experience with creating query reports. I was hoping to create a report that would mainly focus on Technicians; how many tickets they have received weekly and monthly, how many of their
Report of Last Logon by Technician
I need a report that will show me the last logon time by a technician. Running MSSQL on version 11.1.0 Build 11126 There was a link to a KB with a query report, but this did not work for me. It cannot find the table HelpDeskCrew https://pitstop.ma
Report to show number of breached SLA's for current week for certain group
Hi all, I'm looking to build a report which will show me the number of SLA's that have been breached for current week. Also would it be possible to group by technician Thanks in advance
Help with Database (Creating PowerBI dashboards)
Hello all. I am new to ServiceDesk Plus but have used PowerBI a lot in the past. I was able to get connected to my PGSQL database and pull some tables. For my first dashboard I am planning on simply showing the current tickets for each group/queue, and
Can you fix this report.
Hi, i have been working on the below report, can anyone take a look and let me know why it wont generate, there is nothing in the logs when i run it. it was working up until the network info was added. SELECT workstation.WORKSTATIONNAME "Workstation",
Need custom report query to find out the assets which never been contacted to ServiceDesk Plus in last one week
I'm looking for a custom report SQL query that can help us to keep an eye on Assets. If any asset is offline for more than a week then we should have the information about that. like last successful scan status on yyyy-mm-dd. and "not been contacted since12 days" etc. The field requires CI Name, CI Type, Model, Product Name, Processor Name, Total Memory, Workstation Scan History (from history tab which inserts "last success scan and not been contacted by SDP since 14 days") Workstation scan history
User Inventory Report
I need the below mentioned reports. Reports Multiple asset tag on Single User Reports Single asset tag on Single Users Your Version : 11.2 Build 11205 Latest Version : 11.3 Build 11301 View Service Pack Details License Type : Registered Version Database
Report for requests create during specific times
How do I create a report to show the number of tickets create after and before a specific time each month? For example, I'd like to identify the number for inbound requests we receive between 7pm and 7am each month to determine if we need additional
CMDB report needed
Can I get a report of all CI types and their relationships EXCLUDING people CI type? Running build 9202 on windows with postgres DB Also is there a tool that I can connect to SDP to allow me to create reports such as this using a drag and drop feature? wayne
Enhanced "Time taken to First Response" Report
Hello, I've produced some reports using the Request Metrics set of data under Custom Reports. These are great at giving things like average response time and average resolution time, but I wanted to dig a bit deeper into the data so I could really trust
CMDB Reporting on Relationships
I am using SDP 8.1.0 Build 8105 and want to be able to report on relationships in the CMDB from within the reporting module and not just on the CI items themselves. Is this possible?
Custom Query Reports
I'm attempting to create a couple of custom reports, but have very limited experience with creating query reports. I was hoping to create reports that would output the Average First Response Time for the previous month, for a couple of specified Groups,
Need a query for software version column to be added along in software report.
Dear Concern, I need a query for software version column to be added in the software report. Kindly provide a required query ASAP. Thanks&Regards, Seema John
Reporting on when an a custom Field was updated
Hi there Can anyone guide me on how I can report on what time a custom field was updated and who performed the action? I have a custom field called "Triage Complete" - Yes or No. I would like to be able to use this as a response measure by my team and
Report Creation - Changes - Change Requests Pending Approvals
I'm looking to create a report of Approvers who have yet to respond to an approval request. How would I go about doing this?
[Analytics Plus] Launching advanced analytics for ServiceDesk Plus' survey module
Hello folks, We're happy to announce that we've launched advanced analytics for ServiceDesk Plus user surveys. Now, you can leverage end user feedback to measure service desk performance and optimize service offerings to ensure better customer satisfaction.
Report Project Status change From History
Hi team. A pleasure to salute you. Is there a way to generate a report that shows the status and dates of changes in the status of a project? And to be shown in the report like this: Thanks and Regards!!
Report
Hi, Please tell me how I can make a report with this 4 columns: ID Subject Requester-Name Requester-Email
Report sorted into days delay.
Hello, I am looking for some help creating or modifying a report that will show all open requests , sorted into days delay. I have attached image for reference. Thank you very kindly,
[Analytics Plus] Launching advanced analytics for ServiceDesk Plus' survey module
Hello folks, We're happy to announce that we've launched advanced analytics for ServiceDesk Plus user surveys. Now, you can leverage end user feedback to measure service desk performance and optimize service offerings to ensure better customer satisfaction.
Assets change report
Hi team I need a report that shows the assets that have changed from one user, department or site to another in the last month. Could you help me, please? Service Desk Plus: 10.5 Build 10500 BBDD: MySQL In the results, I should see the field Asset T
Query Report for Non-Close/Cancelled/Resolved Tickets Greater Than 5 days with Specific Value in 'Incident Additional Field'
Hi! I'll looking to create a query report for tickets which are not close, cancelled or resolved, which are older than 5 days with a specific value in the incident additional field. Please help. Warm Regards AA
Switch relationship query
Please provide an query: All switches and routers for which no rack relation is registered.
[Free e-book] Back to work: An IT admin's guide
As employees begin to return to the office, organizations need to adapt to the requirements of new-age workers. Read our e-book to learn how to transform your workplace to keep up with changing dynamics. Download now.
Query report usage reply template and resolution template
Hi, Is it possible to run a query report on "Reply templates" and "Resolution Templates" usage? I've only been able to find the option to see the usage for "Request Templates". Thanks
Query for below mentioned report
All Tickets(Service Request & Incident) from 1-jan-2017 to 3-June-2021 Required field: Request ID, created time, Technician
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
[Reports] Time elapsed on open tickets?
I'd like to set up an average age of open tickets report but the time elapsed column seems to only work for tickets with a closed status. For open tickets it just returns 00:00:00. Is there a way to do this through the GUI or do I need to figure out custom code for this? Thanks!
Technician Log In Report
Could you please assist with building this report: My supervisor would like a report that displays each technician log on and log off from service desk plus so that it basically looks like a time card. Should look something like this image below: Ideally
[SDF-28079] Data Filter update - Last 30 days
Can the following article be updated with the templates for the latest time filters? Where are the templates for the following? Last 7 days Last 15 days Last 30 days Next 7 days Next 15 days Next 30 days They are required for scheduled custom query report.
Next Page