List of accounts with RADIUS User Attributes defined

[Steven.Green]

I am preparing to migrate an Active Directory integrated Identity Source to the internal database and am looking for a way to list up all of the user accounts that have a RADIUS User Attribute defined in the Authentication Settings..

I do not find any report or AMBA commands that will do this.

Is there any ways to find these user accounts other than manually looking at each accounts Authentication Settings?

[DavidAllison · Accepted solution]

Did you try List All User Alias or List All User With Assigned RADIUS Profile?  There's a chart on this page that lists all the data fields available in each of the Security Console reports:  https://community.rsa.com/t5/securid-discussions/data-fields-available-in-auth-manager-security-console-reports/m-p/600014

There is also the data field RADIUS_PROFILE_ID available if you're doing SQL queries, but I believe it's no different than User RADIUS Profile in the List All User Alias report.

[Steven.Green]

Thank you @DavidAllison

I have looked at both of those reports and they do include the RADIUS Profile, however, I am looking for RADIUS User Attributes that are set under Authentication Settings.

I've attached a screenshot of an example of a Class that was set.

[DavidAllison]

Steven:  In that case we might need to run a SQL query to get the data.  I would think that one of the three data fields indicated with red arrows in the screenshot below would have this information.  One of the attachments  in the article I linked above talks about running SQL queries directly from Excel using a read-only DB connection.