Find the JMX agent identifier in the database

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

When searching for blocking jobs in the JMX listAgentQueues console, a reference to an agent also shows a number.
For example: 
agent [2049] queue

What does this number refer to and can this be found in the Nolio database. 
Also if the Server, JXTA name is known, is it possible to find this information.

Environment

Nolio Release Automation 6.8

Resolution

This number represents agent's identifier and you can find it in the ID column of the SERVERS table. This table may be filtered using different agent's properties, such as jxta name (JXTA_NAME column) IP address (SERVER_IP column) or server name (SERVER_NAME column):

select s.* from servers s where s.JXTA_NAME = '[jxta_name]';