Resolved! Tables names that store the data presented in the User Analytics Experience Dashboard reports
Hi, does anyone know the tables names that store the data presented in the User Analytics Experience Dashboard reports?
Forum Posts
Table to see the history of users added and removed from the itil role in a range of dates
Hello everyone, I am searching on ServiceNow where to see the license consumption of users between July and December to make a report.So, I was wondering if there is a table to see the historic of users that were assigned and unassigned to itil rol...
Resolved! List report identifying reports within Service Now instance that are displaying a unique column
I'm needing to determine amongst all the reports within our instance of Service Now, which reports are displaying a specific column. Example, we have 17,000 reports in our instance. 9,400 are list reports. How many of these reports have selected to d...
How to add additional overall Dashboard filtering?
We currently have a Dashboard the is used extensively by multiple groups. It is our Day to Day operations Dashboard and the table source is Incident. There are multiple visualization reports/widgets and there is already Breakdown filtering at these L...
Can We Add Dynamic Info Message on Dashboard?
Hi All, We are want to add a dynamic info message on the dashboard header when the dashboard loads for the first time. (Refer to the Redbox in the screenshot below) Also, we have followed the below article to accomplish this requirement https://com...
Relative date filtering on reports
Hello: I am trying to display records with a specific date field value between today and 15 days from now and am unable to do that using the Between or Relative condition options on the report. There are more options when I use the filter options fro...
Possible? Multi-Level Pivot Tables w/no Columns
Hello, This question should be straightforward. I'm trying to create a pivot table that has rows but no columns. Please refer to the screenshot below for a visual. As you can see in the visual, this is a valid concept and could be used in reporting (...
Create Trend Definitions?
Is it possible to create new trend definitions to use in reports that use the trend condition in the filter? I can't find the table that would store these trend definitions. In this case, create a trend on 1/2 hour increment. Thanks!
Seeing multiple values of same name in the drop down in reporting
Hey there, I am struggling with a reporting issue here. I would like to understand more if that is a known issue or if I am doing it incorrectly. I am trying to make a report on particular variable of a catalog item but since the variable is multip...
Is there a way to add "Additional Comments" on the report conditions for incident cases?
Is anyone aware or know how to add Additional Comments in the report conditions for incident cases? We have some agents that are adding knowledge articles in their cases by simply providing the link to the article or typing the article number only in...
Option to find unused reports & Dashboards & Deactivate them
Hello Team, Is there any option available to find the unused reports and dashboards and deactivate them? I see more than 3000 Reports are not used for more than 2 years in our environment. these reports are not used and have a lot of flaws, so it ref...
Search bar missing within report on dashboard
I am building a dashboard. On one of the tabs I've inserted a report from the Report module (which simply displays a bunch of fields/data). I want the user to be able to search on a specific field (Configuration Item). The user wants to be able...
Create a list report on Performance Analytics
Hello, I need to do a static report based on Performance Analytics to have all request created for last month. I need to do it on list graph to be able to schedule an export on XLS file and send it by email. I was able to do it on a simple report but...
Resolved! How to filter out 'other' and add data table without chart in dashboard
Hello everyone, Hopefully someone can answer my 2 questions. 1st I want to to create a basic bar chart that shows me all the 'Requester countries' for the cases. On the surface that is simple enough but I have a lot of cases that have the 'Requester ...
Resolved! How to calculate old data values in a newly created metric definition.
Hi All, I have created a new metric for table change request -> field value duration -> on field state. The metric instances are getting created correctly from the time the metric definition was created . But our instance has changes being created fr...