Database View For Business Applications Moving to In Production

[adamtoth]

Hello,

Is it possible to create a database view between the Business Application table and the Sys Audit table. The goal is for someone to be able to view the Business Applications that have move to CI Status = In Production over a certain period of time. The Sys Audit table of course is massive and I'm not sure this is practical.

Thank you,

Adam

[Dr Atul G- LNG]

Yes, you can achieve it using sys_audit, but querying the audit table directly can have an impact on system performance.

What is your specific requirement or use case? Depending on what you need to achieve, we can look for a more efficient approach. @adamtoth 

[adamtoth]

The goal is for someone to be able to view the Business Applications that have move to CI Status = In Production over a certain period of time. 

[Dr Atul G- LNG]

You can create a Metric Definition for the same requirement and then create a report based on the metric data. This would be a better approach than querying sys_audit directly. 

https://www.servicenow.com/docs/r/platform-administration/create-metric.html

[Dr Atul G- LNG]

https://youtu.be/Dnr6Tcblv5M