Find who are administratos

other Business Query
1

I am trying to write a query in BO query builder to find all the users and if they are members of administrator group.

Basically I want to find who are all administartors.

I am trying to do
select * from OBJ_M_ACTOR.

But this doesnt work.

How can I write a query in qury builder.

Thanks,
H

hourigan (BOB member since 2007-04-06)

2

Hi,

Please let us know which BO version you use because there is some confusion in your post:

  • query builder is in a BO XI r2 version
    while
  • OBJ_M_ACTOR is a table that exists in a BO repository of the version 6.5 and below

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

If you are indeed using BO-XI, then your query would be similar to this…

Select SI_ID, SI_NAME, SI_USERFULLNAME From CI_SYSTEMOBJECTS Where SI_KIND='User' 
And SELECTUSINGPROPERTY(2,SI_ID,SI_GROUP_MEMBERS,SI_ID) Order By SI_NAME

That assumes you have an Administrators type group, and that you know the ID of that group (you can get that thru the CMC or by running a query to find your group id.

My Administrators group is queried with the “2” in the example above.

Good luck,
Brent

bdouglas :switzerland: (BOB member since 2002-08-29)