Row count alert for Oracle Table

[CommunityUser]

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]

Hi Nagendra,

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

Also refer doc https://docs.appdynamics.com/display/ADDB/Configure+a+Custom+SQL+Alert

https://docs.appdynamics.com/pages/viewpage.action?pageId=18983925

https://docs.appdynamics.com/display/ADDB/Custom+SQL+Alerts+for+SQL+Server

Regards,

Arun

[CommunityUser]

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 · Accepted solution]

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

select count(*) from TABLENAME

And had to select tabular data as option.