Institutional Super User table and column

[Richard_King1]

In Configuration in the user setting screen there is a check box for "institutional Super User". I can't seem to find this in the tables anywhere. I would like to build a periodic audit report to make sure this check box has not been used for a user that shouldn't have it checked.

[Justin_Fandl]

Hey Richard,

When a user is marked as an Institutional Super User this flag is updated and stored within the useraccount table in the licenseflag column.

Hope this helps!

[Joel_Moore1]

Hi Richard,

I don't have an Institutional Database to test against, but we have it documented that when leveraging a level 2 Institutional Database, the institution column in the hsi.useraccount table will be set with a value of 99 for Institutional Super Users. This should work for that case:

SELECT username 

FROM hsi.useraccount 

WHERE institution = 99

Otherwise, the following query would need to be ran to return Institutional Super Users:

SELECT username 

FROM hsi.useraccount 

WHERE flags & 256 = 256

Hope this helps!

Best,

Joel