
kamleshpatel87134 (Adani Enterprise Ltd) asked a question.
How we can get the report who having not any auth method assignment. Please suggest
Salesforce now requires MFA validation for all SSO users. Please read the advisory below for further information on required actions to avoid login failures.
Read the Advisory
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;