Skip to Content
avatar image
Former Member

Can you extract a report of Monitor Tree Table Values?

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-

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers