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
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
Once I was in the correct table, I was able to retrieve the records needed.