In the last post of this series we set up our default formatting and built a subroutine that would reset it when the workbook is opened. We also connected to our database, pulled some information, and changed the formatting of our storage sizes. Finally, we password protected our code from prying eyes. In this post, we will create some pizazz for our workbook and make it more attractive by adding charts and a dashboard.
Andrew Jacops is a system/network administrator with over ten years experience managing Windows environments and the network infrastructures they run on.
In this poll, I would like to know whether you prefer PowerShell or a graphical user interface (GUI) for managing computers in your corporate network—that is, if you prefer to be an Admin or a DevOp (explained below).
In Part 1 we set up our development environment, added the ActiveX Data Objects reference to our project, and started writing our first bit of code that will run when the workbook opens. In this post, we will connect to the database, retrieve the data we need, and format it into a presentable report for archiving. I will be using server storage metrics from SolarWinds Orion as the test data.
Andrew Jacops is a system/network administrator with over ten years experience managing Windows environments and the network infrastructures they run on.
In Part 8 of my Windows 8 deployment series I will show you how the MDT Database allows you to nearly reach a Zero Touch Installation through the use of automatic naming.
Joseph Moody is a desktop administrator for a public school and help manage about 5,500 computers. I specialize in Active Directory, Group Policy, and software deployment.
By Andrew Jacops - Mon, December 17, 2012 - 0 comments 
By 
By 
By 