Need a custom asset report
I need a report with following fields. Is it possible in SDP ? Computer Name Current User Department Previous UserWhat I could make is with only first three fields. I could not insert 4th field in the report. Any help would be appreciated. :) Thanks
Report on assets relationships
I'd like to realize a report showing the relationships between assets/resources. let's say for instance I want to see all the objects (software, hardware, components, etc) linked to a given asset (i.e. a specific software or server). is there anyone who has already tried to get this?
Depriciation report
Hi Does it possible to get report for Depriciation value of Asset of Current year. Year/MonthDepreciation($)Accumulated Depreciation($)Book Value($) Remaining Life 2009 4166.67 4166.67 45833.33 4 year(s), 7 month(s) 2010 10000.00 14166.67 35833.33 3 year(s), 7 month(s) 2011 10000.00 24166.67 25833.33 2 year(s), 7 month(s) 2012 10000.00 34166.67 15833.33 1 year(s), 7 month(s) 2013 10000.00 44166.67 5833.33 7 month(s) 2014 5833.33 50000.00 0.00 0 month(s) Consider the above example Purchase year Purchase
Time Spent Reports not working in 8.1
Hi, I upgraded to 8.1 on Friday. When I run a time spent report there are no values in that column. Attached is a screenshot to demonstrate. There appears to be one request which has a value but other than that all the times are wiped. Please Advise
Report for which technician added users and how many
I was wondering if there was a way to generate a report that would tell me which technician added new users and how many they added over the past month. I am on 8117 with mssql. Thanks in advance.
Report to determine who entered a request...
Hi...I'm trying to audit the use of our tech accounts. We have some "techs" that are responsible only for entering tickets, not resolving them. Is there any way I can get a report of the tickets entered into the system by a particular tech? Thanks, James
Last Updated by Technician Report
SD Version 8026 Hi Support, Please could you assist me in creating a MSSQL query to run a report that contains the following; All pending requests with the below columns including an extra column at the end that shows the last time a technician updated the request as shown in the history. (Including adding a note, Work Log or Conversation) The data also needs to be grouped by Technician Group. Any assistance would be greatly appreciated. Thanks In Advance. Gary
Report Total group time spend on a ticket
hi, Is it possible to calculate the duration of an incident for a specific group or for a technician ? For instance in this ticket the query or stored procedure would return 2 lines : 11:27 - 11:30 => 3mn for the group EUDC infrastructure 11:46 -11:30 => 16mn for the group EUDC application Iwould like the total time spend on a ticket or request for a Group or a technician Any help would be appreciate Regards, Eric
Custom report page size
Hi all, I noticed this was answered on this forum back in 2006, but thought I would ask again to see if things have changed since then. Is it possible to adjust the page size of the reports that are produced, as when they are printed from pdf etc they only fill about 2/3 3/4 of a page before printing on the next page, this is on A4 paper Thanks Lee
Report ServiceDesk Plus reallocation of ticket
Hi, Is it possible to get a report telling me the tickets that were assigned from a support group to a different support group? SDP 8114 Professional MSSQL Thanks, Mauricio Fuentes
Specific reports SDP 8110 Professional version
I need a report to tell me how many tickets were resolved within 24 hours and another report that tells me how many tickets were assigned within 1 hour. Can you help? SDP 8110 MSSQL Thank you very much, Mauricio Deshacer cambios
Error in reporting on demo site
Hi I get the following error on the demo site type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: Servlet execution threw an exception com.adventnet.servicedesk.filter.EncodingFilter.doFilter(EncodingFilter.java:162) org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) com.adventnet.servicedesk.authentication.NTLMV2CredentialAssociationFilter.doFilter(NTLMV2CredentialAssociationFilter.java:34)
Reports for Request that were in a certain group in a certain day
Hi, I'm looking for a report that contains all requests that were ever in a certain group regardless if they were reassigned to another group before they were closed at a certain time. For instance all request assigned to Helpdesk group on Monday26 november 2012 ? Thanks, Eric PS the following is not working because I do not return ticket that was assigned to my group previous to '2012-08-18 00:00:00.000' DECLARE @currentDay DATETIME ,@histoStartDate DATETIME SELECT @histoStartDate ='2012-08-18
Bug when trying to generate reports
Hi, I´m havin trouble with reporting in SDP, i´m able to generate one report before receiving the below message; essage Dear user, Unable to generate the report, So please contact servicedesk support for further assistance to resolve the issue and forward this mail and support file(s) to support@servicedeskplus.com Error Trace net.sf.jasperreports.engine.JRException: javax.imageio.IIOException: Error reading PNG metadata at net.sf.jasperreports.engine.util.JRJdk14ImageReader.readImage(JRJdk14ImageReader.java:62)
ServiceDesk Plus crashes/Slow
Hi Team We are experiencing some slowness and frequent crash in AirAsia's ServiceDesk Plus deployment. Even with Roles association, its very very slow and takes sometimes for assigning them. Also, this week, there was a sudden crash in the product and we got these errors in the Wraapper file. INFO | jvm 2 | 2010/10/06 18:16:15 | Please connect your client at http://localhost:80 INFO | jvm 2 | 2010/10/06 20:18:12 | # INFO | jvm 2 | 2010/10/06 20:18:12 | # An unexpected error has been
Detailed report for changes
Can someone help me? I would like to make a report of all my changes with a summary of alle related tasks and problems. I can't find this. When I try to make a summary report. I can't select the changes. Thnx! Saskia
Issues with query processing
Query SELECT DATENAME(month, DATEADD(mm, -1, GETDATE())) + ' ' + DATENAME(year, GETDATE()) AS [ ] ,ordercount AS 'Total Completed' ,ordercount - overdue AS "Completed Within SLA" ,CONVERT(DECIMAL(5, 2), ( CONVERT(FLOAT, ordercount) - CONVERT(FLOAT, overdue) ) / ordercount * 100) AS "% Completed Within SLA" FROM ( SELECT COUNT(*) AS ordercount ,SUM(CASE WHEN wos.ISOVERDUE = 1 THEN 1 ELSE 0 END) AS [Overdue]
Report about installed software Skype
Hi, We using your software Manage Engine Service Desk and now i have a problem when i try to make a report. I have a task choose all computer where installed skype, but when i chouse Report--->Software i make a report and see only installed program but I do not see computer name. Tried different options but nothing helps. Can you help me please how i can make this report.
Resolved Time not populating
When running a report in the Incident Reports Table Schema, Resolved Time is showing as "Not Assigned" even though the individual tickets show a date/time resolved. Running ServiceDesk 8.1.0 Build 8116 SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",wo.RESOLVEDTIME "Resolved Time" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE (((wo.CREATEDTIME >=
Additional field
I need to have a global custom field "Client" that is available to all modules of ServiceDeskPlus. I can accomplish this by adding custom fields to the 3 different modules (Requests, Problems, Changes) however it would be easier if it could be a global and I only have to maintain 1 pick list. Is there a way to accomplish this with the current product? I also need access to this field for timespent reporting in all 3 modules.
Report SDP first contact resolution
Hi, How to obtain a report that indicate how many tickets was resolved on first contact? Thanks, Mauricio Fuentes
Customize Report
Hi, Is possible to create a report for my company with the columns below? Asset*, Request, Time Elapsed (SUM of worklog). *Grouped by Asset Period: 20 Setember 2012 to 20 October 2012 Thanks, Leandro Passos Marcollino
Can I convert longtodate to a simple date, minus the time component?
I am trying to simplify a report and do not need the long timestamp in my report. It's more of an aging report, I need the date but not the time, and it's forcing the column to continue to the next line. How can I convert it so I only see the time? rnicholson@reyesholdings.com
Workstations/servers hardware details
Below Query is not fetching perfect Inventory,Is anyone can help ?. I am using latest version in evolution mode . SDP build 8115 select (SELECT CASE WHEN min(CAST(sys.ISSERVER AS CHAR)) = 1 THEN 'Server Details' ELSE 'Workstation Details' END) 'Is Server',max(WORKSTATIONNAME) 'Name',max(IPADDRESS) 'IP Address',max(MACADDRESS) 'MAC Address',max(SERVICETAG) 'Service Tag',max(BIOSDATE) 'BIOS Date', max(BIOSVERSION) 'BIOS Version',max(LOGGEDUSER) 'Last Logged User',max(OSInfo.OSNAME) 'Operating System',max(cd.COMPONENTNAME)
I need help creating a custom report showing average days to close a request by priority, for all priorities and by Tech
Hi, I searched the forums and could not find a custom query or report to show me the average days to close a request by priority, for all priorities and by tech. Any help would be much appreciated. MYSQL Build 8009 Thanks
Software Summary report which includes software keys
I am looking for a software summary report which will list all of the software installed on a workstation with the software license keys which have been detected by the Asset scan agent and imported into the asset database. The information is viewed when looking at a workstation from the asset list, but I am not able to find a report which displays this. thanks Tony
Custom Query Report: Technician Average, Max, Min resolution times factoring in operational hours for a given date range
I am trying to create a report that will display by technician the average, maximum and minimum time required to resolve a request (Not looking for time spent) within a certain date range. For example I want all of the technician averages for last month or last year. I am guessing the most accurate time for this is the difference between the workorder.createdtime and workorderhistory.operationtime for Operation=close. I was able to write the following which gets me close to what I am looking for
Request Status Timeline Report.
Hello everyone. I have been trying to create a report that Shows the Timeline of the Requests status, for example: How much time a Request have been in Open or Onhold. Anyone know how to do this?. Regards.
I need creating a custom report showing this columns
Hi, It is possible to create a report with the following fields? Client/ Site / Time used this month / Incidents closed this month / Incidents ongoing /% of incidents without first response violated MSSQL Build 8003 Thanks. Leandro Marcollino
Ability to see edit button in reports
I have some techs I gave access to reports to that want to run some of the canned reports... however the edit button does not appear for them (to be able to change filters etc for their reports and dates etc)... I went into their role that they are assiggned to and gave that role full control over reports, but the edit button still does not appear. We are using 8003 version. Any thoughts on how we can get that button to apear without making them an admin over the whole system... what other groups
MSSQL help
Hi, i need some help to generate this report. All data in the report need to be for the current month. Column 1: Account Column 2: Site Column 3: Total Time Elapsed (Sum of worklog) Column 4: Total Requests with status Closed Column 5: Total Requests with status Resolved Colunm 6: Total Requests with status Em andamento (i have a status called "Em andamento", its like in progress) Colunm 7: Sum of Columns 4, 5 and 6. Column 8: Total % SLA violated based on "First Response overdue status."
Report Building
Hi, I've just started to get to grips with building reports using this system but have found it increasingly difficult to build a report that would be quite useful in my line of work. I would like to build a reports that looks at the length of time a particular request has been in certain status's/ For example, the request starts in an open status, then can go into and Investigation status and then complete. How can i monitor how long it was under investigation as i can only seem to bring up the
Open Requests by date
Is it possible to get a report that shows how many open requests there are as of a certain date?
Query Report sorting
I have a query that ends width 'order by 1' and the report is ordered as it shoot. But can I get the ordered by column removed like in predefined reports?
customize enabled report links
Hi all, Does anyone know if it is possible to customize the link in reports so they are redirected to the customer portal instead of directly to the https://mainsite/WorkOrder...? Regards, Vincent
Copied webpage into ticket causes problem
We are running ServiceDesk Plus 8.0.0 build 8007. A user entered a ticket and copied the webpage into the ticket. This caused a problem with the ServiceDesk software. Everything below the first sentence disappeared from the ticket. This includes the rest of the text, the reply/forward buttons, the Requestor Details, and any other sections lower in the ticket. We were not able to copy the HTML and did not capture any screenshots. The problem was resolved by editing the ticket and toggling the
ask Service Desk configuration
Dear Sir, I'm new at ManageEngine Service desk PULS. I just wonder whether I can use this tool to export my IT assessment such as Desktop and laptop to an Excel sheet. For example, I would like to query all the computers of which the memory is less than 4GB. Also, can I just export all the desktop to Excel?
get Warranty information based on service tag/serial number
Hi, Is there any way to integrate service tag / serial number to fetch warranty from their websites? Eg. http://preparedpc.com/2010/05/11/dell-warranty-information-script-puts-your-computers-information-into-an-excel-spreadsheet/
Custom Report for incident with problem
Dear Support, How can i get the custom report for incident with problem for march 2011. regards, Ashraf.
Report - Clickable link for Problem ID or Title
Hi, I have created a report that lists a bunch of Problem incidents. How can I make the "Problem ID" or "Title" into a click-able link so that it opens up the problem page for the selected incident? Please see image below, I would like to make the highlighted texts into links so that once I click on them, it will direct me to the problem page for that particular incident. Is there an option for that? Or what SQL code will accomplish this for me? Thanks, Gavin
Next Page