Worklog Report
With the new worklogs, I'm trying to get a report together that consolidates the worklogs across all modules from the chargestable. I'm not sure how to get what the worklog was tied to. Here is the data I am looking for: Origin Type (Request, Change, etc.) Origin ID Technician Description CreatedTime Time Spent I am looking to get this data for a specific range - Daily, Weekly, Monthly, etc. I am on pgsql.
Time taken to 1st response & Time Taken from Open state to resolved
Hi, Could you help me with this issue, we need to mesure the response time(= Responded Date-Created Time) in h:mm format, and the Time taken from Open state to Resolved state in h:mm format(=Completed Time-Created Time) h:mm format. The header of report . Request ID Level Priority Created Time Responded Date Time taken to 1st response in h:m Time Spent Executed Time Time taken from Open state to Resolved state in h:mm format Completed Time Technician Requester Request Status Thanks in advance.
IP Address Change Report
I would like to schedule a report which will run once a week to show me the names of any assets which have changed their IP address, showing name of asset new IP address and date/time of change of address. I am not sure how to do this, can somebody help me please?
Can I run a report showing the last login time of my technicians?
I want to run a report to see which technicians are using the system, is it possible to get a report of each users last logged in time?
List of incidents resulting from changes / Report of change related incidents / Incidents associated to change
Dear all I am looking for a report which shows me the numbers of incidents linked/associated to a Change. I have been searching this but couldn't find anything. Can you help me please? I know that you can Associate Incidents to a Change but how can you create a report about this? It would be very nice if the report could show the following attributes: - Change ID - Change Title - Incident ID (each Incident ID seperately in the case when several incidents were linked to one Change) - Incident Subject
Scheduled reports with no data
I like to create scheduled reports that go out periodically for various things and i was wondering if it was possible to suppress reports that contain no data so i am not spamming people with scheduled report emails for empty reports that contain no data. I have tried adding "No data available to generate the report" to my spam filter hoping it would catch the outgoing report and block them but that did not work.
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
KPI on intervention time
Hi, I would like to have a report on intervention time. I use custom report / tabular report / request then I select the fields request id / subject / urgency / priority / created time / completed time / responsed date I would like to have a KPI report based on the elapse time between the created time and the responsed date. The problem is as soon as you add a worklog or close the request, the responsed date is the last action date, but I need the first responsed date. Does someone can help me
How can I view task history?
Currently, to my surprise, Tasks for a Change do not get logged into the History tab. Is there an easy query to view the history of tasks? I am interested to view whether the time/activity logged within the task is reflective of the actual time that the activity in the task was recorded. Future feature: Add task history to the History tab.
Windows 2008 Server SP2
Noticed that there is a Service Desk Plus active icon in task bar on Windows 2003 server. Not seeing Service Desk Plus active icon on Windows 2008 sp2 task bar This is making it difficult to ensure that SDP service is running without having to manually go into the services option on the server to verify the service status. Any thoughts?
Guide for writing scripts and querries
Dear, Is there a guide for writing custom scripts and querries? I am looking to create some, though haven't found any guides. Sincerely,
Worklog Report Across All Modules - With Sum
Hi all, I am trying to create a report which will show all worklogs for this week, which includes worklogs across all modules. I also need to get the task title (rather than the parent title), and need to do both a sum per module as well as a total sum for the week. I have used the example given at the link below as a starting point: https://pitstop.manageengine.com/portal/community/topic/worklog-report This is a great start, but I need to further refine it as above (task titles and sum of time spent
add link for requests id in Query report
Hi all, I create a query report by SQL. I want to add link for requests id. How can i achieve it?
How do I build a Report that includes resources from a Request?
For example - I have a Service Catalog template called "Request Laptop" that users can fill out in the Self-Service Portal. Under "Resources", they can select a 13", 14", or 15" screen size and write in a "needed by" date. I would like a report that shows:
Report: Software and where it is installed
Good Afternoon, One of my Managers is interested in creating a report that will show where managed software is installed. For instance, Lets say we have 3 systems that have Visual Studio 2010 installed. THe report would look something like this: Software Manufacturer Purchased Installed Max Used System Installed On Visual Studio 2010 Microsoft 3 3 3 Laptop1, Laptop2, Laptop3, Is this possible? Thanks. ~James Murphy ServiceDesk 7.6.0 Build 7608
REPORT ON CHANGE SHOWING CHANGE IMPLEMENTER
How can we generate a report on a change implemented by a particular user? We tried with custom reports but there is no column like change implementer. A query can work as well
Technician report
I'm running SD+ woth postgre I'm attempting to setup some reports on a dashboard showing inflow/outflow of requests and I'd like to show: # of tickets in the individual technician's queue # of tickets the individual technician has been assigned/picked
User parameters in reports?
I'm new to ServiceDesk Plus. We're on Version 9.2 Build 9227, planning our deployment to our user base, eventually possibly on SQL Server. In looking at a number of the existing reports, I didn't see any reports utilizing run-time user parameters, nor did I see a way to add parameters when creating a custom report. Is it possible to set up parameters so users can be prompted to enter, say, a date range, or specific Request IDs, etc., at run-time? And if so, is there any documentation for setting
Top Assets based on Incident request
Hello, Is it possible to run a query to get assets lists by number of tickets opened?
how to select requests that created between 18:00 to 23:59
Hi, I need to query report for all requests that created in night shift between 18:00 to 23:59 with these columns: - Request ID - Requester - Subject - Technician - Created Time (Date and Time) - Status Thanks for helping
Amend ownership of scheduled reports
When I create scheduled reports, other administrators are not able to see them, edit them or stop them. This is a pain for clients for whom I have set up scheduled reports and their requirements change over time as they mature. Am I missing something? James Gander Gander Service Management IT Operations and Service Management Consultancy
Technician Login Report
Hi is it possible to run a report on which technician has logged into Service desk in a given week ? The report should be able to pull this data for the last 7 days or 10 days and must show the data broken down on a daily basis. Thanks
Report to show usage of Templates
Hello, Could you please provide a New Query Report sql script that will show how many times each of the templates have been used? Version : 9.0 Build 9032 Many thanks, Lisa
Yearly report of tickets created.
Is there a way to generate a report (bar graph) which will show the number of tickets opened/created by month for the entire year? The closest that I can get to this report is by time created. But doing this casues the bar graph to stop genearting after the first month due to the volume of tickets created in that month. For Example, Im looking for something that can show the number of tickets created by month instead of time, and list this for each month for a total of 12 bars. Then to also generate
How can I run a warranty report showing WarrantyExpiry dates on all resources?
Hi, I am using build 7.5.0 Build 7504 on MSSQL. I am trying to create a report for the following: I want a list of all my resources (servers, printers, switches as well as all my custom resources such as UPS and backup devices) and their expiry dates. I want the date formats to be in English "dd-mm-yyyy" format & not US format with time attached i.e. not 01-22-2009 00:00:00 (otherwise exports & sorting in Excel doesnt work). Or, I'd at least like the report correctly ordered by "WarrantyExpiry"
SDP - User Access report
We expanded our SDP ESM on-site to additional Departments. We would like to be able to track user engagement by reporting on user logins to the site. Is it possible to build a report tracking user logins?
Need to Know if we could track the most commonly used Incident / Resolution / Reply Templates
Need to Know if we could track the most commonly used Incident / Resolution / Reply Templates As this would give us an insight on How efficiently we use our Service Desk and also we could look into other ways of enhancing our performance.
Service Request additional fields in reports, is it available?
I've created additional fields in both Incidents and in Service Catalog. When I create a custom report, and filter on Incidents, I can see the Incident additional fields. When I filter on Service Requests, the Service Catalog additional fields do not display. How can I display the Service Catalog additional fields in Reports? Or am I going to have to only use Incidents for Service Request functionality if I need to depend on additional fields?
Report for Resolved/Completed Tasks Today
Hi! I wonder can I make sheduled report that will display all requests, that have been resolved and completed today It is necessary for IT Director to view not only completed (because not all requesters will close their requests) but and resolved requests. Thanks for you support
Need a way to run a report that shows time a ticket was with a specific group.
Need a way to run a report that shows time a ticket was with a specific group. My build is: 9.0 Build 9039 So they way our team works is that Tier 1 gets the initial request and then they may escalate to Tier 2, then it may go a step further and get escalated to tier 3. I would like a report that shows how long tickets were in each stage. I know it tracks it in the history of an individual ticket, but I can't seem to run a report that would show me this information in an aggregate way for all tickets.
Report with IP address
I want to be able to print a report of workstations with their assigned IP address, I can't seem to find a way. Pls. help.
Report on time taken to assign a ticket to tech
Tickets are created by email and are open and unassigned. I go in an assign a tech to work the ticket. I need a report on how long it takes to go from unassigned to assigned. Any ideas?
Default home page and report editing
Two questions: First, I created a daily report to be emailed, then used Save Report As to create a copy. I then changed some details and the schedule for the copy and made it my weekly report. Problem is, the title (right above "generated by Admin") still shows up as Daily. As far as I can see that's not editable. Anyone know of a way to change that so I don't have to recreate the report just to edit one minor bit of info? Second, is there a way to change the default home page in ServiceDesk for
How To Link To SDP Report Wiith URL?
How can an SDP customer created report be linked to using a URL? ManageEngine ServiceDesk Plus 8.0.0 appears to only provide access by manually navigating through a number of SDP page links: "Reports" (http://hostname:8080/CustomReportHandler.do) | followed by clicking the report name presented on the current reports list. A URL path is needed providing direct access to customer created report. This path can be emailed as a URL link. What is the actual path to a SDP report?
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
Scheduled Report deleted but still sending.
I've got a requests report "Weekly Workload for the web designers" going to two executives, every week. They said they were done with this report, so I deleted it from "Showing, Schedule Reports". The report is still sending apparently. I can't edit the report or the scheduling because it does not exist. I am an SRAdmin and I created the report and the schedule. Any ideas where I can find it, or shut it off? John "You know you've been doing tech support too long when you answer your home phone
Request status times report
I was asked to set up a report that shows the amount of time that a ticket was in each status. Open: How long was the ticket Open until it was set to "In Progress" In Progress: How long was the ticket In Progress until it was set to "Resolved/closed"
Top 10 Report
I need a report that shows the top 10 service requests grouped by category, sub_category for the past month. Has anyone got a similar report I could look at. I have developed a script in MSSQL Management Studio but unsure how to filter dates which are stored as integers. When I run the same query in SDP it does not format correctly. Running SDP 8013. This is my sql script which as I said works OK except it does not filter on dates as not sure how to interpret them. SELECT top 10 ISNULL(cd.CATEGORYNAME,'Unassigned')
Report to show amended Due Dates
Hi I was wondering has anyone created a report to show incidents where the due date has been changed ??? Showing what the orginional due date was and what the new due date has been changed to ??
Need to report on the linked tickets in ServiceDeskPlus
I have created a report (Attached) and need to append to the end of this report (the last column) any tickets that are linked to the ticket in that row and have them be hyperlinks exactley like column D. Can you please provide a modified query to the below that will accomplish that? SELECT dpt.DEPTNAME "Department",aau.FIRST_NAME "Requester",wo.WORKORDERID "Request ID",icd.NAME "Item",wo.TITLE "Subject",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wof.UDF_LONG1 "Hours Estimate"
Next Page