Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Platform Analytics: get data from pre-production instance

Tang Phat
Tera Contributor

Hi everyone,

 

Currently, my team runs ATF tests in pre-production instances such as Dev and QA. We want to display the analytics and reports of the test results in the Production instance. Is there any way to show the data from pre-prod instances on the prod dashboard?

My idea is that when the ATF test is completed, it will call the API from the Prod instance to pass the data to it. However, I'm not sure how to retrieve that data and display it in the dashboard components.

 

Any help would be appreciated.

1 ACCEPTED SOLUTION

Najmuddin Mohd
Mega Sage

Hi @Tang Phat ,

One thing that I can add here is, I believe the test results are stored in sys_atf_test_result table. 
Once an ATF is completed, probably when End Time is populated or Status is Success or Failure, you can create a Business rule to push the record in the same table in PROD instance, using Outbound REST Message, on which you can create reports.

Check out these two videos:

https://www.youtube.com/watch?v=pcuP6HP8QpA&list=PLKH9bPqlw1nfPpLULqorWsRiCKD2nNKUP&index=3


https://www.youtube.com/watch?v=es841K_rSms&list=PLKH9bPqlw1nfPpLULqorWsRiCKD2nNKUP&index=3

In the above, if you create an Incident, it will reflect in another ServiceNow instance, similarly you can try this usecase.

Just you need to exact trigger condition, which tells you, when the result is completed.

If the above information helps you, Kindly mark it as Helpful and Accept as a solution.
Regards,
Najmuddin.



View solution in original post

5 REPLIES 5

Ankur Bawiskar
Tera Patron
Tera Patron

@Tang Phat 

but why to see ATF test results in production.

What business problem it solves by showing these results to the stakeholders in dashboard?

The business team can always see the test results in QA or UAT instance

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi @Ankur Bawiskar, thank you for your reply.

Currently, the ATF tests run in pre-prod instances, and we can't require the business team to check each instance for results since they primarily work in the prod instance. Therefore, I wonder if we can integrate the test results from pre-prod into the prod instance.

@Tang Phat 

You can have a report in production which brings in data from pre-prod instance

But for this you will have to create a scripted REST API in pre-prod instance and invoke it from production and bring in the data and show it in report.

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Tang Phat 

Hope you are doing good.

Did my reply answer your question?

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader