Tool

(View Disclaimer)

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 dynamic_group.py and requirement.txt in the same location
4. Run: python dynamic_group.py
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])

Disclaimer: As with everything else at Cool Solutions, this content is definitely not supported by Novell (so don't even think of calling Support if you try something and it blows up).

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, test, test before you do anything drastic with it.