cancel
Showing results for 
Search instead for 
Did you mean: 

Clearing Alerts

Former Member
0 Kudos

Hi I have generated around 2300 alerts for conflicting t codes in CC 5.2....... Is there any way in which I can clear them all in shot...

Parveen

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member366047
Contributor
0 Kudos

Parveen-

You can clear them by erasing the data from the following tables with a SQL statement.

These are the tables that contain the alert logs:

VIRSA_CC_ALLASTRUN

VIRSA_CC_ALLISTDTL

VIRSA_CC_ALLISTHDR

VIRSA_CC_ALTCDLOG

Companies have different policies in erasing tables. Usually, you can do it with no hassle in Sandbox and most of time in Dev. But not in Q and Prod...

Ankur

GRC Consultant

former_member184114
Active Contributor
0 Kudos

I dont think so that you have that way of doing!

Regards,

Faisal