I'm looking for a possibility to have an administrative look at the "whitelist" or "blacklist" a user can configure via the Presence User Options.
As far as I know it is not possible to view them on the Web GUI of the Presence server.
But I think it should be possible to view this with an SQL statement and the "run sql" command on CLI. Does anybody have any experiance with this and can help me?
I need this for troubleshooting.
run sql select * from pefilterinfo where pkid=(select fkpefilterinfo from epasprivacypolicy where fkenduser=(select pkid from enduser where userid='htluo'))
Replace 'htluo' with the user ID you want to query on.
Your Query gives this result:
pkid filterid filterdata isstandard datetimestamp
==================================== ======== ======================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== ========== =============