Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Export to CSV/txt file monitors tab logs SEP Manager

Created: 18 Jan 2012 • Updated: 15 Mar 2012 | 11 comments
thanos21's picture
This issue has been solved. See solution.

Hello everybody.

In monitors tab of SEP Manager, you can create log reports about computer status. I need a computer status log about virus definitions of the clients.

I found the way to create the report and then export it to csv file but i want this procedure to take place everyday automatically.

Is there a way to achieve that?

Thanks in advance

Comments 11 CommentsJump to latest comment

Mithun Sanghavi's picture

Hello,

Not Automatically.

The report format which is helpful in a graphical view is mht type.its by design

If you change to csv, or xls. it will not display correrctly.

However, for exporting computer status under monitors - logs with csv format

Making a report in Symantec Endpoint Protection Manager that will show client names, IP address, and Client Versions.

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

 
You can check this article:

https://www-secure.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

Again, you may also like to check these Interesting Articles below:

Metrics using data from SEPM

https://www-secure.symantec.com/connect/articles/metrics-using-data-sepm

Metrics using data from SEPM (Part2)

https://www-secure.symantec.com/connect/articles/metrics-using-data-sepm-part2

Metrics using data from SEPM (part three)

https://www-secure.symantec.com/connect/articles/metrics-using-data-sepm-part-three

Hope that helps!!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

thanos21's picture

Hello Mithun Sanghavi

Thanks a lot for the information. These info are very helpful.

The situation is the following: The customer wants to be informed everyday day about the status of sep clients (specifically for the virus definitions) automatically.

Are you sure that there is not a way to automatically create and save a specific report as csv? That is what i need. Please give me a clear answer.

Thanks in advance

Mithun Sanghavi's picture

Hello,

When the Log reports are Exported Manually, they are Exported in .csv Format.

Check the Screeshot below:

However, the Reports (Scheduled / Quick) send via email are in .mht format only.

Again, There is no way to automatically create and save a specific report in .csv format. 

Again, did you check this article:

https://www-secure.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

Hope that helps!!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

thanos21's picture

Hello,

Could we export that kind of reports automatically to csv/txt file via Protection Center?

Thanks in advance

Mithun Sanghavi's picture

Hello,

There is no way to automatically create and save a specific report in .csv format either via SEPM or Protection Center.

Hope that answers!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

thanos21's picture

Sorry for being so annoying but is there a possibility to automate it via a batch file or any other procedure which has nothing to do with SEP Manager of SPC?

This is what customer asks that's why i am examing all the scenarios.

Best Regards,

Mithun Sanghavi's picture

Hello,

Yes, there is a Possibility with a script.

Did you check this article:

https://www-secure.symantec.com/connect/articles/trick-export-customized-reports-symantec-endpoint

Again, you would also require the Database Schema for the same:

Symantec Endpoint Protection 11.0 Database Schema

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

https://www-secure.symantec.com/connect/downloads/database-schema-guide-sep-11-ru-7-mp1

Hope that helps!!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

thanos21's picture

Thanks for the info.

I have read that but it is not about an automated report. I want to cover the following:

everyday, at a specific time, SEP Manager or SPC must export a csv/txt file with the information needed. The trick you mentioned is about changing the info, not automate exporting.

Best Regards,

Mithun Sanghavi's picture

Hello,

Check this:

Exporting log data

You have several choices for exporting the data in your logs. You can export the data in some logs to a comma-delimited text file. You can export other logs' data to a tab-delimited text file that is called a dump file or to a Syslog server. Log data export is useful if you want to accumulate all logs from your entire network in a centralized location. Log data export is also useful if you want to use a third-party program such as a spreadsheet to organize or manipulate the data. You also might want to export the data in your logs before you delete log records.

When you export log data to a Syslog server, you must configure the Syslog server to receive those logs. To forward logs to third-party programs, you need to have the third-party program installed and on the network. For example, you can use Microsoft Excel to open the exported log files. Each field appears in a separate column, a separate log record in each line.

Note: 
You cannot restore the database by using exported log data.

Exporting log data to a comma-delimited text file

Exporting data to a Syslog server

Exporting log data to a text file

About logged events from your network

Hope this helps!!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

thanos21's picture

Thanks for that info but this is not an automate procedure. I want SEP manager or SPC to export reports by its own, without customer's manual guidance.

Is this possible?

Mithun Sanghavi's picture

Hello,

When you export log data to a Syslog server, you must configure the Syslog server to receive those logs. To forward logs to third-party programs, you need to have the third-party program installed and on the network. For example, you can use Microsoft Excel to open the exported log files. Each field appears in a separate column, a separate log record in each line.

Note: 
You cannot restore the database by using exported log data.

Exporting log data to a comma-delimited text file

Exporting data to a Syslog server

Exporting log data to a text file

About logged events from your network

Hope that answers!

Mithun Sanghavi
Associate Security Architect

MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

SOLUTION