02-21-2019 07:59 AM
I want to find out all users KID that have security keyword setup and the keyword and values for it. Is there a way to find out through database SQL query?
example:
User's KID = patela123
Security Key word = Department
Keyword Value for Department Keyword = MCIT
Any suggestions?
Thanks
Anil Patel
02-25-2019 05:52 AM
Hi Anil,
I believe this query should help you obtain this information:
SELECT
ua.username AS 'KID'
,kt.keytype AS 'Security Keyword'
,sc.keyvaluechar AS 'Security Value'
FROM
hsi.useraccountseckeys sc
JOIN hsi.keytypetable kt ON sc.keytypenum = kt.keytypenum
JOIN hsi.useraccount ua ON sc.usernum = ua.usernum
Please let me know if this is helpful.
Best,
Joel
02-25-2019 06:28 AM
Joel
Thanks you so much for your help, it works.
I just need to make some change in quotation mark and join the values as
SELECT ua.username as KID, kt.keytype AS SecurityKeyword, sc.keyvaluechar AS SecurityValue FROM hsi.useraccountseckeys sc
JOIN hsi.keytypetable kt ON sc.keytypenum = kt.keytypenum
JOIN hsi.useraccount ua ON sc.usernum = ua.usernum
Appreciates for your help
Have a great day
Thanks
Anil Patel
02-25-2019 06:32 AM
Joel
One more question:
If security keyword is set on OnBase User group level, how can I find the similar information from user group level?
Thanks
Anil
02-25-2019 06:44 AM
You are the best
Both query works for me
Thanks
Anil Patel
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.