Hello all,Does anyone know which filter conditions to use in the SN Repport Designer to produce the following report - Incorrect downstream CI relationships for Database Instances. I have attached the screenshot for the report I run, I wonder if it i...
I have recently created a Formula Indicator which works out a percentage for % successful changes which needs to be filtered via Breakdowns over two layers. the formula is simply [number of successful changes / month SUM +] / [total number of changes...
Hi All,How can we access the tables using the ODBC. we are looking to pull(incidents) data from servicenow for client PowerBI?Can someone please help me.Thank you in advance.
Hello all,Does anyone know which filter conditions to use in the SN Repport Designer to produce the following report - Incorrect downstream CI relationships for Database Instances. I have attached the screenshot for the report I run.Thank you for you...
I would like to present data from both Automated and Manual Indicators on the same widget, with a single breakdown by Assignment group. I created three Manual Indicators, each using the "Assignment group" automated breakdown. This seemed to work fin...
hi there, We have a report requirement to split the values of a comma separated field and then display it to a report.For example, data in servicenow looks like:NumberAffectedCIINC00123CI1, CI2 We want to create a report that shows this instead:Numbe...
Hey folks - I'm working on a special project for a blog post I was hoping to post here, but I ran into a speed bump. I'm making an indicator that trends a database size. The source data's size value comes in as MB and is typically 6-7 digits, tho it ...
I am trying to display two different data sets over time and want to display the percent of one against the other. For example, if I have the total number of tickets as a bar or spline chart, and then add a dataset of tickets that contain John. I w...
Hi All, I have the below requirement to be implemented on Reports : I tried creating DB views between the group table and the Incident table,but that did not helped me to calculate the count and the percentage. I need this report on a Excel List for...
Can we automatically generate reports on all the CMDB tables based on the table size?How this can be achieve?Please assist.
Hello,I want to extend the VACreateUtil script with some other variables (the original one does not hand over SO). But as I extend the script with the service_offering variable (defined in flow) it doesnt appear in the incident afterwards. Can you m...
Hi, I need the list of different roles which comes out of the box with platform analytics workspace. How can I fetch it? Thanks.
Hi all, I have scheduled chat queue entry table report daily. Report has data but when it is being exported in scheduled report data is unavailable in excel. Can anyone please help me. Previously it was working fine. There was no changes done in the ...
What is the difference between these two fields?
Hi Community, I need to track the following metric in an indicator for Performance Analytics: If a specific value is updated on a record, track that change,Use case is on the sn_gf_goal table - I want to track changes to the actual value field ...
