Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Kiwi CatTools > Kiwi CatTools 3.11 Administrator Guide > Activities > Internal functions > Meta Data > Meta Commands > %ctDB Command

%ctDB Command

Table of contents
No headers
Created by Caroline Juszczak, last modified by Caroline Juszczak on Jun 28, 2016

Views: 4 Votes: 0 Revisions: 3

 

The %ctDB meta command enables you to directly update a field in a table in the CatTools database as part of an Activity.

 

Syntax

%ctDB:tablename:fieldname:new field value

 

The tablename is the name of the table in the database you wish to update a field in.

 

The fieldname is the name of the field you wish to update. See the Device Table section for a list of fields.

 

The new field value is the content you wish to place into the database field. This value may contain a colon - : - in the content as the command parser only looks for the first 3 colons as separators.

 

For instance, you may wish to change the password for devices on the remote authentication server. This would be done on the server itself, and CatTools would not be aware that the password has changed. You can set up an Device.CLI.Send commands activity with a meta command that will change the password in the CatTools database for the selected devices. The command would look like:

 

%ctDB:Device:AAAPassword:thenewpassword

 

In this case, you need to enter only the one meta command as the commands for the Device.CLI.Send commands activity. When the activity runs, it sets the AAAPassword field of the Device table to "thenewpassword" for all the selected devices. CatTools would then use this new password whenever it needed to login to one of the devices.

 

You might also use this type of command if you were setting up the local username and password properties on a set of devices. You would place the meta commands to update the CatTools database fields after the device commands that set the properties on the devices. It is recommended that you select the option to Stop on error in this situation to ensure that CatTools does not have a field set if the device command does not complete successfully.

 

In a Device.CLI.Modify Config activity you might enter the command

 

username joe password fred ...

 

to set a local username and password. You could use the meta commands to update the CatTools database to reflect these changes:

 

%ctDB:Device:AAAUsername:joe

%ctDB:Device:AAAPassword:fred

 

CatTools then knows to use these values when logging into the device in future.

Last modified
07:45, 28 Jun 2016

Tags

Classifications

Public