how to see all agents list on a PG via sql query?

[aubert ciavaldini]

Hi,

I'm looking for how to see agents list on a PG via SQL query?

Thanks a lot for your help.

BR

Aubert

[Sasikumar Divvela]

you can filter the agent table using peripheralID. That will list all the configured agents for that specific pg.

[aubert ciavaldini]

Hi Sasikumar,

can you send a SQL query?

Thanks a lot for you rhelp.

BR

Aubert

[Sasikumar Divvela · Accepted solution]

select * from Agent where PeripheralID='5000' ( change 5000 with your peripheral ID) and run this on SideA database to get upto date infomation. 

[aubert ciavaldini]

Hi Sasikumar,

It works fine, thanks a lot for your help.

Have a good day!

BR

Aubert