Dan_Moore_7725

SQL query that will list all objects with no statistics that are marked as Inactive within jobplans

Discussion created by Dan_Moore_7725 on Jun 20, 2016
Latest reply on Jul 12, 2016 by Frank_Goodwin_981
We recently received this question in a request; What is a SQL query that will list all objects with no statistics that are marked as Inactive within job plans.  Currently there is no Out of the Box way to do this and Support usually only provides SQL scripts for troubleshooting due to the unforeseen consequences this can have on a Production system.

I'm opening this post so that anyone with the custom SQL or any other methods can possibly assist with this.

Also, all tables can be found in the Documentation at the following:

http://docs.automic.com/documentation/AE/11.2/english/AE_DB_TABLES/tables/index.htm

As always we suggest this is done in a Test Environment first to ensure there is no interruption to your Production Environment.

SQL query that will list all objects with no statistics that are marked as Inactive within jobplans


Outcomes