Hyland

Michael_Newton · ‎05-23-2024

Title says it all. Looking for a SQL query that reports a list of individual users that have access to a doctype, the query would need to sift through the groups that have access to said doc type in order to come up with a definitive list. It would be awesome if the query showed what group the user belonged to as well which was granting them access to said doc type.

Thank you for any assistance you can provide!

Larissa_Armand · ‎05-23-2024

Hi Michael,

This is what i use on a reporting dashboard:

select rtrim(G.USERGROUPNAME) as GroupName, trim(U.USERNAME), trim(U.REALNAME), rtrim(D.ITEMTYPENAME) as DocTypeName, U.LASTLOGON, U.DISABLELOGIN
from HSI.USERGROUPCONFIG X
left outer join HSI.USERGROUP G ON X.USERGROUPNUM = G.USERGROUPNUM
left outer join HSI.DOCTYPE D ON D.ITEMTYPENUM = X.ITEMTYPENUM
left outer join HSI.USERXUSERGROUP UXG ON UXG.USERGROUPNUM = G.USERGROUPNUM
left outer join HSI.USERACCOUNT U ON UXG.USERNUM = U.USERNUM
where trim(D.ITEMTYPENAME) = @{pConfigItemName}
and trim(G.USERGROUPNAME) != 'MANAGER'

My data provider has a select list for the parameter so you can choose which document type you want from a list. https://support.hyland.com/r/OnBase/Reporting-Dashboards/English/Foundation-22.1/Reporting-Dashboard...

View answer in original post

Kim_Schmidt · ‎05-28-2024

Hi Brent, I am also looking to query that same information, would you be willing to send the query over to me as well? kimrolandplus3@gmail.com

Thank you!

Emily_Raben · ‎06-07-2024

@Brent Fuller Can you please share the query with me as well? emilyraben@gmail.com Thank you!

Paul_Richardso1 · ‎06-10-2024

Hi Brent, would you send it to me as well? pr4402118@gmail.com Thanks!

ALISON_WOOD · ‎06-10-2024

Hi Brent!

Could I also get a copy of you SQL?

awood@resurgent.com

Thanks so much! 🙂

Lynn_Slaga · ‎06-10-2024

I would be interested too: lynn@vailresorts.com

Hyland

SQL query that reports a list of individual users that have access to any given doctype