Groovy script for Oracle Datagurd status

In our initial research, the first method we tried (at a customer’s request) required elevated privileges, so we chose not to implement it. However, if you’re aware of a non-privileged method please send me a DM.

Thanks

Hi

I have checked Logicmonitor support team, they said that, as of now there is no datasource available for Oracle Dataguard monitoring

@Manog1978 this is correct.  I’m the Product Manager for the team that creates the official (non-Cloud) LogicModules.

@Patrick Rouse  : is there any alternate way workaround to achieves like custom SQL Script.

Please advise.

Nothing we’re currently aware of.  This is what we tried, but it required elevated Oracle permissions which we will not use.

https://forums.oracle.com/ords/apexds/post/check-status-of-sync-to-standby-7435

I have made custom SQl Script and got out put in the datasource. however, when i pull the data , am getting below error

Attribute not valid or not found in output - (method=namevalue, param)

any suggestion,

Want to share the script?

Here it is

sqlQuery = "select decode(synchronized,'YES',0,1) output from v\$archive_dest_status where type='PHYSICAL'"

in the datapoint i specified the output !=0.