Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Looking for a great Windows OS Patching template (preferably in Excel).

Posted on 2014-02-17
10
1,281 Views
Last Modified: 2014-03-13
We just starting with patching in our environment. We are using WSUS, but I am not happy with the reporting that WSUS provide. I want to create a master sheet in excel that will show details of what we have patched, and was wondering if there are any good template out there where I can download. A template that will break items down in columns, etc. Can someone point me in the right direction? I've seen a few online, but they are not that detailed.
0
Comment
Question by:5itface
  • 6
  • 4
10 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39865442
Can you clarify what do you mean by
a great Windows OS Patching template

Can you post a sample of the data you have to understand better what you want ?
gowflow
0
 

Author Comment

by:5itface
ID: 39866534
Just an excel template that I can download and modify myself. Anything you can recommend. Something with Drop down selection and stuff. What I do need is a calendar pop up to where I click and a calendar pops-up to allow me to select a date. Maybe you can create something and hand off to me? 500 points in it for you. Thanks.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39866668

500 points in it for you

Verry inappropriate comment, we are not in a bazar here.

You specify clearly what you want and Experts propose solutions for you and when you are satisfied you close the question that could be beneficial for lots of people having the same issue as these are posted on the www

So please post a workbook specifying the fields you want and what you are after and will be glad to develop this.

Regards
gowflow
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:5itface
ID: 39876011
I just need a template that has a simple function: the calendar pop-up. If you can create just a column for that, I think i can fill in the rest. I just don't know how to create that.

Something like the example here would be ideal:
http://www.fontstuff.com/vba/vbatut07.htm
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39876118
Well, would this be what you are looking for ?

1) After you download the file, enable macros
2) the way it is setup is that you have your headings in Row1 and any field that contain the word "date" in row1 will make the calendar popup when the cursor is in that column.
3) Upon choosing a date it will reflect in the cell selected.
4) This is possible due to making sure that the Library Microsoft Calendar Control xx Library is on your system. I have 2007 but if you have 2010, 2013 etc.. it should also be ok.

Run it and let me know your comments or problems if any, we can cater to it.
gowflow
Calendar.xlsm
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39885159
Any chance to have tried out the proposed solution ?
gowflow
0
 

Author Comment

by:5itface
ID: 39886608
The template you sent me does not work. I've attached a template so that you can modify and sent back to me. I want the date to populate for the following column: Scan Date, PatchDate. For the following column: Installed Patch Count, Missing Patch Count, Missing service Pack, I want it modified to have a drop down to select from 0-100. Thank you.
Patch-master-list.xlsx
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39887070
what excel version you have?
gowflow
0
 

Author Comment

by:5itface
ID: 39887188
2010.
0
 
LVL 29

Expert Comment

by:gowflow
ID: 39888076
When you say that the solution I provided does not work, would you be kind enough and considerate to advise what is the problem so we fix it for you ?

Remmeber we DO NOT WORK for you !!!! we are all Experts that do this work FREE OF CHARGE and just to gain experience.

So please be kind enough to give feedback instead of instructions.

gowflow
1

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Security measures require Windows be logged in using Standard User login (not Administrator).  Yet, sometimes an application has to be run “As Administrator” from a Standard User login.  This paper describes how to create a shortcut icon to launch a…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question