For some reason 'Business Elapsed Percentage' is not displaying the progress bar for reports using the Incident SLA table whilst it is for those using Task SLA I'm certain it has worked correctly for reports on the Incident SLA previously. Please see...
I need to be able to analyze which users are accessing/using a given table. I know I can find this information in syslog_transactions; however, that cannot be reported against and any list query with a date range longer than about 7 days just times ...
I need to create a report that will show the duration of time it took for 'assigned_to' to be populated after the assignment group has changed to a different group from previous. Would I be able to utilize the existing 'Assigned to Duration' metric o...
Hi, We have requirement to capture the state field value duration in Risk events table and do the reporting on the same . I know this can be achieved through OOTB metric definition and creating Database view. But client requirement is to achieve thi...
Hello, I'm trying to build a report that shows incidents resolved the past weekend only, meaning after 5 PM Friday and before 8 AM Monday morning for example. I tried using 'trend > on or after Friday and on or before Sunday' but am getting blank re...
Hi Community! Does anyone know if it's possible, in the Reports Application, when creating a bar chart, to group by whether a text field contains a particular word? I want to see a bar chart with two columns: One for all the incidents where the s...
We are looking for a way to display the RITM stage information in a custom report showing the information of each stage separately that allows us to condition according to the value of each stage. Example:We need to identify how many completed RITMs ...
Trying to create a dynamic filter on a custom table 'BTSS Case'. I am trying to create filter using which I will be able to filter all records in the table which have the country same as mine.. I have created the following script include: and refere...
This graph doesn't show any data. I followed all the steps like 1)Similarity Solution - OOB one 2)Clustering solution - OOB one 3)Ran the scheduled job '[Knowledge Curation]: Generate HR Case Clusters' Still not getting any data in the table 'kb_task...
Hi,I need to create SLA PA indicators for SLA achievement per HR Service. SLA data is stored in task_sla table and hr services are stored in sn_hr_core_service table. Is there any way to do that differently than creation of database view?I tired to c...
Hello community,I need to understand what the Territory_admin role gives the user, but I couldn't find what capability it offers.
Hello community! I'm trying to create a new interactive filter for my dashboard and the information it shows is all the data that my clients have uploaded to each company's portal. How can I generate a single information panel with a client filter an...
I was given the option by ServiceNow to default large files to be emailed to me. At that time it was a lot easier to get an email so I defaulted to that rather than waiting. That way I could keep working. However I'm now finding that in some cases th...
Today in PA Academy we discussed using Database Views to join regular tables to other places we need to gather data. Here are a couple of examples which work in my implementation. Join Incident/Task to custom table (the table is used to accommodate a...
Hi all, I am new to ServiceNow. I am trying to generate a report that shows the inflow of incidents to a particular group and outflow of incidents from that particular day on a daily basis. I am fine if these reports are separate as well. This must b...