Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Security Community Blog

How to create a query to List all the SEP clients which are logged in.

Created: 10 Dec 2010 • Updated: 28 Dec 2010 • 1 comment
sezam's picture
+1 1 Vote
Login to vote

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.

Comments 1 CommentJump to latest comment

xlloyd's picture

Thanks! This looks pretty nifty =]

If this post has helped you, please vote up or mark as solution
0
Login to vote