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.
Reporting on Template change
We are looking for a MSSQL report which reports on how many times the Default Template is change to another template name. For example, on the 9th of May we received 10 tickets via email which used the default template to log the ticket. The technician
Tickets by Time Entered
I'm trying to create a time series report that will allow me to see what time of day our tickets are being entered. The idea behind this is to take a month of tickets, and compile them into a line chart that will show us a trend on what time of day we
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
Report ticket time spent in specific status by technician
Hi, I would like to generate a report that shows the average time that a ticket stay in particular status (In progress - Pending customer - etc) sorted by Technicians. Is it something available? PGSQL Current version : 11.1 Build 11138 Thank you Reg
Custom Report for Projects Module
Hi, can please ask for a custom query report for the Project module? Columns are to be as following: Project Title Project Status Project Schedule Start Project Actual Start Project Schedule End Project Actual End Project Estimated Hours Project Actual
Report generating rows twice
I've made a report to show the time spent per ticket, but if the ticket has multiple worklog entries (i.e. work on the ticket over multiple days), the ticket shows twice on the report. I've attached a screenshot, you can see 1 worklog entry of 15 mins
Request for Incident Worklog attached to project
Hello I attached some request to a project. Each request has worklog. I would like a request to calculate the sum of worklog time by project Thank you
Custom Query Report from Technician Additional Fields
Hi, I want to report from technician additional fields with their content. Whats should I do? SDP v12.0.07 DB: MS SQL Thanks for helping
Unloading requests for which the decision deadline was postponed.
Greetings. Tell me, please, we are trying to get a report on all requests for which the decision deadline has been postponed, how can this be done?
Change Reports
Hello, Within the scope of the audit, we are asked to report our change processes in the following format. Change ID Change Created Date Change TITLE requester Approval Stage 1. Approval Status 2. Approvers 3. Approved Date 4. Comments
Report Software & Version
Hi, would you be able to provide me with a PostgreSQL report query that will list all machines, and their assigned users, with Google Chrome installed and it's version please? Thanks John
[Free webinar] How to measure the ROI of IT operations
Hello folks, We're happy to bring you our latest webinar on measuring the ROI of IT operations. Date and time: June 2, 2022 2pm AEST | 10am GMT | 10am PST Why attend this webinar? IT is the cornerstone of an organization. IT helps keep business services
Query modification for CMDB relationships report in Asset Explorer
I'm hoping someone could help me modify the below query to add the following columns to the results: CI-Type1 (for ci-name 1) CI-Type2(for ci- name 2) Business Impact Existing query is below select c1.ciname as "CI Name",rel.relationship as "Relationship",
Report
Please find the below format, the report should provide me monthly report of the total status for each technician. Technician Closed Open On hold Resolved Overdue Khan, Afzal 10 20 1 15 3 Ayesh 4 10 2 4 10 Fawaz 12 20 10 5 20
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
Reporting on Custom Multi-Select Fields
Is there a way to report on custom multi-select fields via the default reporting tool or do I need to do a custom query?
Report total amount of time spent on requests and tasks by technician.
Hi Team. I request your support to obtain a matrix report showing the total time spent on requests and tasks by technicians, the database is MSSQL and the current version is 12007. I have tried to generate a custom report but I do not get the time information
Aging Report for Incidents and Service Requests
Hello and thanks for stopping by. I'm probably totally missing this. Is there a handy aging report for tickets? Something like anything older than >30 days? Thanks!
[Free e-book] Kick-start hyperautomation with AI-powered service management
Did you know that you can save anywhere between 10-50% of IT costs with automation? Also, employees can save between 10-40% of their time by automating manual, laborious, and repetitive tasks. IT service processes are abundant with such repetitive tasks
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
Can we have high level Executive Report for Project Statistics ?
Hi Super Team, We looking forward your support to generate for us PGSQL query for high level Executive Report for Project Statistics as Project Bases. What we looking for is have report by the end with below Requirements and details (In attached file,
Tickets Reassigned by Technician
Looking for a query (Postgres) that lists tickets which were re-assigned in the past month filtered by a particular technician. We're trying to determine if a particular technician is re-assigning tickets to other technicians. Layout could be something
Update Report
Hello, I am using this report to generate list of tickets that haven't been updated in greater than 5 days. select wo.WORKORDERID"Request ID", aau.FIRST_NAME "Requester", wo.TITLE "Subject", ti.FIRST_NAME "Technician", LONGTODATE(wo.CREATEDTIME) "Created
An Error occured while creating a report is sdp
Hi, When technicians try to create a report, SDP gives an error like the image below: my sdp version: 11311 my sdp DB : SQLServer
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 % Projects Details Available Per Unites?
Hi Community, We are part of PMO and we looking forward to have below Measurements as Advance Report: (A) Project Details: 1- Project Details Available: If yes will take 100%, if no will take 0% By the end, we will take % Average of Projects with Details
Custom Query Report
Need a custom Query Report with the following: Software Name Software Version Department Computer Name Last successful scan I want to be able to modify the query to change the software Name and Department -Dave
Is There Projects Report for % Tasks Compliance ?
Hi Community, We are part of PMO and we looking forward to have below Measurements as Advance Report: (A) Task: 1- Tasks Assigned to Owner % Average of Tasks Assigned to Owner as per Project. 2- Tasks On time and On-Schedule (Not delay based on Scheduled
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
[Free e-book] 5 reasons why your analytics initiatives are failing and how to fix them using AI
Gartner predicts that 80% of analytics initiatives will fail by 2022. Don't let your business initiatives be one of them. Download our e-book to learn how AI-driven analytics can put your organization on the fast track to success.
Query Report Asset State
Hello, help me add in this query Asset State (In store - In use etc.) User Asset Assigned Thank you SELECT (resource.RESOURCENAME) AS "Computer Name", count(sdatt.attachmentname) AS "Attachment Count", LONGTODATE(MAX(sdatt.attachedon)) "Last Document
Custom report
I need to be able to run reports based on Time of day. Example I need a report with a count of how many calls created from 5pm till 6am for group PCTech last month and last quarter and a 2nd report that Lists the subject of those calls Servicedesk Plus Your
Report of Time Spent for tasks
We would like to know if is possible to have a report of timespend on tasks. We need the following fields: Task ID Timespend Technician Our DB is MSSQL and build is 10530.
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,
Reports - SQL - Concatenate using bar didn't work
Hello team, We changed from version 9416 to 11306 (some time ago). There are some SQL reports that we cannot create because there are some things in the query that are not allowed now. This line is falling (into the SELECT): (ROUND(((WorkOrder.timespentonreq/1000)/3600),2))||':'||(ROUND((((WorkOrder.timespentonreq/1000)/60))
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",
Request Summary - for year
Hi ALL! We have very nice widget "Request Summary" for week/month (look at screen) How i can create report like this with period one year and statistics per month ??
KPI report
Hello. need query report for KPI to calculate mtt responce, mtt resolve
Query to export Organization Roles in ServiceDesk Plus
Hello Support, I am needing a query to export the configurations established in the Organization Roles in ServiceDesk Plus v12000. I am using MSSQL 2019 database. It's possible? Regards, Rafael Vega.
Next Page