Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Kiwi CatTools > Kiwi CatTools Documentation > 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: 107 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.



%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:




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:





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

Last modified