Sort descending or ascending in reports
For example, I would like to sort a list of projects by descending priority (showing 99 on top and 01 at the bottom). Right now I can choose to sort by Priority, but the default is ascending. This applies to many other scenarios
Request Summary report need to show for last one year.
Dear ZOHO Team. We need to see request summary report in dashboard for last 6 months and 1 year (e.g. This Week, Last Week, This month Last Month ) Like we want to see last 6 months and 12 months graphical view report. Please suggest how can I achieve this in Service desk plus dashboard.
Getting Error in schedule report
Hi We have schedule some reports and was enable to get that. Every time we need tor refresh and get. None of the scheduled report run until we manually go and refresh it.
e-mail id(s) to notify
We recently upgraded to 9.3 Build 9301. Since then, we can no longer remove entries in the e-mail id(s) to identify field whereas we could previously. End users tend to duplicate their own addresses in that field or sometimes enter an invalid email address. We must have the capability for removing entries in that field. Currently, we can remove the data in that field, click save, and not receive any error message. But, the data is still there. Please advise. Thank you, Brian D. Meer
Can I create a script that updates the information of the assets that is in a table of another system.
I have a system which stores the inventory of computers, these computers have some configuration that the agent can not be installed and can not be analyzed through Service Desk Plus, but I need to create these assets in the SD database. can I create a script that updates the information of the assets that is in a table of another system? The first load I made it through an excel file but this is manual, I need a solution that can be scheduled to run once a week.
SDP Worklog and Zoho Report showing different values
Hi - My SDP Worklogs and Zoho Reports are showing different data for the same intersections. Zoho is showing 1 hour while SDP Worklog is only showing 30 minutes. This seems to only happen when using half hour increments. Whole numbers seem to be fine. Please see attachments showing the discrepancies.
Why average values of helpdesk KPIs don't give you the full story?
While measuring helpdesk KPIs such as resolution time and response time, we always look at the average value. An average resolution time of 5 hours tells you that your technicians take around 5 hours to provide end users with a resolution to their problem. Does that mean that ALL your technicians come up with a resolution in 5 hours? Not really. Let's consider a 2 person helpdesk team with Adam and John as the helpdesk technicians. Scenario 1- Adam resolves all requests within 4 hours (4 hour resolution
I need help to customise this report query
Hi, below is my report query and I need you to help add a line that adds up the total time spent on the request: SELECT wo.WORKORDERID AS "Request ID", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", ti.FIRST_NAME AS "Assigned Technician", ct.TIMESPENT AS "Time Spent" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser sdu
How do get Request Custom Fields and WorkLogs tables linked? I tried Lookup Column
How do get Request Custom Fields and WorkLogs tables linked? I tried Lookup column on RequestID but it says I cannot add it. I have a custom field called Request Type in table 'Request Custom Fields'... See attached. I'm trying to build a report using fields from Request Custom Fields and WorkLogs but not working. The attached screen shot shows the relationship of RequestID on all tables so not sure why it's not working. Thanks!!!
Average Response and Resolution times
Hi Please can someone assist with a MSSQL report query to report on the average Response and average Resolution times per Site for the last 30 days/this month. The report should have the Site name; Average Response Time; Average Resolution time; Number of Tickets Your assistance will be greatly appreciated. Thank you.
Add Notes in Report Column - new querry
Hello I can see that you are able to generate querry to add Notes to report. After generatiing such querry will I be able to modify it like any other report not made from querry ? Regards
Service Category Report
Hi! I have the following query (from elsewhere on the forum) that reports my service categories and templates, (title and description). I would like to group the output by category and also add the SLA data (name only) if it exists. I also want to exclude any template that is flagged as no longer in use. SELECT case when serd.ciid in(select ciid from businessservice) then 'Business Service' ELSE 'IT Service' END "Service Type", serd.Name "Service Category",serd.Description "Service category desc",
Tickets resolved, closed by technician during a specific set of hours in 1 month.
Hello, I would like to create a report that tracks completed tickets ( resolved , closed ) during a 1 month period between 9:30 AM to 3:30 PM. Here is the query for the report without hours in between. Im wondering if you could help me add the last bit to report between those set of hours. SELECT "ti"."FIRST_NAME" AS "Technician", "std"."STATUSNAME" AS "Request Status", "wo"."CREATEDTIME" AS "Created Time", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS
Report to list all SLAs configured
Is there a way to run a report, probably a query, that would return all of the SLAs configured in the system and what categories/subcategories/items are tied to them? Using Postgres DB right now - version 9.2, build 9240. Thanks, Geoff
Newly added assets report
Hi all, I would like to create a report that scans for newly added assets within a site. These assets can be for all equipment, switches, routers, computers, printers, access points, etc. My intentions are to create a report that views the last 7-days worth of newly added assets, 14-day, 21-day, etc. etc. I haven't played with this much so I might figure it out shortly but i wanted to post this out there for any feedback. Thank You.
Query - Service Catalog and related Service Categories
Can someone assist with a query to list all Service Catalogs and related Service Categories please (including descriptions). Thank you
Manage Engine Service (SQL DB ) MS PowerBI createtime fix
Can anyone help how I get a clear data and time from the unix stamp in powerbi I'm trying UTCTime = VAR UnixDays = [CREATEDTIME]/(60*60*24) RETURN (DATEVALUE("1970-01-01")+UnixDays)
Time Difference Issue
Dear Team, I'm getting 12 hr time difference, when I run report from the reporting TAB. The version & Time zone is correct from server/Personalise settings. but still it is showing 12 hr difference from the actual creation time. The ticket shows correct but it doesn't show correct time when it runs through reporting. I've attached screenshot, version details & Support file. Please assist. Thanks
Integrated Chat
I know this has been asked in the past, but is there any way you guys can add an integrated chat feature for Service Desk Plus? This would be a huge benefit to all of our technicians and users. I know other Help Desk software companies have added this already. This is a feature that has been requested for years.
Report for checked box of a resource
We have a specific report for our users to report security incidents. We needed to pull a report for all submitted requests for a specific topic. Can you please create a report for me that would gather all the results of a selected option? I have provided a picture of the options. DB: MSSQL Build: 9235
How can I export or create a report of all my services in Service Catalogue?
i want to show all my service catalogs and workflows, it is possible ? my version is 9.2 build 9218
Report on templates
Hi, Anyone know of a way to make a report that shows how many requests are based on each template? Like: Default Template: 1.349 New Employee: 45 RoboTech-template: 459 etc. /Rasmus
How do I extract support group and the content in to excel
Hi Support, Appreciate you could advise the query to extract support group into excel along with the technician. Regards, Vincent
Configuration Report On Categories
I am looking for a query report that will give me the categories, sub-category, and items that we have configured in SDP. We are running version 9110 and using MS SQL. Craig
Built-in way to audit SDP published ticket subject?
Team, I'd like to be able to evaluate the quality of our tickets in an automated fashion. Is it possible for SDP to automatically compare whether the original ticket subject and the present ticket subject are different? If not, has anyone tried this: 1) Create a second field called original Subject. 2) Create a business rule that upon creation copies the subject to this custom field. 3) Run a report comparing the current subject to the custom original subject field. Would that work? Thanks, Adam
Report to show number of service reqeuets and incidents
Hi im looking to build a report that will show show all the service requests and incidents for each week and for a particular group service desk Example Week 1 Week 2 Service requests 23 Service requests 30 Incident 30 Incident 40 Thanks
How do I export out all my category and subcategory to excel or CVS
Hi Support, I'm planning to do some enhancement to my current category and subcategory. Which i'm require to export out the current category. Appreciate your advise. Regards, Vincent
Tickets with Attachments
Hi Can I get a list of all the ticket numbers that have at least one attachment? Any query to generate such a report? Thank you :)
Filtering out unused CIs in report
Hi, I am trying to create a report containing a list of Business Services, but I want to filter out those that are flagged as 'not for further use'. I can't find an option to filter this - does anyone know of a way to do this? Thanks Paul
Scheduled reports don't run after service stop/restart on v9.3.9303
Hi, We have an urgent issue with ServiceDesk Plus in that every time we stop or restart the windows service the scheduled reports all stop running. I’m running v9.3.9303 and build 9304’s release notes doesn’t mention anything about this being fixed. This happened on Friday last week but we only noticed it this morning. Regards, Andy Ps. This has been logged on the ServiceDesk Plus helpdesk on ticket # 8036611 just now.
Monthly Report schedule question
Hi, I want to schedule the execution of a report to run two days before the end of each month. In the monthly scheduling options, I only see the possibility of the report being executed on a particular day, for example on day 31 or day 29, but how can I indicate that two or more days are running after the end of a month regardless of whether the Month have 30, 31, 28 or 29 (in the case of February) days. It can be done? . How? Thank's in advance.
CAB Member Report
Hi, I would like to create a report listing all the CABs and their members. Is there a canned report that these old eyes couldn't see? Best regards Dave
Guide for writing scripts and querries
Dear, Is there a guide for writing custom scripts and querries? I am looking to create some, though haven't found any guides. Sincerely,
Aging report
Hi Appreciate you could guide me how to set up a report for aging example incident / request which more than 30 days and 90 days Regards Vincent
request for report
Hi guys, we would like to get a report holding the below: Request ID Request Mode Request Type Group Created By Technician Category Subcategory Created Time First assignment to group First assignment to technician Completed Time Requester Department Priority DueBy Time Request Status Item Site we have been trying with bits and pieces we found on the forum, but haven't managed to get it to work. it actually crashed our instance :-) we are on PGSQL
Open beta launch of Analytics Plus - On premise Advanced analytics solution for ServiceDesk Plus
Hello there, Introducing Analytics Plus, a self service data visualization and analytics solution for ManageEngine ServiceDesk Plus. ServiceDesk Plus users will now have an on-premise integration option for advanced analytics. Key benefits of this integration In depth analysis of your ServiceDesk Plus data with over a 100+ reports and dashboards, built on 80+ KPIs. Populate charts from various ServiceDesk Plus modules, all combined in a single dashboard. Easily drill down to a specific
Date format in reporting
Hi Team, The date format in the reporting is Dec 7,201609:32AM I'm unable to change the format even in excel any option which I can edit this Regards, Vincent
Report by group
Dears, we need to create report for Helpdesk group how many request receive the request during this month (not close or resolve the requests) because this group receive the requests and filter the request then foreword to correct group , is there any query or option to know how many receive requests and forward to other group. Best Regards
task and worklog
Hi, is there a way to extract by report task e worklog non directly connected to a ticket? In report section I have: Request Timestamp Reports -> Report by Technician; I don't see task and worklog created by QuickActions -> My Tasks -> Add New. Any tips? Thanks
Advanced Filter Issue
Hi Experts, I'm applying a filter in one of my reports. The report looks for 'Closed' OR 'Resolved' jobs. The second filter (Resolved) is ignored every time - how do I resolve this? Thanks, Gareth
Next Page