licenseflag column in hsi.useraccount

[Denise_Gemesio]

Dear Hyland team,

We developped a script that allows us to alert us if some users are locked. Until now, we only used the "disablelogin = 1" to tell us this. However, the "deactivated" users too are part of the list. I was then wondering what meant the "licenseflag = 2"? Is there some document where we can find this information?

Thank you very much 🙂
Denise

[Paul_Lloyd]

The useraccount.licenseflag field is a bitmap field.

It can contain many different bit values, but the bit value for deactivated users is 2. 

Since it's a bitmap you can't just look for licenseflag=2 because there may be additional bit values set.

Instead use a bitwise AND to retrieve all rows where the deactivated users flag is set.

Bitwise operations are different for SQL Server and Oracle.

For SQL Server, this query will retrieve all deactivated users:

select * from hsi.useraccount

where (licenseflag & 2 > 0)

For Oracle, this query:

select * from hsi.useraccount
where bitand(licenseflag, 2) > 0

[James_Armstrong]

This is very helpful!

Is there a similar type of query that can pull the user list and their associated permissions? We're trying to get to a place where we can pull a usable/readable user list and identify who are power users/admins.

We've got lots of new staff and this would help to identify who to reach out to in the OB user base to inform them of maintenance, patching, issues/outages, etc.

[Eric_Beavers]

@James A. 

There is a treasure trove of Report Services exports still available at Report Services Export Files (hyland.com)

**NOTE**: This export file was created at the time of Report Services’ deprecation. It is available for download and use as-is, and will not be tested or supported by Hyland. 

The main purpose of this file is that these can be imported into reporting dashboards as data providers.

However, you can also open the XML files with a text editor and review the queries.

For your question above I recommend taking a look at ConfigurationReports.xml, then the child node of CONF012.

"Lists the security configuration and feature access of the selected OnBase User Group. For best results, group by User Group and Category."

[Melissa_Foster]

I posted the query from the User Group config report here: 

https://community.hyland.com/en/ideas/idea/84088-user-privileges-product-rights-data-provider#fce937...