topic Row count alert for Oracle Table in AppD Archive

Row count alert for Oracle Table

CommunityUser — Wed, 26 Nov 2014 08:20:15 GMT

How can I get table row count in appdynamics for database for a particular table.

Can we get this shown in any of the page, or can we get an alert after every 30 nminutes or so.

Arun_Dasetty — Wed, 26 Nov 2014 11:48:22 GMT

Hi Nagendra,

Can you check if the following config referred in screenshot below is what you are looking for:

Regards,

Arun

CommunityUser — Wed, 26 Nov 2014 12:44:30 GMT

I did this, I also chose option as information only, but the last value was always 0. It is not giving any error too.

CommunityUser — Thu, 27 Nov 2014 05:36:30 GMT

Got it, The query is like this, without ";"

select count(*) from TABLENAME

And had to select tabular data as option.