Report

[geogeorge]

Hello everyone,

We are planning to generate reports on the admin users present in our lower environments, testing, and production. Whenever a user refreshes the report, it should trigger an integration that retrieves the data from the instances. Is it possible to implement this?

[Ankur Bawiskar]

@geogeorge 

yes it's possible but you will have to store the data somewhere so that it can be rendered in your dashboard/report.

where are you storing that?

You can consume endpoint of DEV, TEST from production and show the data but the main question is where are you planning to store that

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@geogeorge 

you can use Remote table to hold data in production from lower environment

Then see if you can report on that remote table

refer this link on how to populate the remote table

ServiceNow Get started with Remote Table 

Example 1: Retrieving all incident records from an external source 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[geogeorge]

The problem is that we are not able to create any new tables but is it possible to store it somewhere? 

Or is it possible to get the data from lower instance table itself.

[Ankur Bawiskar]

@geogeorge 

did you check the above comment where I mentioned about using remote table?

If my response helped please mark it correct and close the thread so that it benefits future readers.