Centrally monitor alert subscriptions
We currently don't have a provision in the FNMEA UI where an Admin user can see which users are subscribed to an alert. As users come and go into an organization, how do the customer know and make sure a set of users are subscribed to receive alerts and keep this list updated with a set of active users.
For example: a user is a license server admin and is subscribed to an alert. The user leaves the company, how can we make sure there are other active users receiving alerts about this license server set.
JIRA request # FNMEA-14600 (IOJ-2116543)
Enhancement request # FNMEA-14597(IOJ-2116410)
1. Below SQL queries will check for the alerts for Inactive user's and delete them.
select * from PLT_Alert_Inbox where user_id in (select id from PLT_User where Active=0;
delete from PLT_Alert_Inbox where user_id in (select id from PLT_User where Active=0 ) ;
delete from PLT_Alert where ID not in (select Alert_id from PLT_Alert_Inbox );
2. Below SQL query will provide the email ID's subscribed for the Alert's for Inactive User's.
Select E.stringValue as Email_ID, U.USERID as User_Name
from PLT_USER U, PLT_ALERT_SUBSCRIPTION S, PLT_ALERT_HANDLERCONFIG H, PLT_ENTITYPROPSET ES, PLT_ENTITYPROP E
where S.ID = H.SUBSCRIPTION_ID and H.properties = ES.id and ES.id = E.id and E.name = 'toAddress' and U.ID = s.USER_ID and U.ACTIVE = 1