Forum Discussion

JohannJ's avatar
JohannJ
New Contributor II
9 months ago

Extract detailed user info with business rule

Hi, For user maintenance purposes we'd like to extract information like user email address etc, using business rules. I've tried using BRApi.Security.Admin.* but that only seems to support extrac...
Admin
System
  • Krishna's avatar
    Krishna
    9 months ago

    JohannJ  - 

     

    BR

    Dim objGroupInfo As GroupInfo = BRApi.Security.Admin.GetGroup(si, secGroupName)

    Dim objUserInfo As UserInfo = BRApi.Security.Admin.GetUser(si, userName)


    SQL

    SELECT S.UniqueID as UserID , S.Name as Username, G.Name As GroupName
    FROM SECUSER S JOIN SECGROUPCHILD SG
    ON S.UniqueID = SG.CHILDKEY
    JOIN SECGROUP G
    ON SG.GROUPKEY = G.UniqueID

Krishna's avatar
Krishna
Valued Contributor
9 months ago

JohannJ  - 

 

BR

Dim objGroupInfo As GroupInfo = BRApi.Security.Admin.GetGroup(si, secGroupName)

Dim objUserInfo As UserInfo = BRApi.Security.Admin.GetUser(si, userName)


SQL

SELECT S.UniqueID as UserID , S.Name as Username, G.Name As GroupName
FROM SECUSER S JOIN SECGROUPCHILD SG
ON S.UniqueID = SG.CHILDKEY
JOIN SECGROUP G
ON SG.GROUPKEY = G.UniqueID