SHOW MANAGED ACCOUNTS command: New and modified columns in output (Pending)¶

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 name	Data type	Description
OLD_ACCOUNT_URL	VARCHAR	If 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_ON	VARCHAR	If 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_USED	VARCHAR	If 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_URL	VARCHAR	If 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_ON	VARCHAR	If 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_USED	VARCHAR	If 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:

Ref: 1738