We are trying to do an audit on report access and I've found that the best table to use is sys_report_users_groups . The only issue with this is that the table visibility is only available for admins. We were able to create a database view joining sy...
We need to extract the results of one of our surveys. Each response should be on a row with answers to questions as columns. You can easily extract in this format for Google Forms and Microsoft Forms which actually makes more sense since you will hav...
Report on time taken by ticket to move from assignment group to assigned to please tell me how to report on time taken from assignment group to till it get assigned to an individual engineer(assignee)?
I have been working with dashboards and widgets for a while now, in different versions. Currently I am running instances of London and Orlando. Lately, the filtering when trying to add widgets to a dashboard, does not seem to behave the same anymore....
I'm extracting Incident change and request since o6/01/2019 till date . the number of record for incidents is more than 20K ? when i export to pdf , it exports only 1000 record , where to configure for all the records to exported also how to select d...
hi all, We want to see the average time it takes to provide any approval for some requests. I see that we can leverage the 'approval set' attribute on task records but for requests which have multi-level approvals, this may not be enough as it give...
Background (the ask): Using the SAFe module, I need to provide trending data on the average amount of time tasks (User Stories, Features, Epics) spend in each State, broken down by State and Team. To accomplish this, I have set up 2 Metrics Definiti...
We added a target value of 95 for breakdown Priority and checked the option: Any Element on indicator % Incidents Resolved within SLA. (See attached)When we put this indicator on a dashboard tab which is not a breakdown dashboard, we can see the prio...
Hi, We need a report that will show the percentage of incidents closed the same day and closed by who opened it vs total number of incidents by who opened it. In other words, per user, all the tickets that user opened per month vs the number that u...
Hi Experts, We have SLAs on RITM, need to fetch a last one month report on set of assignment group and assigned to user, since there is no reference field for SLA in RITM form and SLA comes in related list how can I fetch the report where it shows bo...
Hello, Do we have any option to Merge mutiple reports & display one ? Ex: Report 1 : To display Closed Catalog Tasks Report 2: To display Resolved Incidents Report 3: To display Breached tickets. I have these 3 reports saved daily basic i expor...
Looking to add a dashboard filter where a manager is selected, and then the users in their org structure. I basically want to filter a list of incidents where either the manager resolved the issue or if someone in their organization resolved it. If ...
How can we modify the column width on a ServiceNow report?
Hi Everyone, We have different SLAs for our customers based on their support level: Platinum, Gold, General. I need to plot case Average Response Time and case Average Resolution Time for each of the 3 support levels. Could you point me to any resour...
I have a use case where I need the ability to group Breakdown elements into multiple groups. See the example below. The catch is that I do not want to create a new indicator or breakdown that would require me to rerun score collections and I want to ...
