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 upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

Virus Definition Disribution Tracking Spreadsheet

Created: 12 Aug 2009 • Updated: 20 Aug 2009 | 10 comments
Language Translations
J.Porter's picture
+1 1 Vote
Login to vote

The SEPM console offers great reporting features. I commonly look at the virus definition disribution report to determine how many of my clients have updated to the most current definition. My colleage and I created a excel spread to track the perentage of clients that updated in 24 hours, 48 hours, and so on. Zero day protection is extremely important to our organization, and our seniors like to see the level or protection offered by SEP11. We generate the following reports using the excel spreadsheet attached to this article. Feel free to use the spreadsheet and customize it to your liking. I've zeroed out the data. To use the spreadsheet generate a "virus definition distribution report" by doing the following 1) log into SEPM 2) Go to reports page 3) Select computer status and virus definition distribution will pop up 3) Generate report for Group you want information on. Copy the following information from the reports (Definition Date Revision, version inserted at, number of computers, percentage) and paste between columns A-E of the spreadsheet and your data will be interpretted. :

Group 1 Stats      
  Nr. Reported Successful Not Updated
Total SEP11 clients installed            66,109    
Total Reporting (SEPM)            64,468 97.5%      1,641
Defs 7 days  or less  old                   -   0.0%    64,468
Defs 6 days  or less  old                   -   0.0%    64,468
Defs 5 days  or less  old                   -   0.0%    64,468
Defs 4 days  or less  old                   -   0.0%    64,468
Defs 3 days  or less  old                   -   0.0%    64,468
Defs 2 days  or less  old                   -   0.0%    64,468
Defs 1 day  or less  old                   -   0.0%    64,468
Clients with No Definitions                 269 0.4%  
       
       
Group 2 Stats      
  Nr. Reported Successful Not Updated
Total Reporting (SEPM)              3,281    
Defs 7 days  or less  old                   -   0.0%      3,281
Defs 6 days  or less  old                   -   0.0%      3,281
Defs 5 days  or less  old                   -   0.0%      3,281
Defs 4 days  or less  old                   -   0.0%      3,281
Defs 3 days  or less  old                   -   0.0%      3,281
Defs 2 days  or less  old                   -   0.0%      3,281
Defs 1 day  or less  old                   -   0.0%      3,281
Clients with No Definitions                   -   0.0%  

Comments 10 CommentsJump to latest comment

J.Porter's picture

I'm glad It could be of use to you.

0
Login to vote
Jay Pawaskar's picture

This is very good. I was trying to create a report from SEP using minimal efforts. You did the trick. Thanks.

0
Login to vote
meonfloor's picture

may I get the file, since I also need this urgently? I cannot open the file. its pop me with zip files, but I dont see .xls or .xlsx file.

thanks in advance.

meon

0
Login to vote
meonfloor's picture

ok, I got the file. can i get the template which connect to the database? so i just change the connection and password setup?

appreciate for the helps,
meon

0
Login to vote
Coen66's picture

Hi,
Thanks for sharing. I will have to wait until RU5 is implemented completely as we are fighting with duplications in our database that is only resolved in RU5. We would see computers with old defs (1970) or also double entries with one good and one or several old. One issue of duplication happens specifically with VPN users who will get a different IP each time they connect. Just so you know this issue can happen for you as well ;-).
Coen.

0
Login to vote
Coen66's picture

I see a bunch (xml) of files when downloading, but not a single spreadsheet file. Would you be able to upload it in Excel 2003 format?

Thanks,

Coen.

0
Login to vote
J.Porter's picture

I create the virus definition distribution report in the SEPM and paste the data into the spreadsheet.

0
Login to vote
bweeks's picture

Thanks for creating this,

It looks like it will assist me in keeping more acurate track of the virus defs on our network.

0
Login to vote
JDUM's picture

Hello,

 

Thanks for this spreedsheat, but how could it be possible to copy/paste an .mht file into a spreadsheet ?

In Reports / Quick Report / Computer Status / Virus definition distribution, the option to create the report give an mht file not a txt or csv one.

 

Thanks for your further help

0
Login to vote