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
BIG BUG with Local Authentication
hello SD guru! Just try it: 1) type your CEO (or other user) login as login 2) type your CEO (or other user) login as password 3) select Local Authentication 4) press "Login" -----> you are logged as your CEO nice? P.S. use login from AD P.P.S. old versions (before 8.1) don't have this bug
Asset report
I need an asset report that will tell me if an asset was updated for the previous day, week, and month. I would like for it to have the technician, the asset name, the asset type, the date modified, the previous state and the current state. Also, I would like for it to be grouped by technician. Thanks in advance!
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"
Scheduled Report Query
We have a scheduled report which has been setup, by whom I do not know, but one of the recipients has left the company and we are now getting delivery failure messages as the report still trying to be sent to them. As I can only see my own scheduled report and I do not want to contact everyone who has the reports feature to see if it is theres, is there some report / query that can tell me who has what scheduled reports setup? If so, it would be really helpful if this could be reported on, as
Next Page