Pending request
Hi. I need to have a report for each request pending time. How can i do it? It is very important. Best regards
Changing Column Width on Custom Report
All, I have created a custom report in Service Desk Plus and would like to change the column width of 3 columns. I have not seen a way to do this for only one column. Can someone point me in the right direction? Thanks, Matt
Several Schedule reports in one mail
Dear All, I working since one year on Service Desk Plus with satifaction. I created several reports for the management I would like to know if there is a possibility to have in one mail multiple repports generate from the Custom reports in place of one schedule mail by reports.
Not send mail
hello, no notifications are sent, SMTP settings are correct, port 25 is open. Sending logs: [22:20:32:329]|[01-15-2014]|[com.adventnet.servicedesk.notification.action.SDNotifyAction]|[SEVERE]|[36]|: Exception while trying to send notification for Request ID : 7|com.adventnet.servicedesk.ServiceDeskException: Mail sending failed. at com.adventnet.servicedesk.notification.util.NotificationFactory.sendMailNotification(NotificationFactory.java:1298) at com.adventnet.servicedesk.notification.util.NotificationFactory.sendMailNotification(NotificationFactory.java:770)
Report - Mac addresses
HI I am wanting to do a report thank includes the machine names and the mac address for each machine name. How can I do this?
How to report Workstations that do not have a particular software installed.
Need to find a way to report workstations that a particular software is not installed. example: all workstations need timeclock.exe .. want to find workstation out of compliance. Suggests please!
Report - Time Spent by Technician Showing Sum of time Spent
Hi, I think this should be a simple report to produce but I can't find any way of making it work. Simply put I want to see a sum of time spent on cases by technician in a pie chart. However much I try I can only see a count of the cases rather than the time spent. Is it possible? Today is the first time I looked at the reports feature. As an engineer I was hoping to avoid such kind of work. :) Regards, Robert
Reports: Field format changes when saved with Query editor?
We are using SD plus 8.2.0 Build 8212. in Reports, I run a report thats get formatted as expected. When opening the Query editor for making an adjustment to the Query, the Query editor mess up the field format for one particular field. Please note that this happens as soon as I save the Query regardless if I make any Changes or not. I discovered this while trying to modify a specific fields number formatting. This is the Query thats works fine in SD plus as long as I dont re-save it in Query editor
No Time spent or work log entry on closed Requests or changes
Hi, I am looking for a MSSQL query that would show me what changes and requests were closed (within last quarter) with no time spent or work log entry. If someone could help me, that would be great. A consolidated report would be the best but having this in two (one for changes and one for requests) would work as well. Jamie
Asset Report for Failed Assets
I would like to have a report that shows all workstation(s) failed during last scan. Report will show all Assets that contain Error Message details of list of failed assets. Thanks.
Time spent report grouped by support group
Good morning, We are trying to run a time spent grouped by support group. Specifically, we are looking for a report that shows the time spent on "On-Call" tickets (designated by the on-call checkbox in the ticket) but broken down by the tech support group vs the technician. Is there a way to do this? So far I've only found how to group it based on the tech, not the tech group. I'd love to be able to create this with the built in report creator, but I'm guessing it will have to be a scripted report....
Incident Management Three Phase Report(s)
Hi sdpTeam I broke down the Incident Management process into three phases. I’d like to have some information in reports for these three phases. Can you build one or more query to get this information in reports? I – Registration Phase · The total number of requests and the average time, per week over the last three months, it took from the moment a request was created to the first time it was assigned to a technician. II – Recovery Phase · The total number of requests and the average
Can't start SDP 8.2
Help me plz. I did Install SDP 8.2 with not MSSQL.When i run ManageEngine ServiceDesk nothing happens. run CMD as Administrator: C:\ManageEngine\ServiceDesk\bin>run Could not locate C:\ManageEngine\ServiceDesk\bin\\run.jar. Please check that you are in the bin directory when running this script. Press any key to continue . . . C:\ManageEngine\ServiceDesk\bin> help plz.
time series report - closed/open at each month
Hi, I am trying to create a report that will graphically represent the number of open and closed tickets of each month for one whole year. For example January: open 30 closed 420 February: open 21 closed 320 Where my current report fails to show at the end of each month the number of active incidents. I have added a screenshot and the query SQL Query SELECT wo.WORKORDERID "Ticket ID",cd.CATEGORYNAME "Category" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT
repeated groups and departments when generating reports
i'm getting repeated groups and departments when generating reports
Custom Report with Tech Last Update Time
Hello, I was wondering if anyone could help me out on a report. What I am trying to do is write a report that is emailed daily that shows all tickets by tech that were not updated today. My trouble is on the Last_Tech_Update column is stored as a bigint and not as date/time and I can't figure out what the conversion from "today" to that format is. Example: 12/23/2013 comes out as 1387785600000, how do you get that? Thanks, -Rob
Dashboard Request Summary Report
I like the Dashboard Request Summary graph, but would like this graph using a specified date range, i.e. weekly or monthly figures over the last year? How do I create that?
Monthy Survey Results Report
We are looking to create a monthly reports that generates the Survey Results average by Question. I was able to generate this using the quick matrix report generator, but the system default seems to use zero decimals, which creates skewed results. Is there a way to change the decimal accuracy default or at the report level? Or is there a Query report that can be generated monthly to report last month's survey results average by Question?
Report All Request where Technician is the same person of Requester
Dear all, I want a report where the Technician is the same person of the requester. I try with this but the i have a strange result. can we help me? SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",qd.QUEUENAME "Group",ti.FIRST_NAME "Technician",cd.CATEGORYNAME "Category",pd.PRIORITYNAME "Priority",wo.TITLE "Subject",LONGTODATE(wo.CREATEDTIME) "Created Time",LONGTODATE(wo.COMPLETEDTIME) "Completed Time",std.STATUSNAME "Request Status",ApprovalDetails.EMAIL "Approver Email",LONGTODATE(ApprovalStage.SENT_DATE)
Request for a weekly report
Some sort of dashboard that can be reviewed weekly that would show the following: Total number of tickets open for a support group (example network team) Total number of newly created tickets for the previous week (ex. 50 tickets generated for network team from Oct 27 - Nov 2) Tickets resolved for the previous week by support group Tickets resolved by engineer in support group Tickets overdue for support group
Need report to count up QoS in SLA
I've got Qos formula it's (100-(0,1*number of failed requests low SLA+0,3*number of failed requests normal SLA+0,6*number of failed requests high SLA)*100/(0,1*number of success requests low SLA+0,3*number of success requests normal SLA+0,6*number of success requests high SLA)))/100 and it needed to be in section of sites, and another one in section of technicians it would be like: 1. general report: qos is 0,96 2. site report: site 1 - qos 0,96 site 2 - qos 0,98 site 3 - qos 0,94 3. techinicians
another tricky query report to build
I want to produce the all important "capitalize labor" report. (This would be a time spend report, but needs to UNION with tasks?) The report would do the following: For all tasks during the defined time range (say this month or last month), that have a task TYPE of Development (in our specific case, "DEV: Sprint"), pull in the total time spent on that task and report it on the report. This is tricky (but possible) because it needs to combine time spent with attributes of the task to determine
All Request by department
under the report by all request. Request by department. stack on request status. Report is showing. OPEN ONHOLD RELOSED OTHERS. What is the RELOSED and OTHERS.
Report with Jobtitle and User group
Hi! I would really like to be able to user the fields Jobtitle to make reports. Can this field be programmed as a variable I can use? Same thing with User Groups, it would be great to be able to make a report on a specific User Group. Best regards Andreas Karlsson, Knowit
How can we see the history of a resolved ticket?
A ticket usually has a lot of history. In history tab of the ticket, it has the details of the technician(s) who has worked on the request. Like, the ticket has been assigned from technician A to technician B and to C.The history tab of the ticket shows all the details of the technicians who have worked on the request. When we take a report showing the resolved tickets, is there a way to see all the history of a ticket in the report. Please help... Thank You Kind regards Harshan
Notification of SLA violation before it occurs
Notify technicians at a pre-configured interval before the SLA is violated.
Add feild to Available Columns in custom Report
Hi. In the reports tab, how to add more columns in the "Available Columns"?
current status reporting
Hello; I am attempting to create a report to snapshot the number of request IDs a certain technician has 'now', and in what state (open closed etc). I can do this with SQL but this report is for an end-user with report access, they want to be able to change some of the filtering without having to resort to changing the SQL. However, the time filter within SDP's reporting tool doesn't seem to allow a 'snapshot' - only over various durations. Regards Alistair
technician evaluation report
hello i would like to have a report to evaluate the technicians in my company, so i came up with these indicators and if you can suggest more number of requests by technician (3 fields : open, onhold, resolved) percentage of resolving requests in the assigned period (average percentage of requests resolved on time) average percentage of the survey results related to each technician number of requests onhold without reason (no tasks, no reason for stopping timer, no approval pending,....)
Query report help
All, I have the following Query report that works ok, however I would like to amend this so that if the relationship type '31' is missing, the query will report a NULL/default value? Can anyone help to point the way on this? Many thanks Lorraine SDP Build 8200, SQL Server2008 SELECT wo.WORKORDERID "Request ID",wo.TITLE "Subject",rtdef.NAME "Request Type",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",aau.FIRST_NAME "Requester",pd.PRIORITYNAME "Priority",longtodate(wo.RESPONDEDTIME)
Report - Requesters mail with active contracts
Hello dears, I would like to create a reports with this information: --> Requesters mail with active contracts It could be in a .txt file or a Select on my database, wherever... thank you
Status Change Report
Is there any way to get report in following format: SD# 1234 PERIOD From Date To Date STATUS 30/09/2013 10:07 PM 30/09/2013 10:10 PM Acknowledged 30/09/2013 10:07 PM 1/10/2013 20:10 In Progress 1/10/2013 21:07 1/10/2013 22:10 OnHold 1/10/2013 22:07 1/10/2013 22:24 Open 1/10/2013 20:07 7/10/2013 23:10 In Progress 7/10/2013 22:07 7/10/2013 22:34 OnHold
Configuration Reports
We would like to see configuration reports made available through the reporting module. Some examples are reports we could craft for the requester table data, products for the purchasing module configuration, and vendors for the purchasing module. Thanks, Craig
working with POs
Hi Team, I need to make some small changes to closed POs.....mostly to adjust some GL coding. How can this be done? Thanks David
export user's request to file excel
i use ManageEngine Servicedesk Plus to manage all computer problem in clients. Everything is ok but i want to export all user's requests to file excel or pdf ( the requests containt subject, requester name, assigned to, date and status). Please show me how can i do that? Thank you very much
Problem for add Filter showing
I have a problem to add a filter showing when I go into admin and request option - addiotional fields I create the label and it does not appear in the filter showing to add a filter name. Would anyone help me?
Cost Report
how I can make service cost report for any assets (laptop,server,...etc). I need to make cost report for all assets or specific assets.
Report identify duplicate Service Tag entries
Is there a report or does anyone have report to identify assets in the system with duplicate service tags?
Incomming vs completed incidents
Unable to generate a graph with incomming and completed incidents that displays the colums in correct date order.
Changes starting in the the next two weeks
Hi all, I need to write a custom report that shows all the changes who's scheduled start date occurs within the next two weeks. I can't do this with the custom report tool as it wont let me choose a variable date in the future. Is there a way, using the query editor to write a report that will always show the changes that are scheduled to start in the next two weeks, regardless of the day it's run? Thanks in advance.
Next Page