Use Custom Query to create a Table showing status of environmental monitors

craigcm

I added the Universal Device Pollers for the APC Environment Monitors and would like to create a custom query that displays in tabular format each device and respective temperature etc. 

eg

Hostname    Temp (Deg C)   

---------------------------------------------------------

EMA001           23                       

What query do i need to run in order to get similiar results?