Query for EVNT's that have "Monitor MRT" and "fixed value" set

[Rick Murray]

Hello,

Does anyone have the sql available to check for EVNT's that have "Monitor MRT" and "fixed value" set, and be willing to share?

I need to check the settings for those that are hardcoded, and prefer not to go through close t0 300 EVNT's.

Yes, I admit to being query challenged when it comes to the AE database 

[Christoph Rekers]

Hi @Rick Murray

Depending on the "Calculation Method" and the "actions" the value is different. This SQL returns all EVNTs that have any MRT setting:

select oh_name, OH_MrtMethod from oh 
where OH_MrtMethod > '0' 
and oh_otype = 'EVNT' 
and oh_deleteflag = '0'
and oh_client = '1000'

This doesn't mention all value combination, but gives a bit of an overview: https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/21.0/DB%20Schema/db/_structure/HTML/OH.html

Cheers

Christoph 

------------------------------
----------------------------------------------------------------
Automic AE Consultant and Trainer since 2000
----------------------------------------------------------------
------------------------------

[Rick Murray]

Thanks Christoph 

Once I was in the correct table, I was able to retrieve the records needed.