Report On Task Based On Group.
Hi There, I got a query from this forum that allows me to report on Tasks associated with a Request. The report includes the Request Local (Site Id) but I would also like to include the Task Owner Group. Is this possible? Many thanks!
Query/report on assets and agent
Dear Support, Can I please have a query compatible with build 8123 and MSSQL for the following information from the asset module: Only for the assets with the Servicedesk agent installed Required columns are: hostname, last date scanned, agent version, username, department, site. IP address Many thanks, Dean
Custom report crashes and cannot be edited
I have a Custom Report MTL- request By Requester, last month and it crashes when i try to run it. It also produces the same error when I click on Edit so I cannot do anything with it I suspect it is because the name has a comma in it. How do I delete the report Here is the error java.lang.NullPointerException at com.adventnet.servicedesk.reports.utils.ReportUtil.getReportQuery(ReportUtil.java:4921) at com.adventnet.servicedesk.reports.utils.CoreReportDesigner.editQReport(CoreReportDesigner.java:420)
I NEED TO DELETE REPORT IN FOLDER
I have created a folder where I out specific reports, now how do I stop another person to save their reports in my folder and how do I delete the ones that have been saved already.
Report to get the list of Category, Subcategory and Item.
Use the query to list of Category, Subcategory and Item. MYSQL database: select cat.categoryname "Category", sub.name "Subcategory", GROUP_CONCAT(item.name separator '\n') "Item" from categorydefinition cat left join subcategorydefinition sub on cat.categoryid=sub.categoryid left join itemdefinition item on sub.subcategoryid=item.subcategoryid group by cat.categoryname, sub.name MSSQL database: SELECT cat.CategoryName "Category" , sub.NAME "Subcategory",(SELECT STUFF((SELECT NAME + CHAR(10) FROM
additional fields when creating report
Hi there, There are some additional fields I can choose when creating a custom report All Requests. On the first step, under available columns, there are lots of old fields I used for testing. is there a way to find out where if it's being used, and how to delete them? Thank you for your advice.
Matrix report - group dates by week
Hi, I want to create a matrix report which lists my technicians on the left in rows and the columns on top are broken down into weekly periods (the range may be a year, multiple or a single month with a weekly breakdown). The content is to show how many tickets the technicians raised on a weekly basis. The wizard doesn't allow me to group days into weeks, is there a way to do this via an MS SQL query? Fields I'm working with are Created By (filtered on my technicians name because staff can create
Summary report - help required
Hi, We are looking for some help to create a summary/KPI type report as per the attached doc. Can you help get us started with this ? Thanks Lorraine
Query report problem
Hi, thanks for looking at my issue. the below report is exactly what im look for however i error when running this im running version 8201 and MSSQL at the bottom of this post is my error message. KPI report - group,technician in ServiceDesk Plus» Query Report-KPI Reporting • 2 years ago Technician Group Total Number of calls Total Closed Calls Closed within SLA Closed exceeding SLA Percentage within SLA Percentage exceeding SLA Date limit : for the current month Tested in 8011 DB :mysql /mssql
Requester Additional Fields
We have used query reports previously to extract requester information in to Excel. The query report below has stopped working since we upgraded recently. I believe that the table containing the additional fiels has now changed but don't know what it's called. Previously the following code extracted everyone with UDF_Char3 = Yes, but now when you update the field that used to be UDF_Char3 (in our case - 'Is Membership Manager') it doesn't appear to be updating in Requester_fields. The user Donna
Service Level Agreement - applying standard SLA's
Hi Quite new to this tools and just building our customer base on the system. We have created a set of Default SLA's in the -configuration wizard HELPDESK- SLA and in the drop down box Default settings. Here we have defined what we want to use as a standard set of SLA's across all of our customers. How do you apply the default SLA's to each customer? or do you need to create them individually for each customer?. i.e. we aren't looking to apply to all customers we appreciate that we need to do it
Report request or help creating
Hi All, im looking for a report in ServiceDesk which shows all laptops or workstation without x software installed im sure its there but i cant find it. if any one could help i would very much appreciate it.
Substract Resolved Time - Created Time Problem
I'm using Postgresql and I don't how to substract Created Time from Resolved Time to show me the time that technicians spent resolving one request in hours and minutes
Report Request for site stats per day
Hi, please can someone help me generate a report. im looking to see a list of our sites with number of tickets raised that day and number closed that day i can do individually but not together. thanks in advance Russ
Custom Asset Report
Is there a way to configure and report on all assets (specifically Servers/Workstations) on the following columns: Workstation Model Custom Attribute Business Impact I am able to configure a custom report with data for the first 3 columns but I cannot find where to add the Business Impact column when trying to configure a custom Asset Report. The business impact field is visible under the asset information page, just not as a select-able item for reporting. Thanks!
Weed out records if count is lower than 2
Hi there, I've created a report in the ServiceDesk Reports area and I am close to what I want however i was wondering if there is any way to not include any records if the "count" on the report is 1. Basically the report I'm creating is a "repeat call" report and it counts the number of requests submitted by users within a time frame and I want to ONLY include the requestors that have multiple tickets within that time frame. Is it possible??
Technician Availability Report
Hi, i need report for availability technician by year or month
Escalation report
One of our managers is wondering if we can report on escalations. Is this possible?
Custom Report Help, Custom Asset Field
Hi Everyone, I'm trying to write a custom Asset report in Crystal reports and need to report on a custom field we added to the asset screen. Does anyone know what table that information is stored in? Thanks. Marc Fleischner Rowan University
Time logged on tasks does not appear on reports
Hi all, We have just upgraded to SDP 8.2.0 build 8204. We can now log time against a task as well as being able to log time against a request. When we log time under the work log tab of a task, it also appears in the work log section of the request. However time logged against a task does not appear on time spent reports. Is this a bug, does anyone know how to resolve this? Thanks
New and Resolved Ticket Dashboard?
I'd like a dashboard (not a report I manually run) that my boss could pull up at any time and view the total number of opened and resolved/closed tickets. Currently the dashboard only shows closed tickets, which is pretty discouraging when you resolve 15 tickets in a day and have to wait a few weeks for them to be marked as closed. Is there a dashboard like this already? Or an easy way to make an automated report? (I'm cool with using APIs if needed, but would prefer something built-in)
customizing report
hello i need to customize the report form or template when exporting to excel or to pdf so how can i do that
Help with query report
Hi, We have created the below new query report, which runs ok, apart from the 'Overdue Status' is always blank? Can you take a look and let us know where this is going wrong? We are using SQL Server 2008 & build 8125 of SDPlus. Thanks SELECT wo.WORKORDERID "Request ID",wo.TITLE "Subject",rtdef.NAME "Request Type",std.STATUSNAME "Request Status",longtodate(wo.CREATEDTIME) "Created Time",aau.FIRST_NAME "Requester",pd.PRIORITYNAME "Priority",longtodate(wo.RESPONDEDTIME) "Responded Date",longtodate(wo.COMPLETEDTIME)
how to synchronize servicedesk plus in two domain ????
Hi guys I am a network administrator in a big company in a our country & we have a 5 building & one parent dc & 4 child . how do i can create a report & synchronize in all ServiceDesk plus domains ??? Please Help me
time spent report
hello i would like to get a report containing the request id and some information about the request (requester, category, site, subject, technician) and the time taken to resolve the request in hours
comments report
hello i need to make a report containing request information plus the comments
Time spent report - calculated as minutes only (more friendly to XLS)
Hi team Wondering if you could provide me a report which performs the following query, but makes the Time Spent column a number which is more friendly in Xls (ie minutes ony)? Currently, the format 00:00:00 does not calculate in pivot tables (because it sees it as text). Changes to the cell format in XLS have not been successful. SELECT mdd.MODENAME "Request Mode",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",cd.CATEGORYNAME "Category",wo.TITLE "Subject",cri.FIRST_NAME "Created By",ti.FIRST_NAME
Help with base tables
I need help with the base tables so I can document my installation 1) I need a query that will list Support groups with all technicians in it. 2) users with within each user group 3) Support Group attached to each incident template 4) Group attached to each service catalog template. Given the time I could find these Im sure, but I'm just not familiar enough with nor have the time to dig into the database schema to find these answers. If anyone has the table and joins for these types of reports,
Timespent report - with XLS friendly Time Elapsed field
Hi team Wondering if you could provide me a report which performs the following query, but makes the Time Spent column a number which is more friendly in Xls? Currently, the format 00:00:00 does not calculate in pivot tables (because it sees it as text). Changes to the cell format in XLS have not been successful. SELECT mdd.MODENAME "Request Mode",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",cd.CATEGORYNAME "Category",wo.TITLE "Subject",cri.FIRST_NAME "Created By",ti.FIRST_NAME "Technician",pd.PRIORITYNAME
Report range time ( between hours )
Hi, I´m 'rookie' in this aplication. My company are looking for a report to show number of request by range time ( We work in shifts ) Information about number of request by range time, month and year....somethig like this: Year Hour 2013___00:00-07:00_07:00-15:00__15:00-23:00____________________ Febrary_____73_________65________ 89_____ January_____54_________56_________65__- 2012 December___56__________654_______67____________ Can someone help us. Thank you
Reports folders
Dear Support, I would like to know if there is any possible way to remove a report folder from the Manage Folder view ?? Thanks.
Request for asset report - scanning agent and specified software
Dear Support, Can I please have a query compatible with build 8123 and MSSQL as follows: Specified software (eg Mozilla Firefox) of my choice installed on Assets with a SD scanning agent and last scanned time. Columns required: Hostname, User, Department, Site, Software (eg Firefox), Software Version (eg 20.0.1), Last Date Scanned As an example, this is so I can identify which assets are not running the latest version of Firefox, and produce a list relevant to each site/region to request they update
Can a report be generated on the Solutions?
Hi there, I was wanting to know if it possible to create a report on the Solutions made in ServiceDesk plus? If so could anyone give tell me how to do so? Thanks.
Requests by technician report does not pull up all technician's data
I am new to using the Service Desk Plus software. My predecessor created a few custom reports so we could run weekly reports to show open tickets by technician. The data displayed a graph with each technician's name displayed with the current number of open tickets for that week. Recently something has changed and whenever I run this report, it will only display the data for my account. I had one of our other technicians run the report, and he now only sees the data for his account. I have not
[Service Tag] field not available on cutom report
Hi there, We made a custom report and choose All Assets in the Module section. However, on the next step, [Service Tag] is not available on the available columns to display. However, it appears when I select All Computers (Workstations and Servers) as the module. Why is that?
Save Report As function after editing a currently existing Report
I find it odd that after running a report, you can "Save As" the report to essentially create a new one; however why is it that you cannot use the "Save As" function if you edit the existing report and run it. After editing a currently existing report, you are only able to override "Save" the report. You cannot save it as a new report.
Reports/graphs do not recognise my new reauest status's
Reports/graphs do not recognise my new reauest status's Hi, i have added some request status's to the ServiceDesk however they do not appear in the graphs on reports - also they do not show on the Dashboard page. could someone point me in the direction of how i can enable these. thanks for your help Russ
Notifications SLA
Hi, I have a question related to notifications when the SLA is not met. How I can configure the tool (SDP) to mail notifications will reach a specific user? Regards.
How to create a scheduled report where the date filter change monthly
I tried to create a simple SLA report and schedule it to be sent monthly. Problem is, I created the report last January and every month it automatically send me the SLA report for the month of January. Is there a way the scheduled report will run with the date filter of the previous month? (i.e. Feb1-28 report sent on Mar 2, Mar1-31 sent on April 2, etc)
Report on time taken to assign a ticket to tech
Tickets are created by email and are open and unassigned. I go in an assign a tech to work the ticket. I need a report on how long it takes to go from unassigned to assigned. Any ideas?
Next Page