SQL Query for the Report - No of received requests each month
Hi, I've copied the below query into SQL server to create a stored procedure and I am getting 'longtodate' and 'datetolong' is not a recognised built-in function name. SELECT longtodate(wo.CREATEDTIME) "Created Time",wo.WORKORDERID "Request ID",longtodate(wo.CREATEDTIME) "Created Time",wo.TITLE "Subject",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition
Creating Solutions Reports
Whenever we encounter a new error that has a work around, our incident management team diligently adds this information to Solutions as this serves as our KED. Is it possible for me to create a report that will list all of these known errors filtered by the technician that submitted them?
Template with tasks for multiple groups, which group gets ticket counted in report
Dear All, I have a template with multiple tasks for different groups, once a request is opened using this template, the first group would complete their tasks and assign to the second group, and then the third etc. Once the ticket is resolved by a tech. in group three, which group's will have the ticket counted in their reports? From my understanding it will only affect group three, which is not quite what I want(having the last group credited for the request, and other groups having a bad report).
definition of fields
Hi folks, just so I can double-check the work I do on reporting from our ME, are there definitions of all the different fields that deal with time? For example, how do I know what the difference between Time Spent and Time Elapsed is - I think I know, but it would be great to read the definitions somewhere!
Query for count of ticket request mode type per technician
MSSQL
Query tickets created and completed within a 3 day span per technician
Running MSSQL
Report to show requests with no email reply
Is there a report which shows which requests have not been responded to via email? This will also need to include responses made by adding a note to the request and checking the box "Show this note to Requester" Thanks Bruce
Project Management Module Reporting
I see there aren't really any reports for the project management module. What is the easiest way to create project based reporting? I would like to run a report that shows work log details / summary information. Basically I want to see where my team has been spending time. I want to run a report that shows how and where they spent their 40 hours each week. Ideally, I would like to see the breakdown of work log time tracking across not only projects but also incidents, etc so I can see and summarize
Request type not available in a time report
Why is the 'request type' field not available when using a report that is interested in timespent? I want to be able to find the amount of time my technicians are allocating to incidents, services and other 'request type' functions. If I choose a timespent type report I lose the 'request type' field???
Report on Resolver And Closer
Hi, Is there a way of reporting who changed the status of a request to resolved and closed rather than just who it was assigned to at the time of resolving and closing? I know you can report on who created it. I want to be able to have requests assigned to a "supplier" technician but still report on which of my actual technicians owned the call through resolution and closure. Question to other users, what do you do with supplier calls? Thanks
Reports for Project Management
Top level management has gotten on a kick about being informed about every move we make in the IT Department. They are demanding weekly reports regarding information from the IT Service desks regarding Incidents both open and completed. They also want reports about new, ongoing and upcoming Projects. I am wanting to obliged them with weekly reports from Project Management. I am not seeing any kinds of query of Custom Report I can create regarding Project Management. What is the best way to
Unable to create a new solution
Hi, We have recently upgraded to Build 9200, which I have noticed is no longer being advertised on the service packs site? We are no longer able to create a new solution in SD+, we are able to click on the new solution but unable to populate the contents box, we can though populate a title, select topic and fill in keywords. Another issue which has cropped up is the advanced search button on the requests section isn't visible, if we click on the space where the button should be it loads advanced
Query Report Harddisk Model
Dear All, Please help I have crashed harddisk drive and i need to backup data form there. So i need part from another harddisk with same model. Please help to make a query to generate report harddisk model. i have ME SDP 90 build 9023 with Ms SQL database. Thx & Rgd
Interval report in PostgreSQL
Last year I picked up a usefull report from this forum that showed me the number resolved tickets per support group and technician within 4 hours, 8 hours 24 hours, 96 hours, 1 week, 2, weeks and 4 week. Now we have migrated to PostgreSQL the report is not working anymore. Would it be possible to create this report for me in PostgreSQL? Apart from this report I also would like to receive the same report but than with the number of tickets solved with the same interval but without statuses for which
Add additional user field from Users to report
We have added an additional field (UDF) to our Requesters and I need to add that field to a Query Report but cannot find the table where these User USF fields are stored. Can you please explain where to find them?
Active + Archived Requests Report
Can we have report by all active and archived requests (count for each technician) in the last year as one single report. thanks Regards,
Problem running this Query
SELECT solution.solutionid "Solutionid" , KB_Topics.TOPICNAME " Topic",Solution.TITLE "Subject ",Solution.DESCRIPTION "Contents",solutioninfo.noofhits "Views",Creator.FIRST_NAME "Created By",longtodate(SolutionInfo.CREATEDTIME) "Created Time",Updater.FIRST_NAME "Last Modified By",longtodate(SolutionInfo.LASTUPDATEDTIME) "Last Modified Time",Sol_StatusDefinition.STATUSNAME "Status" FROM Solution INNER JOIN SolutionInfo ON Solution.SOLUTIONID=SolutionInfo.SOLUTIONID LEFT JOIN KB_Topics ON Solution.TOPICID=KB_Topics.TOPICID
Require Query on all tickets using one pre-made template
Hello, I am need to run a report on tickets opened and closed that were opened using one specific incident template. Unable to locate a report that can pull from that field within the ticket. Can I get some assistance with setting up a query possibly to complete this? Any help would be greatly appreciated.
Report showing number of conversations/replies
We're looking to identify potential training issues/opportunities at our different departments. To do so, we would like to run a report that lists the number of replies/conversations in a request. Ultimately we would review the average number of conversations for each request category and identify the departments that consistently have a higher than average number of conversations in those category types. There would likely be a training opportunity with that department to reduce the time it takes
Reporting question
Hi All, I'm struggling running multiple queries into a single report, as stated elsewhere there are reports that singly do almost anything you would require but running them together is a different thing entirely. I'm trying to get a report that shows Total calls logged and resolved per month, but also average time spent per call and percentage of completed calls that have met and not violated SLA ideally broken into priority I don't wish to see any request/incident details just purely and simply
Help with Report
Is there a report that will show all calls closed and all calls that were opened for the previous week? I can do a report that will show one or the other but seemingly not both on the same report.
Running this query -- how do I pull it for only specific "groups" and technicians in those groups -- worklogs by technician
Running this query -- how do I pull it for only specific "groups" and technicians in those groups. SELECT COALESCE(wtk.WORKORDERID , wo.workorderid) "Module ID", 'Request' "Module", CASE WHEN MAX(tk.TASKID) IS NOT NULL THEN MAX(wo2.TITLE) ELSE MAX(wo.TITLE) END "Title", CAST(SUM(ct.TIMESPENT) AS FLOAT)/1000/3600 "Time Spent",dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (MAX(ct.CREATEDTIME)/1000),'1970-01-01 00:00:00') "Time Spent Created Time", rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable
Project Query Report on Associated Requests
I am hoping a query can be built to report on the following: A specific Project name where we can view all the associated request ID, subject lines and request status then this requests' associated tasks, task owner and task status Project Name: Request ID Subject Status Task Task Owner Task Status Task Task Owner Task Status Request ID Subject Status Task Task Owner Task Status Task Task Owner Task Status Request
Custom report has no Delete option
Good afternoon, I have created a customer report, and no longer need it. However, I only see the Edit option, not the Delete option as with other reports. Have I configured something wrong? See screenshot attached. Thanks, Diana
User import error
Hi, i have some problems? when im importing users from LDAP. Where can i see detailed information about errors?
Report to display all technicians within a certain Group
Hi Guys, Looking to see if someone can help with providing the query which would return a list of technicians (names only) who belong a certain Group. For example if the group was called "IT Infrastructure Team", would be looking for a list of Technicians names who are members of that group. The Database we are using is MS SQL. Many thanks
Requester report including all fields
Hi, I need to export all requesters from SD Plus and import them into new instance. The link below are good, however, they don't include requesters first name, last name as separate fields Would be great if someone could assist with a query that includes all fields of requester including first name and last name Thanks Ravi https://forums.manageengine.com/topic/admin-report-department-list-requester-list-technician-list-incident-template-list-service-template-list https://forums.manageengine.com/topic/requester-list-1-10-2010
Not able to fetch all the records for last one year
Dear All, Please be informed that I am trying to fetch some reports for total requests created for last one year, however I am getting the data only for last three months. I checked the customisation page and selected the data archive option and set it to get the data from last three years. however ever I am still not getting the data. May I request you to please help and let me know how can I get the data for previous years. Thanks and Regads, Prince Ahuja
Report spanning all request all techs
New here. Tried a few of the reports available in this forum, no luck as it only reports on requests escalated to me and I can't find where to set the applicable dates. I'd need a report spanning all requests by all technicians, not only mine, sorted in a matrix report by category and subcategory for a given date range A to B. SDP v 9.0
help with new report
hi guys. my name is Vadim. i have some issue with creating new report. i need report include next position: - number of incident - who was assign this incident - for someone was assign but i don`t understood what i had to do :( version 9.0, 9003
query report for time between ?
Dear, we use manual to assign the incident to technician, so when the user create the incident it's show not assign ,then when the responsible person receive a notification that new case is open he will assign it to the available technician, so I need report to show me the time between the created case and assign to technician. waiting your support for this. Database :MSSQL Build No.8212
Extract incident templates to CSV
Hi, I want to review all our incident templates quickly (I was not involved with their creation hence why I want to do this the most effective way I can). Can an SQL query extract incident templates into a CSV with field names across the top in columns and their values listed in rows? Running MSSQL Your Version : 8.2.0 Build 8202
Escalation Report
Dear support, How can create a monthly report where only if escalation was triggered (to be specific Resolution Escalation) Request # Due Date Site/Region Support Group SLA Response Escalation triggered Response Escalation triggered time Resolution 1st Escalation triggered Resolution 1st Escalation triggered Time** Resolution 2nd Escalation triggered Resolution 2nd Escalation triggered Time** Resolution 3rd Escalation triggered Resolution 3rd Escalation triggered Time** 35669 04/05/2015
Count number of times reply template has been used
Hi, I would like to find out what the joins are for the reply template. We have a number of reply templates in use by the IT department and they would like to track how many times each type of message is used by each technician. As far as I can work out, the templates are under "ReplyTemplate" and the outgoing messages are under "Notification" but I cannot see how to join the two together. The same issue exists for ResolutionTemplate and RequestResolution. There doesn't seem to be any join between
Query for Support Groups and all details
We are in need of a report that displays all of our Support Group names, description, owner, technicians associated to each group and notifications set (“New request added to group” and “left unpicked”). I was able to run the following but it does not give me technicians and notifications. SELECT ci.CINAME "CI Name",citype.TYPENAME "CI Type",cisite.NAME "Site",ci.DESCRIPTION "Description",ImpactDefinition.NAME "Business Impact",ownedby.FIRST_NAME "Owned By" FROM SupportGroup supportgroup LEFT JOIN
I need to create a time measurement report in SDP for requests in SDP
Hi, My name is Angel Mejia, I´m from Mexico City and in my company we need to generate monthly a new custom report that has, and must get the below information: We have since the beginning: - Opening date of the request - Closing date of the request - SLA time limit for the request We need to get a custom report with: - Total time since opening to closing of the ticket - Total non-operating time (elapsed time in non-operating hours) - Total operating time (elapsed time working hours of
Reports: All Closed Jobs
Hi, I need to run monthly reports on all closed jobs, would someone advise on how I do that or point me towards a resource. Thanks
Report for contract expirations that show a list of attached assets.
We're just starting to use the Contracts module of ServiceDeskPlus. I'd like to generate a report quarterly that shows a list of contracts that will expire for the upcoming quarter, and the list of assets that are attached to each contract. How do I do that? -thx Don
Tickets closed by another tech
I have a situation where technicians are closing other techs tickets as part of a clean up activity. I need to produce a report that shows which technician closed tickets groups by day, who that ticket was assigned to, the date the ticket was created, and who created the ticket. We use SQL server. Thank you. Created Date Request ID Technician Closed by Created by Closed Date 9/1/15 12345 Sarah Lange Robert Jacobs Joe Swanson 12/3/2015
Closed tickets reports
Hello, We currently have two levels of ticket closure in our service desk, a ticket is first put in the resolved state by the technician, and then it is closed by the user, if a ticket has been resolved by a technician but is not closed by the user, the system will automatically close it after a specified period. i need help generating a report that shows all the tickets closed by users and all the tickets closed automatically by the system. can anyone help me with this query? thanks in advance.
Next Page