Virus Definition Disribution Tracking Spreadsheet
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. :
This help me.
This help me.
I'm glad It could be of use
I'm glad It could be of use to you.
This is very good. I was
This is very good. I was trying to create a report from SEP using minimal efforts. You did the trick. Thanks.
request
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
ok, I got the file. can i get
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
Nice sheet
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.
XLSX?
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.
I create the virus definition
I create the virus definition distribution report in the SEPM and paste the data into the spreadsheet.
Would you like to reply?
Login or Register to post your comment.