First Response Violated
It is possible create a report of violation of first response?
Assets with scanned IP report
Hi, I am trying to generate a report of all Assets that have a scanned IP. If I do a report of all assets 'IP address' is not a selectable field. Similarly, I can have the IP address field if I make a report on say CMDB > Servers or CMDB > Printers but not on CMDB > All Assets. Has anyone got any idea how I can get this information into a single report? Thanks
Report Assistance Needed - Open Requests + Project Tasks per Tech
Is there a way to create a report that shows all of a techs Open Requests as well as all assigned Project Tasks assigned to that same tech? Thank you for any help you can provide.
Modify report: avg. time spend to close ticket
I've got a report, avg. time spend to close a ticket by group SELECT MAX(qd.QUEUENAME) "Group", MAX(pd.PRIORITYNAME) "Priority", TO_CHAR(((AVG(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "AVG Time Elapsed", TO_CHAR(((SUM(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "Total Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq
First Response Overdue Percent Report
We have been able to generate the data for the proper report, but we then have to import into Excel to create a pivot table with that information. We need a report that is grouped by Support Group and then list the technicians in that group. We would like to use the "First Response Overdue" to generate what the percent of First Response Overdue requests (both incident and service requests) we have had over a period of time. This is essentially a high-level summary report that shows each support group,
Custom Reports for ServiceDesk Plus - Assigned Verses Closing Technicians
Thought this custom report might be useful for a few people. I'm currently working with a Service Manager for an existing ManageEngine ServiceDesk Plus installation. The product has been in place for some time but, unfortunately, the desk has become saturated with open requests. As such the new Service Manager is on a mission to close aged requests, where appropriate. Obviously, there are a few occasions where the local teams need some of the tickets re-opened that the Service Manager has force
Hi I am trying to create a report to show a weekly time report by technician
Hi I am trying to create a report to show a weekly time summary report by technician and need it to include all time logged not just requests. How can I get this? I need time logged to tasks in a project, time worklogs for changes requests, and worklogs for requests.
Report Help - Technician KPI
Hi All, I have the below query for showing the technician KPI for each month ( from this month to this month) SELECT au.FIRST_NAME 'Technician', (SELECT COUNT(wo4.WORKORDERID) FROM Workorder_Threaded wot4 INNER JOIN workorder wo4 ON wo4.WORKORDERID=wot4.WORKORDERID LEFT JOIN WorkOrderStates wos4 ON wos4.WORKORDERID=wo4.WORKORDERID WHERE (wot4.THD_WOID=wot4.WORKORDERID) AND wo4.CREATEDTIME >= <from_thismonth> AND wo4.CREATEDTIME <= <to_thismonth> AND wos4.OWNERID=(wos0.OWNERID)) 'Total Number of
[ERROR] You do not have enough privilege to view this page
I have a SDSiteAdmin technician A. Now this technician A tries to scan for a workstation via an IP. ... and he gets this error message at the URL: "https://sdp2.pvgas.com.vn/NodeDiscovery.do" You do not have enough privilege to view this page The workstation is added to the system but he can not see it because it is not assigned to any site.
Resolved requests report per month
Hi. I need report for resolved ticket quantity per month. Is it possible? And the second, I need the resolved tickets quantity per month by percent. In SLA is written that Rates of resolved requests quantity: 90%. I need this report
Change Report with Associated Requests
I am trying to generate a report on Changes to capture the total amount of work done including work done on associated Requests as well. Testing out to see what work could be shown it does not appear that the report is pulling data from the work logs of associated Requests. Is there anyway to capture this? Build: 9007
How could I generate closure report based on resolved time rather than completed time?
Currently I'm taking the a custom closure report based on the completed time of tickets. I would like to take the same report based on the time when the status of the request changed to resolved from open. That is the resolved time. Any help would be greatly appreciated. Regards, Riyas
generate report with latest worklog
Hi supporter, I want to generate report from Servicedesk including worklogs, however with request have more than 1 worklog inputted I have duplicate request in the report, so I need to generate report with only latest worklog so that I can avoid duplicate of request in the report. thank you ! Tai
Report
You provided me with a solution to query my request: I am new to this and wondered, is there a report that I am to modify or build this from scratch? Thom Please use the below query. MSSQL Database SELECT TOP 10 max(aau.FIRST_NAME) "Requester" , COUNT(wo.WORKORDERID) "Request ID" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID WHERE (wo.ISPARENT='1') AND wo.CREATEDTIME >= <from_thisweek> AND wo.CREATEDTIME <= <to_thisweek> GROUP
Report that will generate
Report that will generate a list of the top five requestors for the day, week or month. Can someone help me with either modifying an exciting report or provide directions of one they are currently using. Thanks
I need first response time report
In my SLA I worte that response time must be max 20 minutes after request creation. How can I generate first response time report? That will show me this info. Thanks in advance.
Report on Dev environment has links pointing to production
Greetings, We have recently created a DEV environment on a separate server. When we run reports on the DEV environment, the links on the report are pointing to the production URL and not the DEV? We did take a copy of the Prod's database to build the Dev so it makes sence for this to occure, however, is there a way to resolve it? i.e. the links on the DEV should go to the DEV URL Both the DEV and Prod are using the same backend Microsoft SQL Server 2008 R2. Thanks in advance.
Latest version of Database Schema
Greetings, Can I get a latest version of the database schema? I searched through this Forum and the latest version I found was 3 years old. Below is the link http://forums.manageengine.com/topic/updated-database-schema Will this database schema provide the relationships between tickets (both incidents and services catalogs) and the templates used? Thanks in advance.
Monthly report
Hi, I want to generate a monthly report. I need the total request (including open, closed,hold and resolved), total closed request, total elapsed time to complete(for closed) and average time taken for one request(for closed). How it possible?
User Assets report
Hi. I wonder how to generate report that show me all equipment that i Saved on current user? What assets does the current user has. Thanks in advance.
Matrix Report - DateFormat: Year/week
Hello Staff, I need to create a matrix report which lists: Categories and SubCategories on the left in rows, and the columns on top are broken down into Year/week. The scope is to show how many tickets (count) are created for each subcategories (and ) on a weekly basis. The wizard doesn't allow me to choose neither DateFormat = Year/week or DateFormat = Week I was wondering, is there a way to do this via ServiceDesk Query Report instead of Matrix Report? or could you give me support to build
Query Error (KPI Technician's performance report)
This query doesn't work in build 8013 for MSSQL https://forums.manageengine.com/#Topic/49000004996363 Error: java.sql.SQLException: Column 'WorkOrderStates.OWNERID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
Report to Ticket Created Time
Hello, I want to create a report to analyse how many ticket created on workdays after 10:00 pm and on weekends after 07:00 pm. The report must be included requester and technician name which could be listed view. Servicedesk Version:8.2.0 Build 8217
error on reports - total value of time spent (request+tasks)
Hi, When I insert the time in task inside request, the time not appear in my reports. Look this example: I put 6 hours associated to the worklog task, and 5 hours in the request worklog directly On worklog detail of request appear 11h (correct), but in my reports only appear 5h (the time insert in worklog of request) you can see in my data filters and the results of report. I need the reports join the time inserted on request worklog directly sum the time inserted on tasks worklog associetd to
Report including History
Dear ME Support I need your help to generate the following report requests created yesterday or in specific period with the following information Request Id Created time requester person who assigned request to technician (from History) time of assignment (from History) time of attendance (from History) time of closing request notes added by technician Thx
Actions menu not visible in request list view when the technician does not have request "Delete" permission.
So we're still having an issue with this, even after the 9001 fix. We are running version 9003 with MSSQL. The actions menu at the top does not display still when the "Delete" permission is disabled. The first picture shows when the technician has the "Delete" box selected from the user permissions, and the second picture is when the "Delete" option is unchecked in our technician permissions. I know this was supposed to be fixed in 9001, but it does not appear it was.
Japanese characters are collapsed on reports.
Dear All, I Installed ServiceDesk plus 9.0 on Fedora 20. Almost functions are works fine, but I have one trouble about reports. Japanese characters are collapsed like below. I think this issue caused that the Fedora does not have fonts. Please let me know the solution. Thank you
Help for a report
Hi, I would like to have the same report like this one (but by group and not by technician). can you help me? Thanks SELECT au.FIRST_NAME 'Technicien', (SELECT COUNT(wo4.WORKORDERID) FROM Workorder_Threaded wot4 INNER JOIN workorder wo4 ON wo4.WORKORDERID=wot4.WORKORDERID LEFT JOIN WorkOrderStates wos4 ON wos4.WORKORDERID=wo4.WORKORDERID WHERE (wot4.THD_WOID=wot4.WORKORDERID) AND wo4.CREATEDTIME >= <from_lastmonth> AND wo4.CREATEDTIME <= <to_lastmonth> AND wos4.OWNERID=(wos0.OWNERID)) 'Total
all software installed on a site Report
Hi there, im looking for a report that shows all software installed in a particular site. is this something we can do? looks odd that you cant select site as a filter when creating a report. many thanks Russ
Work log report by technicians for Requests, Problems, CR and Projects
Hi, we are a small company and in my team we all work on everything, depending on what's happening: Requests, Problems, CR and Projects.Work logs are mandatory. I would like to have a report to pull up all work logs by technician in a certain date range. I need metrics about time spent in different areas. Timespent Report by technician is perfect in structure, but unfortunately it shows only work logs about requests. We are running ServiceDesk Plus 9.0 Enterprise edition. Can you please help me?
Point in time capture of open ticket count
Is there a way to create a report that shows the number of open tickets on the first day of each month? I am trying to show status reports for my team's ability to get the amount of outstanding tickets down, but am unable to figure out how to query a specific point in time. We have MSSQL for the backend. Thanks. Dave
custom query report
Hi, I need to run a report to find out who created all active technicians on our Service Desk Plus We use version 8.2.0 Build 8216. Regards Mario
How can I pull the comments out that I put in when I changed the status of a laptop to disposed?
I have disposed a number of laptops and changes their status to disposed. When I did this I put in comments of who disposed of it and who verified it. I have created a reports of all disposed of assets put can find out how to include the comment field in the report
Changing an Asset
When the SD+ scans, it has classified some devices incorrectly (Workstation as a switch for example) IS there a way to change the asset?
Report on installed software by workstation and user (last logged in would be ok)
Could someone assist me in producing a report on installed software by pc and user. We are running servicedeskplus 8.1 Any advice much appreciated. Regards Craig
Report per month
Hi Guys, Tried already the custom report but cannot get the desired output. Would like to request if you could give me a SQL query on the following bases below, the report should display the: <Technician name> <Group> <# of tickets assigned to the technician per category> <Total number of tickets per category> <Category (i.e., System, Network)> ...the report should display an output per month. Thank you very much!
duplicate barcode
hello i need a report of all assets that have duplicate barcode or serial number
Customising colours in graphs
Hi we currently generate a custom report that shows a table of all requests assigned to a group, with a summary stacked bar graph showing the status of requesters tickets e.g. Bob has 2 open, 10 closed etc. This is showing the responsiveness of a high priority project. It would be good to be able to change the colours on the bar graph. They currently show red for closed tickets but to us it should be green or at least gray. It is good to deal with tickets and have them resolved! Red means bad or
Need Custom Report
I need a customer Audit History report that shows workstation changes matching only certain criteria (e.g. Name Change, software installs) but the only option i see if to report all workstation changes, which is overly detailed. The report shows 44 pages of changes just for a 24 hour period. This is too much to be useful. How can i customize the types of changes and limit to to only certain changes?
Reporting Metrics as a Percentage
Hi All, We use Managed Engine version: 8.2 Build 8205 Has anyone managed to produced metrics reporting in percentages? Looking for easy stats, i.e. Logged with Service desk, percentage assigned to 2nd level etc.. Have been unable to produce these kind of metrics. Help please? Thanks
Next Page