Realtime reporting

meher Jammula · ‎03-14-2022

Hi team,

I want to understand the following items

- Does ServiceNow provide real-time reporting in their analytics?

- If yes, does this real-time reporting work for all the tables? or is it restricted to certain tables?

- if not, what's that syn time of the data in the service, not analytics?

-i.e. If a user creates a ticket in the tool, how much time would it take for the analytics module to reflect the data?

jeffrubinoff · ‎03-16-2022

Further information:
A senior support engineer informs me that only a few of the largest customers are using read replicas. So unless your tables are running well into the millions of active records each, you are unlikely to have it.

Even if you do have read replicas, if you were experiencing reporting lags because of them, this would be an issue and Support would attempt to resolve it.

As far as we know, no other table than a read replica can even potentially exist as an intermediary between the report and the backend. And in any case, no lag is expected.

So tl;dr: The report refers to the same live fact table in the backend.

Regarding historical data:

There is no limit to the historical data in a report. The data that the report fetches depends on the conditions that you create. However, if you fetch 10 years of data and that is 5-10 millions of records and then you try to trend on it, that report will be very slow.

View solution in original post

jeffrubinoff · ‎03-14-2022

Hello meher,

It took me a minute to parse your question, so excuse me if I start from the basics.

The current implementation of Performance Analytics and Reporting has two main components: Performance Analytics indicators and Reports.

Reports only show the real-time values of the facts tables. Performance Analytics shows trends, forecasts, past values, and all other details across time. Please see Reporting compared to Performance Analytics.

A Performance Analytics indicator (KPI) can show real-time scores depending on the configuration of the indicator and how you are viewing it. As far as I know, there are no facts table restrictions, only indicator source, indicator, and widget-level ones. See Real-time scores. IMO, as these values can differ qualitatively from collected scores, I would be cautious using them to track progress, evaluate trends, etc.

I'm not sure what you mean by "syn time of the service." There's nothing to sync. You are seeing directly what the values are in the facts table at the time you opened the Analytics Hub/KPI Details/Dashboard. To be absolutely certain, you can refresh your browser tab.

meher Jammula · ‎03-14-2022

I'm not sure what you mean by "syn time of the service." There's nothing to sync. You directly see the values in the facts table when you open the Analytics Hub/KPI Details/Dashboard. To be specific, you can refresh your browser tab.

Hi@ jeffrubinoff

Let me clarify the above point.

Imagine that you have a table being created in the backend whenever a user is creating incidents in the tool

id	severity	created timestamp
1	High	2022-03-14 22:23:44
2	High	2022-03-14 22:23:45
3	low	2022-03-14 22:23:46
4	low	2022-03-14 22:23:47
5	low	2022-03-14 22:23:48

Let's say if the IT service manager logs into reports or performance analytics module at 2022-03-14 22:23:49 to see the total list of incidents created

- will he be able to see/ count the ticket id 5?

Is this quick sync, or will it take some time, like 5 min or 10 min, to get the data to the reports module?

I hope I have conveyed it now. if not, please let me know

jeffrubinoff · ‎03-14-2022

I'm still rather confused. I think however it's normally a matter of milliseconds for a record to be created on a facts table after the Submit button is clicked on a form, and I believe Reports query the table as soon as you open the Report. This is why I mentioned refreshing the page to be sure. Certainly on my own reports, when I change the status of a Documentation request, the change is in my report when I navigate back to my dashboard and refresh the page. But I have asked the developers to be sure.

meher Jammula · ‎03-14-2022

Yeah, with one click of a button, the record is submitted to the fact table.

But my question is whenever the user tries to open a report, whether reports also refer to the exact live fact table in the backend?

Or will there be any other table referred for reports, and the referred table gets updated every 5 or 10 minutes with the records from the actual fact table?

Another attached question.

How long is your historical data in the reports? can I fetch the past 10 years of data in the report? (or) is that data restricted to certain timeperiod

Actually the devs can answer the above questions