VERIFIED SOLUTION i

How to get a list of users who do not belong to any authorization pool in PI Officemail

How to get a list of users who do not belong to any authorisation pool  in Officemail?

System admin defined on Admin Webiste under Options | Email | Administrator email, should receive the email titled "Users have auth-required roles but do not belong to any authorisation pool" that contains the list of users. Please double check if email has been received. 
There is also a way to get the content of this email body from the database at [PIOfficeMail].[dbo].[OMEMails] on SQL server in the admin server. The email body is formatted by HTML tags.
You can use the following query to list the emails:
 
select * from [PIOfficeMail].[dbo].[OMEMails]
where subject like 'Users have%'
Environment Details
Product Feature: Admin Website

 
UPDATED:  August 9, 2017