Highlighted
Respected Contributor.
Respected Contributor.
151 views

Is there a way to create Org Units , Resource Pools and Security Groups via scripts.

Is there a way to create Org Units , Resource Pools and Security Groups via  Insert/ Update scripts. Has anyone implemented this?

0 Likes
2 Replies
Highlighted
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

Re: Is there a way to create Org Units , Resource Pools and Security Groups via scripts.

Hello Urva,

Uploading data via scripts is nice as long as data is inserted in all relevant tables. I would recommend to use interface tables for data mgmt whereever possible.

For e.g. for Org units, you can upload the data to KRSC_ORG_UNITS_INT table Instead of scripts. Once uploaded you can run "Run PPM Organization Unit Interface" report to create the Org Units. Additionally you can use "KRSC_ORG_UNIT_MEMBERS_INT" table for inserting members to org units through interface tables.

For Security Group, you can insert data into knta_security_groups_nls using the sequence "KNTA_SECURITY_GROUPS_S". Also to add the access grants to security group you need to insert data to "knta_access_security" table using data from table knta_access_grants_nls.
This is rather a tedious way.
If you have a non-prod instance then I would recommend to create the security group and add the access grants manually. Once created you can then create these groups in Prod by migrating a dummy workflow. The newly created security group should be part of the dummy workflow.

Creating Resource Pools and configuring resource participation in the pool can be tricky. Tables involved here are RSC_RESOURCE_POOLS, RSC_RP_DISTRIBUTION_ENTRIES.

Hope this helps in providing you insight on how data is stored within PPM.

Regards,
Mehul Shah
Microfocus SaaS Operations Lead

Respected Contributor.
Respected Contributor.

Re: Is there a way to create Org Units , Resource Pools and Security Groups via scripts.

Thanks Mehul. This is helpful, we are building these scripts and testing them in lower environments before making any changes in production environment. Ultimately these scripts will also be shared with the MF TSC for review to ensure appropriate tables are updated.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.