ATF Data Model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-06-2025 08:24 AM
Is there a Data Model document for ATF like the one that was created for Test Managment 2.0?
I want to know what all of the tables are that ATF uses and how they interconnect.
I am trying to create reports for some of our ATF suites to show the trend of how they perform on our sub-prod environments. Ultimately, I want to be able to do this from our production environment and display the reports on a dashboard.
Thank you for your help!
- Labels:
-
Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-06-2025 08:25 AM
Hi @Dave65
Might be a good read
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2025 06:46 AM
@Dave65 wrote:Is there a Data Model document for ATF like the one that was created for Test Managment 2.0?
I want to know what all of the tables are that ATF uses and how they interconnect.
I am trying to create reports for some of our ATF suites to show the trend of how they perform on our sub-prod environments. Ultimately, I want to be able to do this from our production environment and display the reports on a dashboard.
Thank you for your help!
There isn’t a dedicated data model document for ATF similar to Test Management 2.0, you can explore table relationships using ServiceNow’s Schema Map feature. This tool provides a visual representation of how ATF tables interconnect, helping you understand their structure and dependencies.
To create performance trend reports for your ATF test suites and display them on a dashboard in your production environment, you first need to identify the relevant ATF tables.
These typically include those that store test executions, pass/fail statuses, and suite details. Next, consider setting up data replication or an Extract, Transform, Load (ETL) process to transfer ATF data from your sub-production environments to your production instance. This ensures that you have all necessary information consolidated in one place for analysis.
Once the data is available, you can use ServiceNow’s reporting tools to develop performance trend reports, focusing on key metrics such as test execution times, success rates, and failure trends.
