SQL: get an email notification when the Archer table crosses a certain threshold

[Ajeet]

We have some issues with db migrations causing the queuing service to get backed up and we ended up with millions of queued records that weren’t getting indexed for Archer’s search function. We’d like to find a way to monitor the size of the search queue table so if something like this happens again we can act on it sooner.

@DavidPetty @Ilya_Khen @Ilya.Khen 

[Ilya_Khen]

@Ajeet,

You can find the table to check from this article: https://www.archerirm.community/t5/knowledge-base/how-to-perform-a-search-index-rebuild-in-the-rsa-archer-suite/ta-p/4469

Btw, I think this topic is in a bit wrong place, it supposed to be under Archer, not SecureID.

[Ajeet]

iam not able to access this link after activation my Archer account. can you please let me know how i can get the privileges to access this?

[Ilya_Khen]

See if this link is open for you: https://www.archerirm.community/t5/archer-community-help/how-to-activate-your-archer-community-account/ba-p/670979

If not, send email to Support or community.support@archerirm.com