How do I query the list of users in my Biotics instance :

How can we help you today?

How do I query the list of users in my Biotics instance Print

Modified on: Tue, 24 Feb, 2026 at 12:26 PM

You need to use quotes around the fieldname:

select "User_ID", "Username", "Full Name", "E-mail" from SECURITY_USERS_VW where "Active" = 'Yes'

In Biotics 6, this view has been expanded to reflect the User Groups each user is assigned to. So, for example, you could determine your Biotics Administators by running the following query:

select * from security_users_vw where "Active" = 'Yes' and "Groups" like '%Administrators%'

Did you find it helpful? Yes No

How can we help you today?

How do I query the list of users in my Biotics instance Print

Related Articles