Hi everyone, I'm looking for a way to report on MTTR and Cycle Time on Incidents. Mean time to resolve seems straight forward using Average resolution time in performance analytics. However, if I want to see full cycle time, which in our world should...
We are trying to take a look to see if there are any reports we no longer use. I did some searching on here but only found really old posts. They mentioned looking at the report_view table but I do not seem to have that table. Where can I go see t...
Hi, I need to report on users that are in more than one group from a list of groups. For example, any users that are in 'service desk' and also in another itil groups. I was going to report on the user table and then in 'Related list conditions' sel...
I need to be able to measure the percentages of tickets that are older than 30 days. I have build an SLA that will count days open on an ticket named SLA 3-17 Ticket Ageing and it will breach when it is more than 30 days. I am measuring the SLA as a...
hi all, is there a way to include average line on normal bar graph. eg. That should include the average also. I have a feeling that it is possible by PA but as i don't have experience there, i need a good guide to achieve the goal here thanks,Jake
Hi, I'm creating a list report based on a database view. The database view consists of the task_sla table to which I left join the incident, sc_req_item and problem tables. Basically creating a view with these records and their SLAs. When viewing the...
Good morning, I'm attempting to clean up some CMDB tables and create a real CI lifecycle management process at my organization. I've created some CMDB archive rules for just "servers" and I was expecting to be able to create ACL's for the server te...
Hi Expert, We have designed Group Manager dashboards, I have added Assignment group as Breakdown source, So that user can select group filters, and widgets will respond based on filter value selection.Here I have few questions. 1. Is it possible to...
Hi! I'm having problems with a heatmap widget not showing any data, despite the data being listed in the indicator scorecard for both breakdowns. So what I have is a database view that I use in the indicator source. This is a joined view with the t...
I have created a simple custom interactive filter based on the incident table. This will filter the assignment group in the pie chart to Database if i click the Database-button. Even though I have set the pie chart to 'Follow interactive filter' it'...
Just to start we are not using Performance Analytics. Is there a way to get a report that show incidents created in the last 48 hours? I noticed that If I do created on then click the drop drown there is an option for last 2 hour.
Is it possible to create a list/report that lists all incidents, changes, problems, etc. for a single configuration item?Thanks,Mike G
Hi, I'm trying to send a project status report to stakeholders who have a vested interest in the project. I created an email notification using the Project [pm_project] table it sends a link to the Status Report to the user on update and insert. I ...
Hi all! I've been tasked with creating a report to show the average time spent to fulfill a request. I'm rather new to all of this, and am not sure if I'm hitting the mark with the report I've put together or not. Source Type: Table Table: Request ...
The field that I am trying to add is "Has Breached" from Task_Sla table.
