How to print out all SEP client

[Migration User]

Hi everybody

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

Thanks

[Migration User]

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

 

 

[pete]

computer status report and export it.

[Mithun Sanghavi]

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!!

[Migration User]

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

 

[Migration User]

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"

[Migration User]

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

 

[Migration User]

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.

[ℬrίαη]

Export the Computer Status report from SEPM.

[Mohan Babu]

 

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]

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