SHOW MANAGED ACCOUNTS command: New and modified columns in output

Attention

This behavior change is in the 2024_08 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the output of the SHOW MANAGED ACCOUNTS command includes the following new columns at the end:

Column nameData typeDescription
OLD_ACCOUNT_URLVARCHARIf the original account URL was saved when the account was renamed, provides the original URL. If the original account URL was dropped, the value is NULL even if the account was renamed.
ACCOUNT_OLD_URL_SAVED_ONVARCHARIf the original account URL was saved when the account was renamed, provides the date and time when the original account URL was saved.
ACCOUNT_OLD_URL_LAST_USEDVARCHARIf the original account URL was saved when the account was renamed, indicates the last time the account was accessed using the original URL.
ORGANIZATION_OLD_URLVARCHARIf the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the original account URL. If the original account URL was dropped, the value is NULL even if the organization changed.
ORGANIZATION_OLD_URL_SAVED_ONVARCHARIf the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the date and time when the original account URL was saved.
ORGANIZATION_OLD_URL_LAST_USEDVARCHARIf the account’s organization was changed in a way that created a new account URL and the original account URL was saved, indicates the last time the account was accessed using the original account URL.

In addition, the following columns of SHOW MANAGED ACCOUNTS are renamed as follows:

Column name before changeColumn name after change
NAMEACCOUNT_NAME
LOCATORACCOUNT_LOCATOR
URLACCOUNT_URL

Ref: 1738