The agent status is displayed in the UI and written to the DB. In the Library database, there is table named AGENT. You can get the status of an agent from this table. You and your DBA will need to query on the IsActive column and it gives you the agent status. You will to write a join query on Agent and ConfigObject tables.