How to check user log for instance URL

[ycd]

We recently changed our instance name, and we have 30 days before the old instance URLs are decommissioned. As of now, service accounts can connect to our instance using either the old or new instance name.

I wanted to inquire if there is a log that can provide information about the URL a service account is using to connect to our instance. I noticed that the transaction log doesn't seem to show the full URL as it strips off the instance name.

[AshishKM]

Hi @ycd,

You can get the instance name from the System ID column. SystemID column will show the one of instance-node details where user has active session. 

Please mark helpful and correct answer if it helps

[ycd]

Thanks Ashish, you are right about the instance-node name but unfortunately that does not seem to reveal what instance name was used for that transaction.

[AshishKM]

Hi,

There is other column, Session; instance-node & session column collectively describes the user's active transaction running on which instance. 

Please share , if you found some option.