Endpoint Protection

Hello,

i want to export our clients to a list. We use the embedded DB.

I need the client name as well as the pc serial number.

Do you have an idea how to get this export?

Thanks

Its not possible from SEPM, Serial number is not stored in DB.

You can use SCCM to get it

hose information needs to be filled by the end user, you need to enable log collection for that.

How do I get the "User Info" tab updated for each user with a managed Symantec Endpoint Protection (SEP) client without a manual edit in the Symantec Endpoint Protection Manager (SEPM)

http://www.symantec.com/business/support/index?pag...

Easiest way I would say is to use wmic

wmic /node:"C:\COMPUTERS.TXT" bios get serialnumber >c:\results.csv

Hello and thanks for the fast answer.

It is a bit wired that i can see the serial numbers from each client if i double click them and look in the "general" tab.

But we never added the serialnumber manualy. And you cant write something in this field.

We dont use SCCM.

Maybe there is another solution out there ;)

Export the Computer Status report. It contains all the details that SEP captures. In the past I've not seen it include the serial number though. You're best bet is probably to query the DB directly.

Thanks for your reply.

in this export there is no serial number. realy realy wired.

Screenshot (its in german):

For whatever reason it doesn't seem to be included in the Computer Status report. The DB should have that field though so you may need to query for it directly.

may be I wrote it too fast, 

the table sem5.dbo.SEM_SVA_COMPUTER has 

BIOS_Serialnumber value. You can query that...

may be I wrote it too fast, 

the table sem5.dbo.SEM_SVA_COMPUTER has 

BIOS_Serialnumber value. You can query that...

Click on monitor --> Logs --> Computer status logs  set the time for past 10 days as you will get all the computer that have connected in one month. Now select View log and then export. Depenting on the size of your network the log size & time take to produce the log may varry. Be sure to keep a eagle eye on the SEPM console as even a few seconds of delay you take to hit the Save button will result in small log. then you have to repeat the whole process once again.

SEP client doesn't capture the serial number of the host machine and hence the SEPM doesn't have it. Hence, the serial number of the machines cannot be obtained from SEPM.

Edit: The above info is incorrect. I regret any inconvenience caused.

Hi PraveenAyappan,

thanks for your reply. if i do it your way, there is no serial number in the export.

Anyhow, i think its fine now.

I dont remember the DB password so i cant do any searching in the DB. But that will be the right way. So i mark it as the solution

Hi ZEUSv,

There is a way to reterive your Embedded DB password as well. If required please PM me are create a new discussion forum so that we can help you out.