
kamleshpatel87134 (Adani Enterprise Ltd) asked a question.
How we can get the report who having not any auth method assignment. Please suggest
RSA customers who leverage RSA ID Plus for Salesforce single sign-on (SSO) may be impacted by a Salesforce security change relating to Device Activation.
More Details
kamleshpatel87134 (Adani Enterprise Ltd) asked a question.
@kamleshpatel87134 (Adani Enterprise Ltd) ,
If there is not a canned report in the Security Console, then you will need to run a custom SQL query against the database for a list of users who do not have an authenticator assigned to them. You can run a tool like pgAdmin to get a list of tables and fields in the database so you can build a query.
Use this article for information on how to connect to and to query the Authentication Manager 8.x database.
Some sample queries include:
SELECT serial_number FROM rsa_rep.am_token limit 10;
SELECT am_token.token_type, am_token.serial_number, am_token.imported_on, am_token.assigned_by, am_token.extend_token_sn, am_token.orig_token_shutdown_date, am_token.tokenextend_updated_date, am_token.extension_mode, am_token.token_shutdown_date FROM rsa_rep.am_token;