Endpoint Protection

 View Only

Virus Definition Disribution Tracking Spreadsheet 

Aug 12, 2009 01:54 PM

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%  

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
xlsx file
Virus Definition Distrubition Stats.xlsx   104 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Apr 22, 2011 06:10 AM

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

Mar 16, 2011 07:42 AM

Thanks for creating this,

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

Dec 03, 2009 10:34 AM

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

Oct 20, 2009 08:22 AM

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.

Oct 20, 2009 08:18 AM

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.

Oct 19, 2009 05:37 AM

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

Oct 19, 2009 04:29 AM

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

Sep 15, 2009 06:46 PM

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

Sep 03, 2009 08:14 AM

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

Sep 02, 2009 07:18 AM

This help me.

Related Entries and Links

No Related Resource entered.