Skip to Content
0

Can you extract a report of Monitor Tree Table Values?

May 30, 2017 at 06:21 AM

21

avatar image

Hi All,

Is there a way to get a daily/weekly extract of certain Tables and their record count, from the CPS Monitor Tree?

For example: rather then going into Monitor Tree each day to check the record count of the Table JCS_JOB0 (System -> Database -> Tables -> Sizes -> Scheduler -> Job:NumberofRows), I'd like to schedule a daily/weekly report that can be emailed to myself which will report the row count of this Table and/or other selected Tables of choice.

Whilst alerting is already in place when record counts breach a certain threshold, I'd still like to extract the values so that I can perform trend analysis on the growth of these Tables.

Any assistance will be appreciated.

Thanx.

-Vinit-

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers