Grouper Users - Open Discussion List

[Andrew Jason Morgan <>]

Hi Siju,

We have something like this in our Python wrapper library at https://github.com/OSU-IAM/pygrouper.

It constructs this parameter:

'WsRestGetMembersLiteRequest': {

                'pointInTimeFrom': pitfrom,

                'pointInTimeTo': pitto

}

where pitfrom and pitto are formatted as 'yyyy/MM/dd HH:mm:ss.SSS'.

Then it makes a POST to https://{host}/grouper-ws/servicesRest/json/{ws_version}/groups/{groupname}/members.

Note: If you specify a time range by using separate values for pitfrom and pitto, it will return everyone that was a member of the group during that time range.  I don't think it tells you when the member was added.

We also wrote a Python script that makes SQL calls to return the audit trail for a single user or group.  The core Python code is:

def get_log(db, id, mode, filter=None):

      user_where = "string04 = (SELECT ID FROM GROUPER_MEMBERS WHERE subject_id = :id)"

      group_where = "string06 = :id OR string07 = :id"

      where = group_where if mode == 'group' else user_where

      cursor = db.cursor()

      query = f"""

        SELECT

          created_on,

          description

        FROM GROUPER_AUDIT_ENTRY

        WHERE

          {where}

        ORDER BY created_on"""

      cursor.execute(query, id=id)

      return cursor.fetchall()

I hope this helps!

​Andy Morgan, Identity & Access Management, IT Operations and Identity

Oregon State University | University Information and Technology | 541-737-8877

---

From: <> on behalf of Siju Jacob <>
Sent: Wednesday, September 29, 2021 2:09 PM
To: <>
Cc: Nazeer Syed <>
Subject: [grouper-users] Grouper 2.4 webservice to get members of a group filtered on point in time from and to

 

[This email originated from outside of OSU. Use caution with links and attachments.]

Hi Team,

    We are using Grouper 2.4 and looking for a webservice to find members in a group, filtered on point in time from and to.

We need the PIT information in response as well.

Tried the below rest service with a JSON request, it’s not working. Can someone point me to the right service with  correct JSON request.

Also is there a webservice or shell script to read the change log info.

 

grouper-ws/servicesRest/v2_4_000/groups

 

{

  "WsRestGetMembersRequest":{

    "wsGroupLookups":[

      {

        "groupName":"apps:XXXX:RU_Group_name"

      }

    ]

    ,

      "subjectAttributeNames":[

      "description",

      "loginid",

      "name"

    ]

    ,

    "pointInTimeFrom":"2020/01/01 01:01:03",

    "pointInTimeRetrieve":"T",

    "pointInTimeTo":"2021/07/01 01:01:03"

  }

}

 

 

Thanks,

Siju Jacob