1 Reply Latest reply: Nov 12, 2012 1:51 PM by JohnGoodwin RSS

    List out all the groups with access to a planning application

    840367
      Hi All,

      I am trying to get the list of all user groups that have access to a particular planning application. Is there an easy way to do this than going to each group and monitor their provisioning reports.

      I have like a 100 groups to do this.

      Any suggestion would be greatly appreciated
        • 1. Re: List out all the groups with access to a planning application
          JohnGoodwin
          Which version are you running, to simplify matters it may be possible to write a query.

          If on 11.1.2.x then you could run something simple against the shared services database e.g.

          select substr(prov.application_id,4) as "App Name",grps.name as "Group Name" from
          css_provisioning_info prov, css_groups grps
          where prov.member_identity = grps.identity_id
          and prov.application_id like 'HP%'
          and prov.member_type=2

          That would return all the planning apps and groups that have access to the planning application.

          Cheers

          John
          http://john-goodwin.blogspot.com/