Service Desk Plus MSSQL query Last Update Time
I'm wanting to see if I can get some help with a SQL query that can add a column showing the number of days since the request was updated. I found the following query below from the forums that filters the database by records. but cant seem to figure out how to make a calculated field that shows the number of days since update. Any help you can give would be greatly appreciated. Thanks Tony Blandin SELECT ti.FIRST_NAME "Technician", wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", cd.CATEGORYNAME
Create a custom report with Request Status
Hi all I would like to seek for help to create a report by Request Status The report will be look like the attached one from my existing Excel file. Requirement: 1. Group by Category 2. Count of uncompleted ticket for last week 3. Count of created ticket for this week 4. Count of completed ticket for this week (it should include those outstanding ticket from last week that may closed in this week) 5. Count of uncompleted task as of this week (or as of print date) 6. Percentage each category among
PGSQL database
Can someone help with a query report for a PGSQL database for the guidlines below? Response time - the time between ticket creation date and the first technician response Resolution time - the time between ticket creation and closure dates Average number of tickets created per day Average number of tickets closed per day
report for Roles and permission assigned in sdp?
SQL query for a report showing the list of Roles and permission assigned each in sdp?
Need help with a report
Hi There, I am trying to report on a couple of things. firstly I need a report that shows the number of calls raised within a given period by mode to the service desk. secondly I need a report that shows the number of calls that have been sent to each group from the service desk within a given period. I am as technical as a teddy bear when it comes to writing queries so any help would be appreciated.
[SOLVED] No reports are generated / Your Version : 11.1 Build 11105
Build Information Your Version : 11.1 Build 11105 Linux / 64 PostgreSQL Server hi help me) No reports are generated What logs should I look at?
Reporting on User details
Hi, I have a couple of report related queries and hope you could assist. Firstly, I cannot find a pre-defined user report and need to create one. We have a some additional fields to be added as well. and it needs to cover requesters and technicians. What I am looking for is sth like: Name Line Manager Department Site City Region Company We also have an issue in that when accessing the technician profiles the field "site" is not available i.e. we cannot amend/correct it. How can we go around this?
Report for Timespent per technicna, per type
Hoping someone has something out there! Can anyone provide me with a report that shows the Time spent Per Technician, pet type? I e, AgentName, Incident Request, Service Request, Problem, Change, Project, Total Agent1, 10:43 10:00 10:00 The date range would be for the previous month. Thanks Dan
INFO on query
I'm trying to do a query to have the timespent on change for every technician I noticed that when the worklog is not associated to a task but directly on the change I have some columns NULL SELECT COALESCE(ctk.CHANGEID , ch.CHANGEID) "Module ID" , 'Change' "Module" , CASE WHEN MAX(tk.TASKID) IS NOT NULL THEN MAX(ch2.TITLE) ELSE MAX(ch.TITLE) END "Title" ,qd.QUEUENAME "Group" ,stg.NAME "Stage" ,sts.STATUSNAME "Status" ,CAST(SUM(ct.TIMESPENT) AS FLOAT)/1000/3600 "Time Spent" ,to_char(from_unixtime(max(ct.CREATEDTIME)/1000),'DD/MM/YYYY
IT analytics in 90 seconds: Understanding technician behavior
Understand the behavior of your help desk technicians and track trends in their performance using the Technician History dashboard in Analytics Plus. If you're not already using Analytics Plus, get started with your free, 30-day trial today:
Report Generate Error
dear Concern Person
Query Report Error with CONCAT function with date parts
I'm working on a query report, and I'd like to have the 'YEAR-MONTH' that the ticket was created. I'm using the datediff function to convert to a date format, because the format of the date fields are not compatible with SQL Server. I have the year and month in the query individually and they compile without issue, but when I use the concat function to put them together, I get an error with the datediff function in the reporting tool. This works in SSMS, so I don't understand the root of this error.
Completed Tasks Report
Hi, I am looking for a report that will provide us with a listing of all tasks closed within the last month. Our database is MSSQL, and please include the following columns: Task Owner (sort by this field) Task Created Date Task Closed Date Task Number Task Title Task Description Task Comments Request Number I have tried to create this report myself, but was unable to get everything working...this code below has many of the fields I am looking for though. SELECT wo.WORKORDERID 'Request ID',dateadd(s,datediff(s,GETUTCDATE()
Report to show all support groups and their technicians?
I am l looking for a report that would give me all the support groups currently configured in service desk plus with all the technicians in those support groups and I would also like it to show the configured group and sender's e-mail address of those support groups. Is that possible or do I have do it manually and go into them one by one?
Audit report by specific workstation name
Hi, I wanna to get audit report by specific workstation name. I need this query DB: Postgres Build: 10.0.13
MTBF – Mean Time Between Failure
I want to find the elapsed time in minutes between two service records of the same item. Can you help me ?
IT analytics in 90 seconds: Complying with project targets
Track your performance against your project targets using the Target vs. Actual Milestone Completion report in Analytics Plus. If you're not already using Analytics Plus, get started with your free, 30-day trial today:
Requests by Ticket Age with Bar Graph
Hello, I'm looking for a postgres report similar to the one linked here, but with a stacked bar graph. We're looking for the following: y-axis: Ticket Count x-axis: Less than 7 Days, 7-30 Days, 30+ Days In the report itself, we'd like them divided by age as section, then each technicians tickets within that particular age range. In other words, each technician would would have their own section listing tickets for each age. Is this possible?
Web DB Visualizer
I'm trying to learn Queries and I'm using the Web DB Visualizer in ServiceDesk+. How do you collapse it when searching through it though? I can expand fields no problem, but if I don't see anything that relates to what I'm looking for I'd like to collapse it so I don't see it. The only way I can is by closing the window and just starting over from the start.
[SDF-22422] Scheduled Reports - Admin Control
Hi there, As admin, I don't seem to have the ability to amend schedules for reports that have been created by another user. It's odd not to have the ability to change this as admin. If that user leaves the business the schedule will continue to exist and not be editable for me. Is there any way around this? Thanks, Dave
Create report and give access to specific users to it
I need to give access to specific users for some reports. Our build is 11010
Query to show all tasks under a Problem
I need assistance to link tasks to a problem. I have the following query so far select taskdetails.taskid'TaskID', TaskDetailsOwner.FIRST_NAME 'Task Owner', Problem.Title 'Problem Title', TaskDetails.TITLE'Task Title', TaskDescription.description 'Task Description',StatusDefinition.STATUSNAME 'Task Status', dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (scheduledstarttime /1000),'1970-01-01 00:00:00') 'schedule start time', dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (scheduledendtime /1000),'1970-01-01
Reports
Hi, We have clients that are using the requester portal and they are asking if they are able to access reports that we have. I was wondering if there was a way to have a reports tab show or an easy way for client to review reports other than me emailing/scheduling report to be sent? Thanks, Jareth
[Free webinar] The secret to delivering exceptional customer service
The primary goal of any help desk is to deliver exceptional customer service. But how do you do it? Join us for a free webinar on February 27, 2020, to learn how you can leverage advanced analytics to: Perform cross-module analytics and get a 360-degree view of your help desk Gather rich and deep insights on customer experience Make faster, better decisions to improve customer service and boost customer engagement Date: Feb 27, 2020 Time: 2pm AEDT | 11am GMT | 11am PST Duration: 30 minutes
SLA violated for certain group
Hi, I have the following query which shoes the sla's violated for all groups but im looking to group on service desk is this possible. Thanks Postgres Version : 9.2 Build 923 SELECT sdo.NAME "Site", count(wo.WORKORDERID) "Total", count(case when wos.ISOVERDUE='1' then 1 else null end) "Sla violated", count(case when wos.ISOVERDUE='0' then 1 else null end) "Sla not violated", case when count(wo.workorderid) > 0 then count(case when (wos.ISOVERDUE='1') THEN 1 ELSE NULL END) *100 / count(wo.workorderid)
Average Resolution Time
Hi Manage Engine Community! I found this very helpful report on the KB section of the PitStop which shows the Average Resolution Time based on Technicians and there was separate one for Group too! MSSQL SELECT aau.first_name "Technician",
convert(varchar(10), (avg(wo.resolvedtime)-avg(wo.createdtime))/1000/3600)+':'+convert(varchar(10), ((avg(wo.resolvedtime)-avg(wo.createdtime))/1000)%3600/60)+':'+convert(varchar(10),(((avg(wo.resolvedtime)-avg(wo.createdtime)))/1000%60)) "Avg resolution
SDP ESM (build 11100) report to see what assets, licenses and software are assigned to a user
With the schema and table changes in the underlying database can we get some help in creating a report that shows what assets, licenses and software are assigned to a user? It would be great to have a place to specify the user even if we have to edit the report for each user.
Query Report
I am running the below query, but the last two columns do not display with the title Subcategory and Item. Also, the item category is not displaying the correct description, it is displaying the Subcategory description. After the query is a screen shot of the results when running the query in ServiceDesk, the second screenshot is the correct data when running the query in SSMS. SELECT WorkOrder.WORKORDERID ,SDUser.FIRSTNAME ,SDUser.LASTNAME ,WorkOrder.TITLE ,workorder.DESCRIPTION ,RequestResolution.RESOLUTION
Report Request - Opened, closed and backlog
Commented on another post, might be simpler to keep separate - report request please. MSSQL 9.2 9227 Ultimately, I just want a report that shows for a given period: Tickets Created in period = (Created Date in period) Tickets Closed in period = (Completed date in period and any value for created date) Current Workload / Backlog of requests = (Any Creation Date but Status not equal to Closed or Resolved) And this data split by current support group. Thanks in advance
Need a report to show all PC's less than 8 GB of Ram with how many memory slots are used
I'm looking for a report to estimate costs. I need a report to show all PC's with less than 8 GB of Ram with how many memory slots are used running Windows 7.
[SDF-56484] Scheduling reports - Based on data availabality for the report.
Hi , 1. We have a few scheduled reports that is intended for reminding the technicians/ users to change the status of the tickets to appropriate Status. 2. Irrespective of the tickets avaialable as per the set conditions in Scheduled report, the mail is forwarded to the mail IDs as updated in the scheduled reports. For eg: even if there are no tickets for which action is to be intiated, the mail is forwarded with NIL data. 3. Can you pl let us know, if we can curtail forwarding of scheduled reports
Add attributes to a CI relationships' report
Hello, I am doing the following query to get a report that show me all the relationships of a CI, but I need to add some information and I don't know how to do it: how can I add columns of differents attributes of the main CI? how can I filter just to get the the relationship of certains "relationship rules"? select.ci.ciname as 'Nombre',(select rel.RELATIONSHIP+' '+ci2.CINAME+CHAR(10) from cirelationships as cirel left join ci as ci2 on ci2.ciid=cirel.cii2 left join relationshiptype as rel on rel.relationshiptypeid=cirel.relationshiptypeid
Report Format
Good Day I have noticed that reports in ServiceDesk Plus are not created in the A4 format. When I export them for example as a PDF, I am facing problems with printing them since the format is not A4. Is there any possibility to change the format of reports? Thank you very much!
Emails in a Request
Hello Team, I have the list of Tables that are present in our ServiceDesk Plus database. What I'm trying to do, is to get a query report on the list of email exchanges thats contained within a Incident Request. I'm not able to find the table which will have this information, requesting your inputs here.
IT analytics in 90 seconds: Track your performance against help desk targets
Measure resolution rates against help desk targets to identify how far you're off target and improve overall resolutions using Analytics Plus reports. If you're not already using Analytics Plus, download your free, 30-day trial today:
PostgreSQL Custom Query for Specific Software plus IP, Site, User, & Assigned User for AssetExplorer
Happy Holidays All, I have a custom query that provides a report of Assets that have a specific piece of software installed. In this case it is "MPLTransact". It works but I want to add Site, IP, User, & Assigned User to the Report but can't figure out how to get it to work could someone assist? Here's what I have so far... ====== SELECT SystemInfo.WORKSTATIONNAME "Workstation", max(state.DISPLAYSTATE) "Asset State", max(osInfo.OSNAME), (SoftwareList.SOFTWARENAME) "Software_Name", MAX(swmfg.NAME)
Service Desk Plus - created requests by hourly time slot
We are working on a global 24/7 roster and need a report to show us when requests are logged by hourly slot. So for example I want to see something like this: Is this something possible in SD+ ?
Report about all relationships in CMDB
Hello, is there any way to get a report about all relationships in the cmdb in version 9207 with PGSQL? Maybe as a table like: ci type ci name relationship ci type ci name workstation pc 1 connected to router router a workstation pc 1 related to requester requester a ... ... ... ... ... This would be a great help for me - thank you very much for your help! Best regards Michael
(SQL) report on open Tasks
How would it be possible to create a report on the open tasks in SD+ 7.6.0? via SQL? If so, thanks in advance for an SQL query best regards, Marc
IT analytics in 90 seconds: Managing project delegation the right way
Easily keep an eye on project delegation using the Milestone Ownership report in Analytics Plus. If you're not already using Analytics Plus, get started with your free, 30-day trial:
Next Page