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

Changelog​

2025-04-10​

  • Initial version of the document