Cool Solutions

Dynamic Workstation Group automatic creation from template for ZENworks Configuration Management


June 20, 2013 9:06 am





free/no warranty

Download coolsolutions-dynamic_groups

ZCM 11.x does not provide a scripting method for administrators to create multiple Dynamic Workstation Groups from a template. This script makes it easier for administrators to create multiple Dynamic groups from a template which includes, group name, group path, filter (device-hostname) and description.

The script is currently available only for Oracle database (SQL Server soon to follow)

Please post a comment for any specific template requests.

Refer to the README before using.

How to use:

Important: Take a reliable back up of the database before running the script.

Creating the template file

  1. Using any preferred spreadsheet software create a txt file (called requirement.txt) to contain the following information (Dynamic Group Name, Dynami Group Path, Hostname filter, Description of the group)
  2. Follow the following format for the requirement.txt file: Group_Name1,/~Devices~/~Workstations~/Folder,HostName1,Description[no commas inside description] See: dgtemplate_example.csv
  3. Place and requirement.txt in the same location
  4. Run: python
  5. dgtemplate.csv will be created in the above location

Running the Dynamic Group Create procedure in Oracle 11g on a Unix/Linux server. ZCM server can be running on either Windows or Linux

  1. DG folder has to be created by the Oracle user or any user that oracle database will have rights to.
  2. Copy dgtemplate.csv to /tmp/Dynamic_Group, make sure Oracle has rights to the file
  3. Run using any sql client DynamicGroupAuto.sql (make sure to edit the sql file in case the zenworks user is different from zenadmin [search the script for zenadmin])
0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Cool Tools, Technical, ZENworks Configuration Management

Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.