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.
By default now SEPM exports to a comma-delimited file. I have verified with the SEPM 12.1 RU4 verison.
Thanks for your nice post.
I using delimited, etc. a lot myself for frequenting importing of various data.
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.
Always look for the best solution that everyone will satisfy to their needs. Thanks for sharing a message for us.
Its a very easy and informative post. I think it's very helpful for me. Readers are understand this clearly.
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.
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!
Thank you for the detalis that you have given to everbody, continue giving information because it helps a lot.
Very clear and understandable guidelines for everyone. Thanks for the information.
Hi, I do have screen shot number 1 but no screen number 2 that has Export how do I get that screen
good blog dude,keep it up.
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 :)
Great article. I want more. fin del mundo 2012
Easy step by step tutorial, with images. I'm gonna send this to my mom as she's always got a virus, lol.
Nice tutorial.....
I have not tried that.
Unfortunately you can't schedule such an export. It would make things much easier for weekly/monthly reports. Otherwise interesting to read.
-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 ...
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 :)