Scott_Mick_6152

ORACLE SQL SCRIPTS

Discussion created by Scott_Mick_6152 on Mar 9, 2016
Latest reply on Mar 15, 2016 by Scott_Mick_6152
Is there a Oracle programmer out there?

I need to extract some information from the database that I can't get from the UI because of limits.  Does anybody have any query's created to get the following numbers?
How many folders
How many workflows
Number of executions in FEB 2016
Number of aborts
in FEB 2016
Number of users and how many logged in in Feb 2016
How many jobs ( I have this one...  (select count (*) from OH where OH_OType = 'JOBS'and OH_CLIENT = '1000'))

I have the link to the tables, below.

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

ANY help is greatly appreciated.






Outcomes