How to create a query to List all the SEP clients which are logged in.
If You would like to get fast report about SEP clients connected to SEPManager you can use this query.
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.