Out of band detection setting column in database

[sakshibansal]

Hello,

I am trying to look for DB column where the out of band detection setting is enabled. I couldn't find it in endpoints table.

Could you please provide the SQL query to check the same.

[RakeshMG]

Please check if the configuration table is exposed in your Data analyzer. 

If yes, please use following query : select * from configuration where name like '%outofband%'.

Value will be stored in column "CONFIGDATA".

[sakshibansal]

I couldn't see this in Data Analyzer, but checked in Analytics. It doesn't show in which endpoint this setting is enabled. So, how to check it?

[RakeshMG]

The numeric value is endpoint key. You can find with it.

[sakshibansal]

The numeric values are not the actual endpoint key where out of band detection is enabled.

[RakeshMG]

Numeric value in Name column is endpoint key

[sakshibansal]

Hi,

It isn't correct.

I verified the numeric values against the endpointkey and none of them had the below config set in those endpoints.

[vivekmohanty_pm]

@sakshibansal

select configdata from configuration where name = (select concat(endpointkey,'_OUTOFBANDACTION') from endpoints where ENDPOINTNAME = '<Enter the Endpoint name here>');