How can you export all the category and sub-category from the mange engine system
i am attempting to reorganize my manage engine categories that we assign to tickets and was wondering if anyone knew how you can export those categories so i could see them all listed. Right now my method is screenshot the category and its sub category and as you'd expect its extremely slow and not really working. So if anyone could help it would be much appreciated.
Report of workflow settings
I would like a report of the workflow settings for each of my service request templates. We need to make a change to each template and need a checklist as well as a confirmation of the settings change. We need to be able to see all the values show on the "Service Workflow Settings" page. We are currently running version 9214, but I expect to be moving to 9215 shortly. Best regards Dave
Report For SLA Escalation Rules
Hi, Could I please get the MSSQL query to run a report that shows: - SLA Name - SLA Response Time (respond within X hours) - SLA Resolution Time (resolve within X hours) - Level 1 to 4 escalation notification timing (e.g. 4 hours before, or 1 hour after, etc.) - Escalate To This would essentially be the data that appears in the Service Level Agreements page in the Admin module. We have many different SLAs, and it is time consuming for management to go through each SLA individually to review the SLA
disabling default report
Hi, how can I disable default report to technician so that I can show them only the one that I create. I'm working on release 9.1 Thank you for your help Antonio
need report like this Please
Dear Support, Could you please generate report like like this? ticket ID Request Name technician Status Approve sent on Approve Acted On approved overdue.( Approve sent on - Approve Acted On ) 9.1 Build 9118 DB Postgre
Time Elapsed Analisis
I need support if we have a report of the information displayed on the tab "Time Elapsed Analisis" as shown in the attached image. The elapsed time by group and technician. Thank you very much for your support. Su Versión : 9.0 Construir 9043
Report WorkOrders By Company
Hi, I'd like make a report from workorders adding company columm for any case. I have this Query for Company: SELECT people.attribute_1201 "Company", count(wo.WORKORDERID) "count" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID Left join people on sdu.ciid=people.ciid WHERE (wo.ISPARENT='1') group by people.attribute_1201 workorders: And for WorkOrders: SELECT wo.WORKORDERID AS "ID de la solicitud", qd.QUEUENAME AS "Grupo", aau.FIRST_NAME
Need query to find out login history of technicians
Hi, I need login history report of techinicians. MESDP 9.0 Build 9048 PGSQL please provide the query. only logged in techinicians can be seen on the system but I need login history. Mohammad Golam Rabbany Proud Customer of MESDP
Zoho reports (Advanced analytics option in Service Desk Plus)
Good morning, I'm trying to reconfirgure the zoho account in Advanced analytics option in Service Desk but I'm not able to do so... The option is in grey color. I need to change the account configured, could you please assist me? Thanks in advance
Important Note at the top of reports
Hello, This started appearing at the top of reports recently - IMPORTANT NOTE : The upper limit will be applied as 5000 for request module based queries, having selected columns description/resolution and 50000 for other queries. Please can you tell me what it means? Thanks Bruce
report by group
Hi, please provide query to create report for all technician under specific group Example: I need report all technicians under "CIMS" group with details group name / technician /email address thank you
Request module limits message after update 9207
After installing the update 9207 in each message of scheduled reports added "IMPORTANT NOTE : The upper limit will be applied as 5000 for request module based queries, having selected columns description/resolution and 50000 for other queries."
Adminsitration Report - for Categories, Subcategories and items
Hi, There doesn't seem to be a lot of pre-built reports for the lookups used in SDP. I am after a report that details the Categories, Subcategories and items we have created, this is not to be linked with any requests or technicians as we are doing some housekeeping on the lookups and trying to see if we have inadvertently created some duplicate items in different Categories or Subcategories. I cannot find any information on the table used within SDP so am having difficulty in writing any SQL statement
Contracts that we have deleted are still showing in Reports
(Test) Contracts that we have deleted are still showing in the ServiceDesk Reports > Contracts > Contracts by Status, Contracts by Vendor and Expired Contracts. They don't show on the main 'Contracts' tab anywhere as they were deleted. We want to get rid of them permanently as they keep showing up in reports, please advise.
Time Elapsed Analisis
I need support if we have a report of the information displayed on the tab "Time Elapsed Analisis" as shown in the attached image. The elapsed time by group and technician. Thank you very much for your support.
Custom Query Report On Projects Module
Hello Team One of our customers is requesting a custom query report including the next fields: ProjectID Title ProjectDescription ProjectStatus PercentageProjectProgress ProjectStatus ProjectOwner ProjectComments ProjectActualEnd TaskID TaskTitle TaskStatus TaskDescription TaskOwner TaskStatus Task % of Completion TaskActualEnd TaskComments Can you help us with the requeriment, please? Thanks in advance. ASM
Technician reporting
good morning, I know you can get a live view of technicians currently logged on in the schedule view, is it possible to get a report of when technicians have been logged in and how long for? An example would be if i got into work at 7AM and logged into SDP it would show my login time and if i time out / log out of SDP it would show that time and so on. With the level of reporting available i thought this would already be a report, so perhaps i'm missing it? Many thanks.
Monthly Report
Can you please help me in generating Monthly Report by Category/Technician Wherein it shows Raised Request for this month and Close Request for this month without inheriting 'Closed Request that has been raised last month' mysql Version 9.1 build 9118
report for asset stated changed to xxx in last year
Hi there, basically we need a report that list all the asset that have their Asset State changed to insertCustomState within the past year or something like that. Normally when we decommission/dispose an asset, either it's too old or broken, we changed the asset state to DISPOSED but not delete it from the record. This way we have a record of what asset(s) we have/had. And then someone higher up requesting a report on how many IT assets we disposed of in the past year. We can always create an additional
ci info details
Hello, I am new in Service desk, I installed Asset explorer on Clients and scanned workstations, but CI info doesn't show some hardware specs correctly and miss them like Manufacturer, Ram type and motherboard model. How Can I get more Detail about workstations? also in relations tab it doesn't show relationship between all entities. tanx..
ME isn’t recording who has receipted the goods
Noted that there is an issue where Servicedesk plus (Purchase) dose not always show who receipted the goods (in the history tab). This can cause issues when there is discrepancies in the assets received. Also noted that the history is not in date order. Anyone else have this problem and how can we fix this?
KPI per month
Hi, Can someone please assist me in creating report based on SLA. Basically I need a monthly report that will show how many percentage we have on the number of request per month that didn't have SLA Violation. If there's a custom report please let me know otherwise if this is the type of SQL query, my information is below Build: 9202 DatabaseType: PostgreSQL
Report on Active Category, Sub-Category and Item
Hi, Can you provide the query to display only Active (in use) Category, Sub-category and Item? Found this somewhere in the forums but it lists ALL of them. SELECT cat.CategoryName "Category" , sub.NAME "Subcategory",(SELECT STUFF((SELECT NAME + CHAR(10) FROM ItemDefinition item where sub.SUBCATEGORYID=Item.SUBCATEGORYID order by 1 FOR XML PATH ('')), 1, 0, '')) "Item" FROM CategoryDefinition cat LEFT JOIN SubCategoryDefinition sub ON cat.CATEGORYID=sub.CATEGORYID Build version: 8.2.0 Build 8207
Performance per Technician
Hello, I want to design a report on tasks which show me the count result with the following criteria: 1. Group by Site,Group, Technician, task status 2. Between date A to data B I am running on MSSQL and Version 8.1.0 Build 8105 Regards, Javad
Change Logo Size in SDP report
Hi , Can i change the logo size in SDP report ? I have tried changing the image size while uploading in Organization Details , but that doesnt help Kindly suggest Regards, Pramod
Error executing SQL statement for : ManageEngine Report Framework
When I run some of the reports, I receive the following exception. But some of them runs successfully. Would you please help me with this problem. Version : 9.2 9204 Last Updated Version : 9.2 9209 Message 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: Error executing SQL statement for : ManageEngine
25 Oldest Calls
Please can someone advise a custom query that lists the oldest 25 calls in the Service Desk and list them via created date, will also need to show RequestID, Subject, Group, Technician. Thanks
Add Asset Description to Report
Hi All, We have a simple Query to make a report for our Ipad. But we have values that are added in the description field. Could someone help us to add that field to our report ? SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("aaaUser"."FIRST_NAME") AS "User", MAX("productType"."COMPONENTTYPENAME") AS "Product Type", MAX("resFields"."UDF_CHAR3") AS "Extra Info" FROM "Resources" "resource" LEFT JOIN "ComponentDefinition" "product" ON "resource"."COMPONENTID"="product"."COMPONENTID" LEFT
Summery Report
Hello, I want a report on ServiceRequest with the following criteria: Count of request group by Category, Subcategory, Item, Status respectively Between Date A and B I am running on MSSQL and Version 8.1.0 Build 8105 Regards, Javad
Creating vibrant ServiceDesk Plus reports using Analytics Plus
Click here to know more about this integration.
How to integrate ServiceDesk Plus with Analytics Plus
Click here to learn more about this integration.
Need Report
We need a report (a simple list) which shows the following · Only JLR focal point · Complaints from November 1st 2015 to April 1st 2016 · All tickets/complaints which do not have an attachment uploaded · Only two columns are need, "Complaint Number" & "Attached Item" or whatever names suit you. V.B : 9119 D.B: Postgra
Software 'Installed on Date' in reports
SDP v9207 This may have to do with known issue: SD-60646. When I export a report from an installed software that includes the 'Installed On' date, the date appears in timestamp format instead of a date. Example = "1461556800000" instead of "Mon, 25 Apr 2016" It doesn't matter which type is used Excel/PDF/etc. Also, can the installed on date be made available on other reports, and as a field that can be selected when creating a custom report. Thanks!
Active Directory user authentication Problem
Dear all, I have import all AD user and also enabled AD user authenticate but still AD user are unable to login "check user name or password" i have tried abc.com(domain name) or ABC(domain name) but result is same. please help me..... jahangir mughaljahangir512@gmail.com
Report Issue
Hi, I have an issue with report , when I try to create a report from report module and after generated the report I can view the link for request or when I click to request number will going directory to the request but not no link for request or when I click to request ID not shown any thing. Best regards
Need help: technician respond ticket and who is technician resolved the ticket
Dear Sir/Madam I need to find query report that will tell me who is fisrt technician respond ticket and who is technician resolved the ticket. For example: Thanks Best regards, Kurniawan
Design a report for average completed time of Service Requests
Hi I need to prepare a report with present me the average completed time in a date range between Date A and B for any service request which is grouped by the following fields: Site Category Note: I do not care about the other fields within the report. Regards, Javad
how many request has been closed by technician?
Hi Dears I need a report to show me each of technicians how many requests has closed in the month i need : group technician month number of request that he/she closed in the month Thanx
I need a report to get the Ticket On-hold duration.
How can I get the ticket on-hold duration?
Custom Query
Hi. I need a Custom Query that lists Software name and Software version Installed by developer. ie. Developer = Cisco List = SoftwareName List = SoftwareVersion Anybody able to help with this?
Next Page