SQL query to report on Network Security settings in the database

[Peter_Scaramuzz]

Can anyone tell me what table the Network Security settings (under Config>Utils>Network Security menu) can be found? I want to run a query to get the full list.

[AdamShaneHyland]

Hi Peter,

When you say "get the full list", what are you referring to?

Thanks,

[Peter_Scaramuzz]

I want all the settings. So currently we are using Active Directory authentication. So I want the list of active directory keys matched to the user groups they are assigned to. We have a huge list and disparity between Test and Prod so want to look over the lists.

BTW, by full list I am really referring to a query of the table. I have been scouring the database and can't find where that information lives.

[AdamShaneHyland · Accepted solution]

Hi Peter.

The usergroupnum to SID mapping is in the hsi.secprincipal table.

Take care.

[Peter_Scaramuzz]

Ah! That's the table where that info lives! Thanks!!!!