Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

How to export virus definition and client information in an excel format?

Created: 17 Mar 2010 • Updated: 22 Mar 2010 | 25 comments
Language Translations
P_K_'s picture
+17 17 Votes
Login to vote

How to export virus definition and client information in an excel format?

1.    Log in the SEPM and Click on Monitor  --->   Logs----->   View logs

2.    Then click on Export  ( This will create  a text file with the name computer_status_export.txt)

3.    Open Excel and Click File  -> Open and select the computer_status_export.txt file to open

4.    In the Text Import Wizard select Delimited and Click Next

5.    In the Step 2 Check Comma and click next.

6.    In the steps 3 select Text and Click Finish

This will  export the logs in the Columns , which can be filtered accordingly as per requirement.

Comments 25 CommentsJump to latest comment

jeffwichman's picture

Too bad you can't simply schedule such an export. It would make things much easier for weekly/monthly reports.  Nice article though

+4
Login to vote
student4ever's picture

Yeah, I had the same issues and I share the same opinion about scheduling such reports. Whe I was preparing for my ACCA revision courses I didn't had much time to control my PC security, so I think it would have been nice to prepare such kind of reports :)

0
Login to vote
Mike Lawler's picture

A scheduled export would be nice, another to to watch for, if your exporting all of the user info and happen to name your clients with Last Name, First name...that comma between names will get read as a new column...makes for fun reading reports :)

+2
Login to vote
oxo-oxo's picture

-WhatIf

You backed up the SEPM everynight

Then look in the backup folder at all the csv files that are the tables of the DB (nice if one doesn't use MS SQL)
- I presume that the info you need is in the DB ...

"Easy" job to batch some specific reports using the DB Schema Doc that Symantec has ...

Owen Brotherwood
JN Data A/S
Denmark
https://www-secure.symantec.com/connect/blogs/sep-0

+1
Login to vote
Wayne Sheldon's picture

Just what I was looking for today - now if you could automate it - like you can a scheduled report, it would be really useful.

+1
Login to vote
Mike Lawler's picture

For this report, if your using the SQL database, and have crystal reports/sql reports/anything you can pull data from a database with, you can automate these reports, just not within Endpoint...

+1
Login to vote
oxo-oxo's picture

I am using Powershell with MS SQL.
I hope to be able to make schecduled reports.
https://www-secure.symantec.com/connect/forums/sep... is my first attempt to get data.

Owen Brotherwood
JN Data A/S
Denmark
https://www-secure.symantec.com/connect/blogs/sep-0

+2
Login to vote
zer0's picture

You can skip the import step if you just name the file computer_status_export.csv when you save it.
Then you can just double click to open it in excel

Z

+2
Login to vote
DavidOlofsson's picture

Unfortunately you can't schedule such an export. It would make things much easier for weekly/monthly reports. Otherwise interesting to read.
 

+1
Login to vote
technische's picture

Although what you have written is actually related to the virus definitions, the whole description is actually a nice tutorial in itself about the import of structured data. I using delimited, etc. a lot myself for frequenting importing of various data. It would be really nice if Microsoft implemented some kind of a way of saving frequently used importing, so that would not need to run the import wizard over and over again. And you can do that with e.g. macros. Regards

+1
Login to vote
P_K_'s picture

I have not tried that.

MCT MCSE-2012 Symantec Technical Specialist (SCTS)

0
Login to vote
Tungsten Affinity's picture

Easy step by step tutorial, with images. I'm gonna send this to my mom as she's always got a virus, lol.

0
Login to vote
JackieJack's picture

Great article. I want more.   fin del mundo 2012

0
Login to vote
nostring's picture

Hi, I do have screen shot number 1 but no screen number 2 that has Export how do I get that screen

0
Login to vote
nyldon's picture

Very clear and understandable guidelines for everyone. Thanks for the information.

+1
Login to vote
nyldon's picture

Thank you for the detalis that you have given to everbody, continue giving information because it helps a lot.

0
Login to vote
nyldon's picture

This is a simple guidelines and the readers will understand clearly. That's why the author was open to give information regarding this site. Thanks a lot!

0
Login to vote
pdemetion's picture

You can simply search on the internet or buy a book for excel. You can see all the information and guidelines on how to manager your MS program.

0
Login to vote
drum samples's picture

Its a very easy and informative post. I think it's very helpful for me. Readers are understand this clearly.

0
Login to vote
nyldon's picture

Always look for the best solution that everyone will satisfy to their needs. Thanks for sharing a message for us.

0
Login to vote
quotes about happiness's picture

I am really enjoying reading your well written articles. I think your blog posts looks unique and informative.I recommend everybody to read this post.

0
Login to vote
paulthomse-23's picture

I using delimited, etc. a lot myself for frequenting importing of various data.

0
Login to vote
Ambesh_444's picture

Thanks for your nice post.

 

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

0
Login to vote