CatTools contains two database activities which allow you to maintain a number of device related fields within the Device table of the CatTools database. The activities are DB.UpdateDevice.Password field and DB.UpdateDevice.Text field.

These activities do not need to connect to your physical network devices in order to perform their tasks (as most of the other CatTools activities do), because they simply perform a batch process within the CatTools database Device table, against the group of devices that you have chosen within the activity.

DB.UpdateDevice.Password field

This activity allows you to maintain your passwords in the CatTools database device password fields.
The database fields you can change using this activity are:

You select the devices that you want to update from within the Devices tab of the activity.

Example of usage:

You were required to update the non-privileged login passwords locally on all your network devices. However the Device.Update.Password activity (which updates both the physical device and CatTools database) was not supported for all of your devices; so for those unsupported you used the Device.CLI.Send commands activity instead and now need to update the CatTools database to keep the passwords synchronized. You create a new DB.UpdateDevice.Password field activity to update the VTY Password database field which will apply the new initial login password to all of your selected devices.

DB.UpdateDevice.Text field

This activity allows you to maintain a number of device related fields in the CatTools database. The activity also allows you to change up to four database fields in one go, via the four Database Field drop down list-box and New database value text-box item pairs.

The Database Fields drop down items you can select from are displayed as tab\field pairs; i.e. the tabs within the Device information/Setup form, and the field available to update in the database on each of these tabs.
For example: Info\Port refers to the Port field on the Device information/setup form tab of Devices.

You select the devices that you want to update from within the Devices tab of the activity.

The database fields available for modification by this activity are as follows:

Example of usage:

Your network devices use a RADIUS or TACACS server for remote authentication. You have just changed the username on the RADIUS/TACACS server and you now need to update all of your devices within the CatTools database with this new username. Instead of editing each device individually, you create a new DB.UpdateDevice.Text field activity. You select the Password\Username item from the first Database Field drop down list-box and enter your new password in the New database value text-box below it.

Running this activity will now update the underlying AAA Username field in the CatTools database applying the new RADIUS/TACACS username to all of your selected devices in one go.

You also changed your RADIUS/TACACS server password, so you also create a new DB.UpdateDevice.Password field activity to update the AAA Password database field which will apply the new RADIUS/TACACS password to all of your selected devices as well.