Skip to main content

Build and Map Information Base Categories from CWM(board-Type-SubType)

Summary

This script will create information base categories (ticket categories) for every imported manage board.

Time Saved by Automation: 30 Minutes

Sample Run

Sample Run

Dependencies

The CW Manage Plugin should be configured.

Variables

Variable NameDescription
InfoCatsThis variable stores the results of the SQL query which fetches the info categories.
UpdateExistingInfoCatsThis variable stores the results of the SQL query which updates the info base categories.

Global Parameters

NameExampleRequiredDescription
I have backed up the db1TrueThis indicates that the DB has been backed up prior to making any changes to the Infobase categories.

Process

This script will create information base categories (ticket categories) for every imported manage board. It runs three SQL queries to retrieve, ignore, and update the info base categories in the CW Manage Plugin.

Output

CW Manage Plugin