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
Exporting all ticket data types
We have used resource info questions heavily in service request forms. I have a request now to export all this data for specific forms. I know that these types of questions are not usuable with the built-in reporting function and also not found in ZOHO
How to extract template down to item with SLA using query
I want to extract data on the existing template til item with SLA
Service Catalog report
Can i get a report for all the active Service in the system including the category, subcategory and the 5 levels of approval?
Reports
Hello , Is there a way that we can do a look back at the following, so we have a benchmark: How many tickets were submitted on average per week year to date? How many tickets were submitted on average per week over the last 90 days? these would be two
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
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.
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.
Reporting on resolution templates used
Hi, can anyone help with this one? Fairly new to ME, but I am trying to get a report where I can report on the Resolution Templates used when a ticket is closed. Nothing too complex - ticket number, resolution template name and a bit of flexibility on
SQL Query for technician audit trail
SD+ version 11.3 Build 11311 I am looking here (but can't find anything related) on SQL Queries based on tracking technician activities. Is there any existing SQL query I can use to know who have done what and where (like changing request status, input
Number of requests created by time report
Hi all. I'm trying to create a report to show in a bar graph the number of requests created each day going back 30 days or so. When I create the report I also get what appears to be a sort of legend off to the side which I don't need and also the bar
custom report - logged time per technician per project/ticket // per month
Hi could u please help me write a custom query for our windows installation with MYSQL. I'm looking for a report that gives me an overview for the work logs per technician be it Project or Request. TicketId or Project ID + Title Work log end date. Technician
Checklist - Include in Tech Report?
Hello, If I want the answers to associated checklist items to be pulled in a technician report, how would I go about doing that? Thanks, N.
Query Report for Request's History data
Hello, I am deploying a new instance of SDPlus and the customer is asking me if it is possible to run a report that gather the same data that are available on the History tab of a request (see attachment). Could someone help me on identify what tables
Tickets history report
I need to pull a report for 2020 and 2021 that how many tickets created and the ticket details. Please let me know if there is a sample query to pull those reports. BTW I m using MSSQL.
Custom Software Report
I'm trying to create a custom Software report. I have this so far but i cannot figure out how to get the total install count. SELECT softwarelist.softwarename "Software_Name", Max(swmfg.NAME) "Manufacturer", Max(softwareinfo.fileversion)
Stopping a long running report
is their a way to stop a long running report in the reports portal
Query report to extract Technician data
I need a query report to pull a list of all licensed technicians along with a list of their associated groups. I want it to show me technicians that don't have any groups so I can clean them up as well. SDP Plus Build: 11118 Database: MSSQL
query issue
Hi every body, I have issue with query report, support team sent to me new query report for check approve status,for excample who is approve the ticket,when i paste aquery it give me the error what is the issue? Thanks in advance
Query to have or operation in subject field
Hi , Can you help me with query in report to get the reported generated. Requirement is if subject is A or B or C or D then should include in report.
Custom Report
Hi, Please help me to create report like this report: category - request count - number of closed request - closed average time- number of open request Hardware - 120 - 20 - 13:30
I need a query to show the active technicians
i need a query report to know the technicians who is active and using the license in SD system plus and the technicians who is having license but not active or do much activity in the system we are always running out of license and they requested from
Incident UDF Fields not available in custom report
Hi all, I'm trying to create a custom matrix report using UDF fields we created for a custom Incident template. When I use the Custom Report wizard to create the report, some of my UDF fields are available and some are not. I checked the properties
Create a report of Requests grouped by Dependents
Hello. I would like to know how to create a report that is grouped by a Request and then under it, all of its dependent requests. See attachment for example. Thank you.
Is There Projects Report for % Milestones ?
Hi Community, We are part of PMO and we looking forward to have below Measurements as Advance Report: (A) Milestone: 1- Milestone Available: If yes will take 100%, if no will take 0% 2- Milestones With Scheduled End: % Average of Milestones With Scheduled
Custom Report Needed...
We use ServiceDesk Plus, and PG incase query is needed. I keep getting lost/confused/can't get it to work with the GUI reports. I need a report that is sorted by Groups and then Priority, and I need the report to include Created Date, Completed Date,
ME SDP Please help to modify query report.
Hi We have following query report: SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", longtodate(wo.CREATEDTIME) AS "Created Time", longtodate(wo.COMPLETEDTIME) AS "Completed Time", std.STATUSNAME AS "Request Status", ti.FIRST_NAME AS "Technician",
KPI report
Hello. need query report for KPI to calculate mtt responce, mtt resolve
Report on Requests,Problems,Tasks per Technician
I would like to create a report showing, for each technician, how many Open Requests, Problems & Tasks they have. I have reports for all Open Requests, all Open Problems & all Open Tasks but they are separate reports. What I want is to join this information
Report for specific users
Hey! I am looking to create a report that runs weekly that pulls information from a specific group and then puts the information into a summary form with the date of the ticket, the ticket summary, how many days overdue, the agent assigned, and the priority.
Search by Description in Archive
I'm trying to find some information on old tickets in order to take care of some current issues. I tried building a report on Archived tickets but I'm not seeing "Description" as an option. Is it possible to build a query to search through archived tickets
Generate a list of printer with IP address
Hello, Grateful if you could advise what is the mistake in it. All are generated from SDP in this custom query except the [ MAX("networkinfo"."IPADDRESS") AS "IP Address" ] part. SELECT MAX("productType"."COMPONENTTYPENAME") AS "Product Type", MAX("resource"."RESOURCENAME")
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
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 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 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,
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.
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?
Next Page