If You would like to get fast report about SEP clients connected to SEPManager you can use this query.
use SEPdbName
SELECTSEM_CLIENT.COMPUTER_NAME as Computer, SEM_AGENT.LAST_SERVER_ID as Server, SEM_AGENT.STATUS as Status, SEM_COMPUTER.IP_ADDR1 as IP
From SEPdbName.SEM_CLIENT, SEPdbName.SEM_AGENT, SEPdbName.SEM_COMPUTER
Where SEM_AGENT.COMPUTER_ID = SEM_CLIENT.COMPUTER_ID and SEM_AGENT.STATUS = 1 and SEM_CLIENT.COMPUTER_NAME = SEM_COMPUTER.COMPUTER_NAME
where SEPdbName is a SEPManager Data Base name.
In next Blog entries I will explain more.
Thanks! This looks pretty nifty =]