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

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

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

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

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

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

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

SOLUTION