Video Screencast Help

How to print out all SEP client

Created: 25 Aug 2012 • Updated: 26 Aug 2012 | 10 comments

Hi everybody

I using SEP 11.x. I need export all list SEP client to Excell file or text file ?

Thanks

Comments 10 CommentsJump to latest comment

Ashish-Sharma's picture

Solution

Go to Clients tab in Symantec Endpoint Protection Manager console.

If you want to have a list of all the clients reporting to Symantec Endpoint Protection Manager console, highlight My Company group.

OR

If you want to check for a specific group, select the appropriate group.

Click on Search Clients task or right click on My Company or the specific group you have selected.

 

In the Search Clients pop up, ensure that "Computers" is selected in "Find" drop down listbox.
Do not select any option under "Search Criteria".
Click on Search.

If you have selected the "My Company" group, this will list all the computers reporting to Symantec Endpoint Protection Manager console.
If you have selected a specific group, it will display only the clients belonging to that group.
Click on the Export button which will be active after the search results are displayed.
Confirm the From & To Page numbers.
Click on Browse and select the File Path.
Specify the file name & click OK.
Click on Export.
 

 

This will export the file in .txt or .csv format in the location specified

 

http://www.symantec.com/business/support/index?page=content&id=TECH123451

 

 

Or

There is an easy way...

you can open the required group to export its clients and select all clients "Ctrl+A" and then copy "Ctrl+C" then past it in Notepad or Excel.

Note 1:

there is no Copy option in the Context menu when you right-click the clients.

Note 2:

You can export a list of all clients in all Groups in the server by searching the Global Group for all clients and do the same thing to Select All then Copy.

Or

or use Monitors, Logs, Computer Status and click Export to get a CSV of all the information about the computers in the console

 

 

Thanks In Advance

Ashish Sharma

 

 

Mithun Sanghavi's picture

Hello,

I agree,

Since you are using SEP 11.x, create a Computer Status Log and then Export the Logs in .txt format and then rename to .csv format.

Check this Article:

Exporting a log report in Symantec Endpoint Protection Manager in .csv format

http://www.symantec.com/docs/TECH179235

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

rs_cert's picture

Simply go to the client Tab. Select all the client from Client Group then copy it and paste it manually in Excel.

 

Ian_C.'s picture

If you are not afraid of SQL, or know how to create a Data connection in Excel, use the script posted here:

SELECT DISTINCT "SEM_AGENT"."DELETED"
  ,"PATTERN"."VERSION"
  ,"PATTERN"."PATTERNDATE"
  ,"SEM_AGENT"."AGENT_VERSION"
  ,"SEM_CLIENT"."COMPUTER_NAME" "Computer Name"
  , "SEM_COMPUTER"."OPERATION_SYSTEM" "Operation System"
  ,dateadd(s,convert(bigint,"SEM_AGENT"."CREATION_TIME")/1000,'01-01-1970 00:00:00') CREATION_DTTM
  , dateadd(s,convert(bigint,"SEM_AGENT"."LAST_UPDATE_TIME")/1000,'01-01-1970 00:00:00') Lastupdatetime
  , DATEADD(s, convert(bigint,LAST_SCAN_TIME)/1000, '01-01-1970 00:00:00')"Last Scan Time"
  , "PATTERN"."PATTERNDATE" "Pattern Date"
  , "SEM_CLIENT"."USER_NAME" "User Name"
  , "V_SEM_COMPUTER"."IP_ADDR1_TEXT" "IP Address"
  , "IDENTITY_MAP"."NAME" "Group Name"
FROM (((("SEM_AGENT" "SEM_AGENT" INNER JOIN "SEM_CLIENT" "SEM_CLIENT"
  ON (("SEM_AGENT"."COMPUTER_ID"="SEM_CLIENT"."COMPUTER_ID")
  AND ("SEM_AGENT"."DOMAIN_ID"="SEM_CLIENT"."DOMAIN_ID"))
  AND ("SEM_AGENT"."GROUP_ID"="SEM_CLIENT"."GROUP_ID")) INNER JOIN "SEM_COMPUTER" "SEM_COMPUTER"
  ON (("SEM_AGENT"."COMPUTER_ID"="SEM_COMPUTER"."COMPUTER_ID")
  AND ("SEM_AGENT"."DOMAIN_ID"="SEM_COMPUTER"."DOMAIN_ID"))
  AND ("SEM_AGENT"."DELETED"="SEM_COMPUTER"."DELETED")) INNER JOIN "PATTERN" "PATTERN"
  ON "SEM_AGENT"."PATTERN_IDX"="PATTERN"."PATTERN_IDX") INNER JOIN "IDENTITY_MAP" "IDENTITY_MAP"
  ON "SEM_CLIENT"."GROUP_ID"="IDENTITY_MAP"."ID") INNER JOIN "V_SEM_COMPUTER" "V_SEM_COMPUTER"
  ON "SEM_COMPUTER"."COMPUTER_ID"="V_SEM_COMPUTER"."COMPUTER_ID"
  AND "SEM_AGENT"."DELETED"=0
ORDER BY "Computer Name"
Please mark the post that best solves your problem as the answer to this thread.
phamduyus's picture

Thanks Lan_c. But I used embedded database ..! is your way support embbeded database ?

 

Ian_C.'s picture

For all intents and purposes, yes. The commands are normal SQL statements. Nothing fancy.

As to connecting to the embedded DB. I don't have one and can't test this for you. Somewhere in the Symantec documentation they will tell you what type of database it is. You can then use something like Database Browser, which supports multiple types of databases, to open a query window and run the script.

Please mark the post that best solves your problem as the answer to this thread.
_Brian's picture

Export the Computer Status report from SEPM.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Mohan Babu's picture

 

Here it is:

 

Go to SEPM-->Monitors Tab-->Logs--Computer status logs-->Advance settings-->Product version drop down-->Select 11.x version-->View logs

It will give you complete list of Clients running on SEP 11.x

Logs will be listed on SEPM console 

Click export thats it.

 

Exporting a log report in Symantec Endpoint Protection Manager in .csv format

http://www.symantec.com/docs/TECH179235

Mohan Babu

moglie20@gmail.com

+91 9884382160

Your satisfaction is very important to us.If you find above information helpful or it has resolved your issue...please mark it accordingly :)

Mohan Babu's picture

Mark the best answer that resolved ur issue....

Mohan Babu

moglie20@gmail.com

+91 9884382160

Your satisfaction is very important to us.If you find above information helpful or it has resolved your issue...please mark it accordingly :)