[Free webinar] How to design the perfect SLA, SLO, and SLM compliance dashboards
Hi there, IT teams today face mounting pressure to deliver top-notch operational reliability, service accountability, and customer satisfaction. But without clear visibility into crucial service-level metrics like SLA, SLO, and SLM, this can feel like
Can't export reports that contains graphics
Hello, since upgrade from older versions to latest, we have some exports (PDF, XLS...) that stucks un "generating". The same report without graphics is exporting correctly. We have no 14.9 b30, SQL Server... Thank you.
[Free e-book] CIO's guide to the biggest challenges in managing IT expenses
Hi there, Are you struggling to balance innovation and cost efficiency in your IT spending? You're not alone. Many organizations face mounting challenges with costly overruns and inefficiencies draining their IT budget. In today's rapidly evolving business
Need to incorporate "Notes" info in ServiceDesk plus change MGT report
Dear Expert, please help to add "Notes" (CR submission stage) in below existing custom query. below query use for exporting CR data (DB - MSSQL 2022). select chdt.changeid AS "Change Request Number", ctDef.NAME as "Change Type", requester.FIRST_NAME as
Query to Generate Report of all Technicians in SDP (MSSQL)
I just wanted this to be listed here in the Pitstop, for future reference, and in case others might need it (Running SDP On-Prem v14.6): select au.FIRST_NAME as "User Name", al.NAME as "Login Name", dd.DEPTNAME as "Department Name", sdo.NAME as "Site
Character Limitation Multiline Field
I can't type more than 250 character in Multiline Field.
On-Premise Chart Reports for KPIs and SLAs
As we are migrating to the cloud, our PowerBI reports, and their connections are broken at this time. We are looking for help building reports on the following KPIs and SLAs with charts for better visibility. KPIs Closed/Received >92% Example: % closed
5 capabilities every IT team should adopt for survival [Free whitepaper]
Hello there, In an era of unprecedented digital transformation, survival of the fittest has never rung more true. To remain competitive, organizations must adapt to changing trends and adopt AI's diverse capabilities for operational sustainability and
Can I remove the time from 'created time' field?
Is it possible to remove the time from 'completed date' (or other date/time fields)?
Exporting a project to CSV, including tasks, milestones, timelines, roles, and time details.
Es necesario exportar un proyecto completo a CSV con todos sus atributos en el módulo Proyectos de ServiceDesk Plus. ¿Cómo puedo hacerlo?
Custom change report
Hi I want to create a custom report to show following information Change ID Title Change Requester Change Owner Change Implementer Schedule Start Scheduled End I've try this query => https://pitstop.manageengine.com/portal/en/kb/articles/change-rl but
Report license software by site and custom attributes
Hello, I'm working to create a custom report with status of licenses: installed, purchaed, allocated, available... this is the query: SELECT "softl"."SOFTWARENAME" AS "Software Name", "softcomp"."COMPLIANCETYPE" AS "Compliance Type", "swmfg"."NAME" AS
Experiencing issues with sending report from SDP to email
Hello team, We are currently experiencing issues with sending report from SDP to email and also scheduling reports is blank data. ServiceDesk Plus (Production) Current Version: 14.8 Build 14850 ServiceDesk Plus (UAT) Current Version: 14.9 Build 14900
Deliver exceptional employee experiences with analytics-powered service management [Free e-book]
Hi there, Are outdated, SLA-centric ITSM practices stifling your employees' productivity? In today's economy, employee satisfaction is the service desk’s ultimate KPI. With a rising demand for seamless, outcome-driven service desk experiences, building
Maintenance Report with template field information
Hi, Team, A customer of mine needs a report with information on some of the maintenance template fields already filled. I can get a report with the title, next scheduled time, requester, category, and subcategory, among other fields. I also need to add
Requesting the ability to report on Roles with assigned users
HI, I need to produce a monthly audit report of Roles that list the users in each role, rather than list users that are assigned to roles SDP version 14830 SQL DB Is anyone able to assist please. Thanks :)
Trying to run a report that will show Work Timer entries when NOT added to Worklog
Trying to run a report that will show Work Timer entries when NOT added to Worklog I see they do show in the history of the request. Is there a way to find those? Thanks in advance.
Request for Custom Query Report
Dear All, We would like to have a SQL Query report with below columns: a) Asset ID (unique) b) CI Name c) Software's Installed Our current built of the Application is 14720 Regards, Wajahath Farooq
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
Task Advanced Matrix monthly summary report
We are able to create a great Advanced Matrix report for Requests that shows the count of the number of requests closed per support group per month and would now like to create an identical report but for Tasks. When we select Matrix Reports the Tasks
Report to show usage of Templates
Hello, Could you please provide a New Query Report sql script that will show how many times each of the templates have been used? Version : 9.0 Build 9032 Many thanks, Lisa
Reporting time on line for technicals
Buenos días, Como puedo obtener un reporte con el tiempo en línea de los tecnicos usando la herramienta?
Urgent Request for Report on Default/Generic Accounts and Password Change Dates
Dear Support Team, I hope this message finds you well. I am writing to request a report or evidence from the logs that includes the following information: A list of default or generic accounts, with particular emphasis on the Administrator account from
Maximum Number of Additional Fields
Hello world! We have been building out new ticket templates for more of our departments to utilize the Service Desk in Manage Engine. Yesterday we reached our maximum number of additional fields and can no longer create new fields. I know we can clean
[Free webinar] 5 steps to secure IT using analytics-driven service management
Hi there, Did you know your service desk can be much more than a mere customer support tool? It can be honed to play a critical role in fortifying your organization's cyber resilience. Join our upcoming webinar to discover five proactive ITSM strategies
Query for Warranty Expiration on Network Equipment
Hello, I am trying help our network engineer out. He built a query for asset records on all of our network equipment, however, warranty expiration date is a field you can build into reports. I have tried to create a custom query with query editor to add
report for audit successful and failed login attempts
we have ServiceDesk Plus v 9.0_9017 - MSSQL database we need a report (event in last month) with login attempt on service desk application (successful and failed) with 4 column : date and time (ordered), event... successful or failed login, username,
Query to get Open status timespent calculation
Version : 10609 DB : MSSQL OUTPUT : SELECT "wo"."WORKORDERID" AS "Request ID", sisd.STATUSNAME as "Changed From", sinsd.STATUSNAME as "Changed To", case when si.NEXTSTATUSID is NULL THEN cast(datediff(d , dateadd(s,datediff(s,GETUTCDATE() ,getdate())
Report user licenses
Hi, When I register a new software license, I linked it to users. So is there any way to obtain a report that include all users associated to a licenses? My instances is PSQL Regards!
[Analytics Plus webinar] 4 ways you're draining IT resources
Hello there, Stop letting performance issues drag down your service desk. Tackle inefficient IT practices head-on and end resource-draining inefficiencies once and for all! Join our upcoming webinar to discover data-driven strategies that uncover and
SD Plus Report to include date but not time?
Hello We are using ME SD Plus version 14750 and are looking at producing reports using columns such as created date/time and completed date/time but not having the actual time, just the date. We are moving from a very old Support center version that when
Query report to extract list of technicians with related information
Hi, I would like to create a query report that can extract list of technicians with following information: 1. Login Name 2. Name 3. E-mail Address 4. Assigned Support Group 5. Assigned Role 6. Status of Tech Auto-Assign (Round Robin - Yes or No) Condition: The extraction is only for technicians assigned to support group that starts with "FINSSO". Really looking forward for ME feedback on this. We are using MSSQL, SDP 9.2 Build 9241. Thanks & Regards, Adilah.
Populate Installed Software List for Asset
I'm working on a new workflow for building and installing new computers that are replacing old ones. I'd like to find a way to pull a list of all installed software that is on the current (old) computer so our tech knows what to install on the new computer.
Servicedesk Plus escalation report
Hi, Can help to give me query base on below field. Naharuddin Great Eastern Life
Requests and Tasks in the same view
I am trying to find a way to view all my technicians' currently assigned work. Their work may consist of requests assigned to them or tasks assigned to them from an open project. I'd like to see a view that shows both their open requests and open tasks
PostgreSQL Custom Query for a list of workstations and the software installed for AssetExplorer
I'm attempting to create a couple of custom reports, but have very limited experience with creating query reports. I'd like to create a query that shows all the Windows 10 workstation with the name starting with "desktop" and a list of software that is
[Free webinar] 5 measurable skills that every IT technician should possess
Hello there, The success of your service desk relies on the expertise of your IT technicians. But how do you assess each technician's skillset and strategically enhance them? Join our upcoming webinar to discover the five critical skills every IT technician
[Free report bundles] Identify critical skill gaps in your IT technicians
Hello folks, Ditch time-consuming performance ranking spreadsheets that only give you a partial picture. With our latest report bundle, you can identify subject matter experts, top ranking performers, end user favorites, and more in about three minutes.
How do I build a Report that includes resources from a Request?
For example - I have a Service Catalog template called "Request Laptop" that users can fill out in the Self-Service Portal. Under "Resources", they can select a 13", 14", or 15" screen size and write in a "needed by" date. I would like a report that shows:
Custom query to generate a report with description and resolution of archived ticke
Hello, Would like to request for assistance on how to generate a custom query report for archived tickets that includes their resolution and description. Thank you
Next Page