Book Image

Windows Server 2012 Automation with PowerShell Cookbook

By : EDRICK GOAD
Book Image

Windows Server 2012 Automation with PowerShell Cookbook

By: EDRICK GOAD

Overview of this book

Automating server tasks allows administrators to repeatedly perform the same, or similar, tasks over and over again. With PowerShell scripts, you can automate server tasks and reduce manual input, allowing you to focus on more important tasks. Windows Server 2012 Automation with PowerShell Cookbook will show several ways for a Windows administrator to automate and streamline his/her job. Learn how to automate server tasks to ease your day-to-day operations, generate performance and configuration reports, and troubleshoot and resolve critical problems. Windows Server 2012 Automation with PowerShell Cookbook will introduce you to the advantages of using Windows Server 2012 and PowerShell. Each recipe is a building block that can easily be combined to provide larger and more useful scripts to automate your systems. The recipes are packed with examples and real world experience to make the job of managing and administrating Windows servers easier. The book begins with automation of common Windows Networking components such as AD, DHCP, DNS, and PKI, managing Hyper-V, and backing up the server environment. By the end of the book you will be able to use PowerShell scripts to automate tasks such as performance monitoring, reporting, analyzing the environment to match best practices, and troubleshooting.

Related Content you might be interested in

Current Title:

Small book image
Windows Server 2012 Automation with PowerShell Cookbook
EDRICK GOAD
Mar, 2013 | 372 pages
No titles found
Table of Contents (19 chapters)
Windows Server 2012 Automation with PowerShell Cookbook
Windows Server 2012 Automation with PowerShell Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Understanding PowerShell Scripting
Understanding PowerShell Scripting
Introduction
Managing security on PowerShell scripts
Creating and using functions
Creating and using modules
Creating and using PowerShell profiles
Passing variables to functions
Validating parameters in functions
Piping data to functions
Recording sessions with transcripts
Signing PowerShell scripts
Sending e-mail
Sorting and filtering
Using formatting to export numbers
Using formatting to export data views
Using jobs
Dealing with errors in PowerShell
Tuning PowerShell scripts for performance
Creating and using Cmdlets
2
Managing Windows Network Services with PowerShell
Managing Windows Network Services with PowerShell
Introduction
Configuring static networking
Installing domain controllers
Configuring zones in DNS
Configuring DHCP scopes
Configuring DHCP server failover
Converting DHCP addresses to static
Building out a PKI environment
Creating AD users
Searching for and reporting on AD users
Finding expired computers in AD
Creating and e-mailing a superuser report
3
Managing IIS with PowerShell
Managing IIS with PowerShell
Introduction
Installing and configuring IIS
Configuring IIS for SSL
Configuring a Central Certificate Store
Configuring IIS bindings
Configuring IIS logging
Managing log files
Configuring NLB across multiple servers
Monitoring load balancing across NLB nodes
Placing NLB nodes into maintenance
Configuring a development/staging/production site scheme
Promoting content in websites
Reporting on website access and errors
4
Managing Hyper-V with PowerShell
Managing Hyper-V with PowerShell
Introduction
Installing and configuring Hyper-V
Configuring NUMA
Securing Hyper-V
Hyper-V networking
Creating virtual machines
Managing VM state
Configuring VM networking
Configuring VM hardware
Quickly deploying VMs using a template
Managing and reporting on VM snapshots
Monitoring Hyper-V utilization and performance
Synchronizing networks between Hyper-V hosts
Hyper-V replication
Migrating VMs between hosts
Migrating VM storage between hosts
Using failover clustering to make VMs highly available
5
Managing Storage with PowerShell
Managing Storage with PowerShell
Introduction
Managing NTFS file permissions
Managing NTFS alternate streams
Configuring NTFS deduplication
Monitoring NTFS deduplication
Configuring storage pools
Reporting on storage pools
Managing file quotas
6
Managing Network Shares with PowerShell
Managing Network Shares with PowerShell
Introduction
Creating and securing CIFS shares
Accessing CIFS shares from PowerShell
Creating iSCSI target and virtual disk
Using a iSCSI disk
Configuring and using iSNS
Creating an NFS export
Mounting NFS exports
Making CIFS shares highly available
Configuring DFS and DFSR replication
Configuring BranchCache
7
Managing Windows Updates with PowerShell
Managing Windows Updates with PowerShell
Introduction
Installing Windows Server Update Services
Configuring WSUS update synchronization
Configuring the Windows update client
Creating computer groups
Configuring WSUS auto-approvals
Reporting missing updates
Installing updates
Uninstalling updates
Configuring WSUS to inventory clients
Creating an update report
Exporting WSUS data to Excel
8
Managing Printers with PowerShell
Managing Printers with PowerShell
Introduction
Setting up and sharing printers
Changing printer drivers
Reporting on printer security
Adding and removing printer security
Mapping clients to printers
Enabling Branch Office Direct Printing
Reporting on printer usage
9
Troubleshooting Servers with PowerShell
Troubleshooting Servers with PowerShell
Introduction
Testing if a server is responding
Using troubleshooting packs
Using Best Practices Analyzers
Searching event logs for specific events
Forwarding event logs to a central log server
10
Managing Performance with PowerShell
Managing Performance with PowerShell
Introduction
Reading performance counters
Configuring Data Collector Sets
Reporting on performance data
Generating graphs
Creating a server performance report
11
Inventorying Servers with PowerShell
Inventorying Servers with PowerShell
Introduction
Inventorying hardware with PowerShell
Inventorying the installed software
Inventory system configuration
Reporting on system security
Creating a change report
Exporting a configuration report to Word
12
Server Backup
Server Backup
Introduction
Configuring backup policies
Initiating backups manually
Restoring files
Restoring Windows system state
Restoring application data
Creating a daily backup report
Index
Index

Exporting WSUS data to Excel

In addition to generating update reports in PowerShell, the results can also be exported into Excel or other tools. By exporting the update or inventory reports to Excel, we can use a familiar tool to view, filter, and display the information in ways that are useful to us.

Getting ready

In this recipe, we will be using the process in the prior recipe to query the update server database. We will then return the resulting dataset and export it into a format that Excel can utilize.

How to do it...

Carry out the following steps to export WSUS data to Excel:

  1. Create the dataset object. This is the same process as the Creating an update report recipe.

  2. Export the dataset to an XML file:

    $ds.Tables[0].WriteXml("C:\temp\inventory.xml")

  3. Open the XML file with Excel:

How it works...

We start by collecting the inventory information as in the prior recipe. Once the database has been queried, it returns a dataset object, which is capable of hosting multiple tables. We instruct PowerShell...

Previous Section
End of Chapter 7
Next Chapter