problem with install service desk linux 64 bits
Hi.... I have a problem when i try to install the service desk in a machine that have SO Ubuntu Server 10.04 TLS 64 bits, i put in the terminal the next secuence comands chmod 775 ManageEngine_ServiceDesk_Plus.bin ./ManageEngine_ServiceDesk_Plus.bin -cAfter that, it should been continue with the installation, but contrary to this, it returned to the promp ana@ubuntu:~$
custom fields
Is it possible to get a report with custom fields defined for a specific service in the service catalog? thanks
Monthly Report - Closed and opened requests
Hello! I am somewhat capable when it comes to simple queries, but working with multiple joins, etc, I start to get lost. I am looking for a monthly report that produces the following for <Last_Month>: --------------------------------------------------------- | Site | Category | # Opened | # Closed | --------------------------------------------------------- This report could group based on Site and Category to produce a matrix, or it could just be a tabular report. Any help would be greatly appreciated!
Converting Field MM2COMPLETEREQUEST
Hi there. I'm trying to convert, in a Microsoft Sql Server 2008, the field MM2COMPLETEREQUEST from table RequestCharges using the following command but it does not work well. Look: SELECT RC.MM2COMPLETEREQUEST, DATEADD(s,RC.MM2COMPLETEREQUEST/1000,'1970-01-01 00:00:00.000')FROM RequestCharges RC WHERE RC.WORKORDERID = 3887 the result is a date in the year of 1970, but the correct is 2011-12-27 900000 1970-01-01 00:15:00.000 7200000 1970-01-01 02:00:00.000 My question is: What I need to do to
Report on contracts and machines
Hi, I'm looking to generate the two reports below but not sure where to start! Would one of you guys be able to help? The report needs to include:- (I) List of all workstations & servers with a contract (ii) List of all workstations & servers without a contract ...and includes these fields:- - User - Department - Workstation (name) - Model - Serial number - Contact From Date - Contact To Date - Contract Status (Expired/Active) - Acquisition Date (if possible) It would be really useful if you could
Report showing 'time spent' above and below 15 minutes
Good Morning, I would like to create a report that shows out of all requests logged (last week) how many of them were closed in under 15 minutes and how many were closed in over 15 minutes. It would be great if I could also get a bar or pie chart to represent this data. Many thanks
Software report
I have found a report that return software and the site. https://forums.manageengine.com/topic/workstations-with-a-software-order-by-region-and-site what i need is to return the workstation owner. and neglect the siteid, and the laptop check as well.
Help with some queries Total work log time
Hello, I m trying to build some MySQL queries around the incident requests could you please assist : 1- a query that can be ran weekly and get the sum of the tech time elapsed for all the tickets worked ( weekly total for the last 4 weeks ) 2- top five ticket for specific techs that contain the highest total amount of work log time for the last 6 days 3 - top 5 categories and number of tickets for each cat for last 6 days 4 - total amount of ticket worked the previous week (all tickets with work
Graph Color Cutomization
Hi, A good day to you ! Is there a way to customize the color of the graphs to match a criteria ? Thanks, Jon
SLA report
Hello, today when I take a report of an SLA field OVERDUESTATUS chart created by the report is shown as figure attached. I wonder how I can change the color red (isoverdue = false) to blue and blue (isoverdue = true) to red. Thus the colors represent the best number.
Hyperlinks in report
Hi, When I run a report in ServiceDesk, I see hyperlinks to requests. Can I add hyperlinks to my own query report? Regards, k.
Custom Report - calls assigned to a Group by a Technician
Hi, I would like to run a report that shows all calls assigned to a particular group, by a certain Technician, in the past month. Please let me know if you need any more details.
MSSQL query - help needed
I have the MSSQL query: closed requests with group "Analityk HD", mode "WebForm" or "e-mail", with more than one change of priority. It works fine in SQL Server management Studio, but it doesn't work in ServiceDesk 8.0.19. query: SELECT CAST( SUM(A.changeonly) as FLOAT ) / CAST ( SUM(A.total) as FLOAT ) * 100 '% zgłoszeń z wielokrotną zmianą', A.FINALDATE FROM ( SELECT count(DISTINCT WO.WORKORDERID) changeonly, 0 total, CONVERT(date, dateadd( s, CONVERT( INT, FLOOR(wo.COMPLETEDTIME/1000) ),'1970-01-01
Create a Query Report Showing Approved and Denied requests and who approved/denied them
Hi My compliance department has asked if we could create a report once a month for them stating what requests their team has approved or denied. I have had a quick look through the forum and found the following script to be perfect, apart from the the fact that it will not pick up who approved the request, stating N/A in each occasion. So basically I need the report to list * Request ID * Title * Requester * Request Date * Approval Status * Approved By On a monthly basis. I believe I need to ask
Creating New Query Reports :)
Dear Team: I need a Query report on how long a request takes to go from unassigned to assigned and how long it takes to go from assigned to Compeleted . Available Columns : Requester,Technician,Subject,Category,Priority,Created Time,Assigned Time,Completed Time Filter Options : Date Filter from xxxxx to xxxxx Group by : Technician time summary type : Average of (Time Spent from unassigned to assigned ) and then (Time Spent from assigned to Compeleted ) Please Help me Regards N.M
Reports on Categories
Is there a way to get a reports on categories that have never been used?
Report against archived requests
I need to produce some historical stats. We have setup our SDP archive to auto archive anything clsoed once its a year old. Consequently everything from prior to Nov last year is in the archive and I cannot get any of these archived calls to show under normal reporting. Should I be able to simply use the reporting button options to report on archived calls, or do I need to write a special query ?
Service Catalog: Dynamic Approvers List in Workflow
Hi! Hopefully, this has not already been asked. I have created a new "resource" field in a Service Request form called "Manager E-mail Address". Is there anyway to use whatever the requester enters into this field as the Approver in the Workflow? I know right now, you have to preset the Approver list but as different requesters have different Managers, we can't use a pre-defined list (and of course, we don't want to send to all Managers for approval for one requester). Thoughts/suggestions?
Reporting on the history tab
Will it ever be possible to run reports using the report wizard rather then the query report on the information supplied on the history tab?
Time Spent Report -Graphic
I need your help, with a Custom Report that I did create.My report is a Time Spent Report. And I am Grouping by Sub-Category. I will send you all screen shots necessary. My question is related with the Graphic. Because if you check, it is using the number of records of the Report to create the statistic, instead get the numbers of Hours Spent. For example:For Issues/Errors: We have 39 hours Other: 2 hours Scheduled Prevetive Maintenance: 49 hours. But the graphic is not being created,
Weekly Forward schedule of change requests
Is it possible to prepare a report for "Weekly Forward schedule of change requests", i.e., Change Requests scheduled from the current date & time to 7 days ahead. The current date & time would be the time when the query which would be running. My database is MySQL and my build is 8003 Thanks in advance
Report capturing Technician License Information.
I have pasted the excerpt of an email from one of the Customer. Please point out the specific SQL queries if it is already identified. Is there any possibility that you can provide me with a sql query with the following information to assist me in managing our technician licenses? I need the following: Technician Name Date Created Active or In Active Date or history when it is changed to inactive. Technician created by Whom. - Umanand. ManageEngine IT360 Team.
Service Desk Shift Reports
I would like a report that shows Service Desk SHIFT activity. This would require a report for Serivce Desk technician shift times. i.e. The following DATE: October 20, 2011 Shift: 6am - 6pm Technician on-shift: Joe Smith Incident requests: 0pened: 23 Resolved: 12 Assigned: 11 Service requests Opened: 18 Resolved: 12 Assigned: 6 Critical or High Priority: Inident # 37129 - Email exchange server down - Curent Status: Resolved Incident # 37143 - Executive area
Technician reports
IS there a way to generate a report of the days/times that technicians log on and off the service desk?
Logged in technicans
Hi, Can I please request an updated version of this report: http://forums.manageengine.com/topic/technicians-logged-in To work with version 8017 of ServiceDeskPlus. The report would show the currrently logged in technicans. I am using the MySQL database version. Regards, SDP-User.
Change Management
Who will assign a change request to Technician in "Change Management".
Report to show how many tickets were take in and closed that day
I'm trying to figure out how to generate this report/graph that would show the amount of Incedents taken in and closed that day. Thanks
Creating Report with Asset & Change Details
Hi, I want to create a report where it will display the Asset Name and also the Change Details (found in the Asset category under Requests). Is it possible? Example: Server Name Change Details Completed Time ---------------- ------------------ --------------------- server1 Applied Security Patches Nov 3 2011 Thanks
Does we calculate how much time the request is on Hold?
Dear Team, Does we calculate how much time the request is on Hold? Regards, Vaishali
Time Spent per Department pie chart
I have setup a Matrix using TimeSpent to look at time spent per department, but I'd like to turn this into a scheduled report with a pie chart, however the chart only appears to count the number of requests rather than the time spent on those requests. Is there a way of achieving this without running the data through Excel? Assuming it can be done in Excel, I haven't tried.
custom reports with technicians that has worklogs less then 7 working hours
Dear support, one of our clients reported that they need advance report about their technician activity. Please give recommendation, if you know how to help in this questions, because i cant find the way how to complete this task. Main statements: Company has 8 hours working day. If technician has !less then 7 hours !in worklogs during day period - then it should be +1 in report. Totally report should be during last month. Example: Michael - +5 because 5 days during the month he has problems with
Automatic Close stopped working after upgrade
Currently running 8.0.0 Build 8017 Requests are set to close after 2 days, however this automatic rule has stopped working .. It seems to have stopped working since upgrading to latest version of ServiceDesk plus. I've confirmed under 'Request Closing Rules' that the 'Close Requests After' is set to 2 days, however requests that were resolved on Friday (04/11/11) are still sitting at 'Resolved'. Thanks!
How can I export the scanned software list or run a report that lists all the scanned software?
Brand new to Service Desk; we have version 8.0.0 Build 8013. I would like to either export the list of scanned software or run/create a report that does? Can anyone assist. Thanks.
Report on Requests Resolved/Closed by a Different Engineer within time ranges like 1hr, 4hr ,8hr etc..
Dear User, Please find the query below to generate on: "No of calls resolved or closed by the a different engineer within - 1hour, 4 hour, 8 hour, 12 hour, 24 hour, 2 days, 5 day, 10 day, 20 days, 30 days, 45 days, and more Grouped by Impact" Tested in : MsSQL (SDP 8016) ,if you need any clarification please get back to us. Note : Please change the Date filter (marked in Bold Blue color) as per your requirement SELECT Impact.NAME 'Impact', SUM (CASE WHEN (WorkOrderOperation.OPERATIONTIME
How can I export scanned software list or run a report that list all scanned software?
New to service desk; we have version 8.0.0 build 8013. I'd like to either export the scanned software list or ideally run/create a report that does this? Any help would be appreciated. Thanks.
Common requests report in the Service Desk system
Dear all, How can I generate a report from the system that can help me in knowing the commonly created requests/incidents in the system? This report will help us in deploying necessary resources in handling common requests and even plan. I cannot see a standard report in the system that can help in me in getting this report. Your assistance will be appreciated. Regards, Davis M Onsakia
Reporting and access rules
Hi, If I understand well, report are either public or private. But is there a way to limit access to one report to a group of technicians ? Best regards, jeff SDP+ 8016
Automated report for open calls for technician
We are wanting to create a report that allows us to send to each individual technician the calls they have open in Helpdesk, the report should only list calls related to the individual technician. Is this type of report possible in SDP, apart from having to create an individual report for each technician? Thanks, Matt
Report help
is there a way to create a report for incidents based upon the time the request was created that shows what time of day the request was opened not the date we are looking to see what our high call volume times are and when our low volume times are for example. something similar to below we are looking to how we should staff our service desk for the best coverage August 00-01 4 request 01-02 0 request 02-03 0 request 03-04 1 request Etc.... Sept 00-01 4 request 01-02 0 request 02-03 0 request
Request Revision History
Anyone know a method to view the complete revision history for a particular request entered in the Support Center? It doesn't seem to capture this information for auditing purposes. Thanks!
Next Page