Error reports
Hello good morning: I am a new user and I ServiceDesk has created a problem not solve agradecieria as ayudarn me if anyone knows the solution gener when a report throws me the following error:
request for report. need a report to show incidents against SLA times
been trying to create a report to show if we are meeting our SLA targets as set out on Servicedesk plus
Generate customized report
Hi Team, Kindly help to generate customized reports below: Severity breakdown percentage SEVERITY BREKADOWN PERCENTAGE SEVERITY # OF TICKETS WITHIN SLA BEYOND SLA WITHIN SLA% BEYOND SLA% Summary report per Technician Technician SEVERITY LEVELS TICKETS STATUS Technician CLOSED SEV 1 CLOSED SEV 2 CLOSED SEV 3 CLOSED SEV 4 CLOSED SEV 5 CLOSED OPEN TOTAL 0 0 11 0 0 11 0 14 Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA Within SLA Beyond SLA 0 0 0 0 1
Generate report for only business hours
Hi, I need a availability report (Percentage) which should show only defined Business hours. However i can't find any drag down option to selct the business hours report on the report page. So, i would like to know is there a way to associate this on the report? or it can be generated in different simple ways? I'm using Apps Manager11. Please let me know if any more info required for better clarity. Regards, Karthik.
Change Request Report with Notes
I need a Report for Change Requests with the following fields: Change ID, Title, Requested by, Technician, Priority, Change Status, Vendor Technician, last 2 Notes Added I would like it Grouped by Technician if possible. I can get a report out without the Notes but come unstuck with the Notes.
Group by <column_index>
Hi, In Reports is written: "Group by : Query statement ends with group by <column_index>" What is mean with coulmn_index? BR, userah
XLS Template for scheduled query reports
We are currently running a scheduled query report that e-mails the results in xls format. We would like to be able to specify formating options for the xls file such as column width. Is there any way of specify a template file? Or are there formating commands for the export to xls?
How to add "Purchase Order No." information in asset report
Hi, I am using this query to generate a asset report ( in use workstation report with many informations ) : SELECT MAX(deptDef.DEPTNAME) "Department",MAX(workstation.WORKSTATIONNAME) "Workstation",MAX(workstation.MANUFACTURER) "Manufacturer",MAX(workstation.MODEL) "Model",MAX(state.DISPLAYSTATE) "Asset State",MAX(workstation.LOGGEDUSER) "Last Logged In User",MAX(osInfo.OSNAME) "OS",MAX(deptDef.DEPTNAME) "Department",MAX(workstation.SERVICETAG) "Service Tag" FROM SystemInfo workstation LEFT JOIN
Report Issue - grouping calls together
I was trying to create a report that showed all the open calls for a particular subcategory, in particular all the work log notes. I have the query below which gives me all the information that I need: SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",wotodesc.FULLDESCRIPTION "Description",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",longtodate(wo.DUEBYTIME) "DueBy Time",rc.DESCRIPTION "Updates" ,wo.TIMESPENTONREQ/3600000
report including incident costs
we would like to use the field Incident costs from the work login the reports but We cannot see it. is it possible ?
Attachment image in report
it is possible to add attached image from email column into new query report?
Report for the SLA , Incident management and Problem count
Hi , Can you send me the query to run reports for the attached files. We use Product Name : ManageEngine ServiceDesk Plus 8.1.0 License Type : Registered Version License ID : 219527 Customer ID : 1211-111-0883 Product Edition : Enterprise Thanks Hisham
Report change status SDP
Hi, I need a report that shows me the time between the opening of the ticket and upgrade to a specific state. Help me please. MSSQL Mauricio
Tickets from creation to resolution greater than 15 days for a "support group" and a specific "date range" (SDP).
Hi, Please helpme con this query for MSSQL SDP 8123. I need the following fields: RequestID UserID Title CreatedTime ResolvedTime TechnicianID Item StatusID Thanks a lot!! Mauricio
Internet Explorer
Hi, I need to run a report that shows the version of internet explorer installed on each machine, can you help with this please? Thanks
Ticket report for ticket flow
I am looking for a way to report on tickets that are created by my call center, then passed to the trainers. After the trainers look at it, they pass it to the analysts. The trainers do not edit anything besides the group it is assigned to. We are trying to see how many of these tickets are passed through this way. Is there a way to make a report that would do this?
I want to make a report that shows replies and notes
I want to make a report, that shows me how many of the incidents, (within a specific time frame) have been answered or have added a note by a technician. This because i want my technicians to get better at answering soon and making notes of what they are doing. Does this report exist, i'm not able to find it?
Top 20 items more requesteds SDP 8114
Hi, I need the 20 most requested items with their respective amount within a certain date range. MSSQL Help me wit this report. Thanks, Mauricio Fuentes
time report
hello i would like to know how to generate a report displaying the requests, technicians, and time spent to resolve the tickets and the average of each technician's time to resolve his tickets. thank you
Print Report
How can I generate a report on consumer print ServiceDesk Plus? Att, Epitácio Gomes Support IT Estaleiro Jurong Aracruz
Assign Request to another technician
How we can access the report for the requestes into which Technician is changed due to unavailability of Original Technician
Report request status changes (history)
We need a MSSQL query showing when the request status was changed, for a particular group and a particular request status. Example: Request status was "Open" on 15th Feb Request status was "In Progress" on 18th Feb Request status was "On Hold" on 20th Feb Request status was "In Progress" on 25th Feb Filters: Group = "XYZ" Request status is not "Closed"
Report on service request custom fields
We need to run reports on the service request catalog but it seems that only the common custom fields are available. Why can’t we report on the custom fields there are specific for each service category?
Inline Report with Resolution Field
Hi Guys, I have a report that displays the resolution of a ticket, we update the resolution to track it's progress. As we add more information to the resolution the formatting on the inline HTML report looks terrible. Carriage returns do not show up, so if we enter: [2-15] worked on a printer driver [2-18] replaced the printer [2-20] confirmed all is fixed it will show up like this in the inline report: [2-15] worked on a printer driver[2-18] replaced the printer [2-20] confirmed all is fixed Then
Software count with a specific department grouped by Site
I need a report to show the information below. If Acquisition and Expiration date cannot be shown that is fine for now. Our customer is really focused on number of license purchased and how many of the licenses are being used and how that relates to how many workstations the software is installed on. Software Manufacturer Software Name Department # of times installed # of licenses purchased # of licenses allocated Acquisition Date Expiration Date Site 1 Adobe Acrobat Pro ARMY
Report SDP status "Pending" for xx days
Hi, I need a report that shows me the tickets the previous month that were more than xx days in the "Outstanding customer", "Outstanding Supplier" and "Open" for a specific support group. Required fields are in the same order: Ticket ID (With link to SDP. Only is possible) Creation Date GroupName Technician Requester Title status MSSQL Thanks, Mauricio
Software By manufacturer report (By site or department) ??
I am gathering inventory details (hardware and software across a number of sites on my WAN. Using the report 'Computers by Domain' I am able to selectively report from within my collective inventory by site or department for hardware details. I would like to be able to do the same for software, but the @report by manufacturer' or 'Software Reports - purchased vs installed' do not appear to give me the option to selectively report on the invetroy information gathered for a single site on my
Work log reports
I am looking at how to run a report that will include everyone who added information to the worklog, even if they are not the tech on the issue. I am looking to pull in the following information request number, technician, subject, describtion, requestor name, status, create date, close date and work log
8.1.21 Technicians not populating dropdown list in reports
In the reports module, I am unable to have the Technician list populated in the Advanced Filtering section when attempting to generate a New Custom Report. The Technician drop-down list works in all of the other modules properly. I tried this from multiple computers using IE 8 and Firefox and got the same issue. AFAIK: This feature was working properly prior to upgrading to 8.1.21 Thanks for any insights you can provide, Michael
Notes and Work logs in custom report
Hi I am trying to generate a report for a period of time that include the following fields: Request ID Request Type Requester Dept Urgency Impact Priority Category sub-category subject Technician Group All notes with note editor Work Log However, I was able to include all fields except Notes and work logs fields. So would you help me to generate such report Appreciating your support Thanks
Link on Request ID
Dear, I have following problem: If I create a custom Report then exist an link on Request ID, but if I create a query report then isn´t exist an link on Request ID. See following: Custom report Query Report Thanks in advance!
Time reports for change management
Hi folks, We are just newbies in Service Desk Plus and will deploy the tool in a few weeks. In order to establish a reporting we have customized the standard report functionalities for incident management. For change management we recognized, that there are not really useful standard reports for time spending (at least for us). I'm focussing on the automatically logged time entries by the system itself, not the manual time spent fields like in the worklog-entries threat in this forum. Have anyone
Scheduled Reports SDP
Hi, Is it possible to send more than one scheduled report in one email? Thanks, Mauricio
More scheduled Reports in one E-Mail
Hi, is it possible to have more scheduled reports sent in one Email. At the moment i have to generate for each Report one Scheduled Report that is sent to me via Email. Something like a Dashboard or selecting which Reports should be sent via Email would be good to have. So at the moment i have 6 scheduled Reports per day and i am getting 6 Emails at the same time. One Email with all these 6 reports would be better solution. Thanks. Florian
Closed by technician in a period
My boss wants to extract the number of tickets closed by technician in a period. How should I proceed ?
How to disable the report scheduler?
How can we temporarily disable the report scheduler without removing all scheduled reports?
Survey Result Report
I am trying to create a custom report that will generate the exact same information as the default survey results page "User Survey - Survey Results" or is there a way to export the default survey results page to csv or excel? Thanks
Reports - Category, subcategory and objects in the same report?
Hi! Now I have three different charts, one with category, one subcategory and one with object. I would like to have all this in ONE chart. So my question is if that is possible? Regards Alex
error while fetching response ajax response: id is null
When I try to run a report throws me the next legend: error while fetching response ajax response: id is null A who is this?
Report question
Since SDP has our hours in the database, is there any way to create a report, either with built in reports or via a SQL query that we can see how many tickets are being closed during NON business hours? For us that would be nights after 5, all day Sat/Sun and holidays. TIA Craig
Next Page
