Template report
Hi, Wondering how can i run a report to show list of tickets applied with a template, created after a date and description contain certain text. Table headers required request ID, request subject, request status, and create date. we are using MSSQL
[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.
How to get the details entered as report in the Checklist associated to the Request .
Checklists are created added to the request template, How to get the details entered in the checklist field
Scheduled report runs once and then sops until service is restarted
We are using the ScheduledReport.py script to send e-mail with Pending reqiests to each technician. This has recently (ca 3 months ago) stopped working. It works once after the service is restrated and then would no longer work unless the server is restarted.
Software Custom Report
Dear Team , we are looking to generate a report with below details , with ability to filter with software name Software name User Asset name service tag License name License Key PO number Department Division Asset site name @Database Name = Microsoft
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")
Preventing blank schedule reports when data is not available
Requirement : I need to send emails to the technicians at the end of everyday listing the number of tickets that are open and on hold for them ( if any ) till the current day. My approach : Create scheduled daily reports for all technicians with filters as request status = open/onhold and technician = technician name. Now whenever their are no tickets open/onhold for that technician , a blank email will go to him. How do i prevent this from happening? I have seen other people posting on this
[SOLVED] Error when generating reports
Hi Guys, I am getting the below error when i try to generate any reports am not sure what could be the problem any help will be much appreciated. Regards,
Query for Scanned Serial Number
I have a listed of all our inventory in an Excel document, but I need to merge this data with the scanned data so we don't create duplicate devices. How can I export the scanned serial number and device type of our printers, workstations, and servers,
Report - Ticket group changes
Hello, Tried to search forum, closest I found was Report on Activity history (manageengine.com) with out of date links. Trying to produce a report for ALL tickets in the system, showing every time they changed group rather than just the current group?
Query about groups and technicians
Hi team, could be possible to obtain a query to extract a list of support groups, associated roles and technicians (with additional user information like name, email, phone, etc)? SDP v11.0 SQL Server Thanks in advance
Report on Attached Documents on assets and Status change history
H, we use to attach a receipt signed by the user to the asset. So we need to extract a report showing all assets which have a document attached within, the upload date, and the information related to the asset property history. We also need (on the same
[Free e-book] 7 real-life IT problems and how to solve them using advanced analytics
Did you know that advanced analytics can help you resolve 70 percent of your help desk problems? Download our e-book to learn how.
TimeSpent Report - Non operational hours
Hi, I'm looking to generate a report that displays how much work a technician has done outside of operational hours. Ideally each ticket between a certain timeframe would be queried and then a count of each worklog where work outside of normal work hours
Exclude Tech From Query Report
Hi All, looking forward to your valuable help to instruct about how to exclude specific technician from a query report that i generate it using "MSSQL" to get the status of mainly violated tickets. The following is the current query: and if possible
Reports not working: MSDP 11.1 Build 11135 on Centos 7
Hello, cannot generate custom reports or any reports at all. Here is error from serverout0.txt when triggering report generation: [09:37:29:168]|[04-28-2021]|[SYSERR]|[INFO]|[42]: java.lang.NoClassDefFoundError: Could not initialize class net.sf.jasperreports.engine.util.JRStyledTextParser|
technician report
hello i need a query to export the technician list with all it's details
Health Meter removed on SDP 11.2
Health Meter removed on SDP 11.2, why?
SR linked with CR
Hi Team, We need to generate a report on SR linked with Cr
Report for Operations made by Technician
Hi! We are facing an issue where a technician assigned requests to another technician and now they can't find the requests anywhere - even after extensible search we were not able to provide help. So now my idea was to generate a report on operations
Top Assets based on Incident request
Hello, Is it possible to run a query to get assets lists by number of tickets opened?
SDP 11202 critical issue
Hello! Just to let you know... On SDP build 11202 there is no possibility to edit/save ANY asset. It just throws error Unknow error occured. Clearing out any asset fields or attributes not helping. On SDP build 11201 everything seems good. Assets are
Query needed for projects with no dates
I need to build a report that will provide this detail shown below. I tried to build a custom report (tabular) but the custom report date filter does not allow enter a blank for dates. I am specifically looking for projects created that do not have Project
[E-book] 10 secret strategies to supercharge IT reporting
Hey there! Far too often critical insight goes unseen and unused without the right reporting strategies. Download our e-book to discover reporting strategies and learn how to build reports that fuel growth.
Top ten requesters
Need report: Top ten requesters, to see who's the most problem user ;))
[SOLVED] query report in ServiceDesk Plus cannot show decimal
Dear SDP Plz help me this issue. I have a query report in tab report : SELECT Count(std.STATUSNAME) AS "Tổng yêu cầu hỗ trợ", sum(Case std.STATUSNAME when 'resolved' then 1 when 'Closed' then 1 else 0 end) AS "Số yêu cầu đã hoàn thành",ROUND((sum(Case
Query on time spent by each group
Hi Team, We are looking for a query to generate report on mentioned scenario"time spent by each group"
Technician Auto Assign - Report
Hi All, Looking to configure a report/s to monitor how many calls are assigned under the Technician Auto Assign function to each technician on a daily basis. I can't find any preconfigured reports that covers this. Has anyone developed a report or is
Custom report
Hello, I need an Assest report that lists all workstations with the following info. Model, Acquisiton date, Expiry date, Warranty expiration. I would like the asset listed in the first column and the rest of the info in the following columns in any order. Can you please give me the query syntax for this report? Thank you.
Request for report for Time spent (worklogs)
Hi all, We have recently updated to version 11.1 Build 11140 , this has broken one of our summary reports for that weeks worklogs, could someone take a look/ provide a updated report? SELECT rctd.FIRST_NAME "Time Spent Technician" ,cast((sum(ct.TIMESPENT)/1000
A report of a specific form.
PGSQL / SDP v11.1 Hello. tell me, there are tons of questions and problems with the report builder. Reports: Summary report on requests My Result: I click the show request button W.T.F. !?!?!!? I want to make a report of the following TYPE: 1. add
Report based on template name
Hi Team, I want to generate report on particular template kindly guide us
Query Report: due date change
Dears, I need a report that shows me the tickets that they due dates changed by technicians: changed by system should be excluded convert to template should be excluded required fields: ticketID, requester, group, subject, technician (that changed the
Weekly Report filtered with Approver name
Hai , we are using servicedesk plus 9 in our company, How we can generate weekly reports with approval name and all pending approvals with the approver. your early response is highly appreciated. with regards, M.K
aggregate report within SDP
Is it possible to have an aggregate SQL report for the last week shows the below result: Group Total number of received tickets Completed tickets (closed, Resolved, canceled, rejected) open tickets (open, assigned, in progress) on hold tickets overdue tickets DB is MSSQL
Aging Report totals by Specific Range
We are using MS-SQL and ServiceDesk 11.1.0 Build 11129 I am trying to create a summary report which has the following breakdown of the incidents and requests which are open, in progress, or on hold: 0-7 days 8-14 days 15-21
Export Service Catalogs
Is there any option to export service catalogs templates to excel ?
Add count of template usage
Hello, I need to add to the following query: select rtl.templatename "Plantilla", rtl.status "Estado", qd.queuename "Grupo de Soporte", cd.CATEGORYNAME AS "Categoría", scd.NAME "Subcategoría" from RequestTemplate_Fields rtf left join RequestTemplate_list
Need to run a report for Assets with Missing Dates
How can I create a report to show all assets that do not have an Acquisition date, Expiry date, or warranty expiry date? This would help us check for missing data so that we can get it filled in.
[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
Next Page