Ditch Excel: Making Historical and Trend Reports in PowerShell
Ditch Excel: Making Historical and Trend Reports in PowerShell
Free!
Minimum price
$5.00
Suggested price
Ditch Excel: Making Historical and Trend Reports in PowerShell

This book is 100% complete

Completed on 2018-10-28

About the Book

Automating Excel is difficult in PowerShell, but it's the only way to get cool-looking reports that have graphs and stuff, right? Wrong: it's time to take the easy road, ditch Excel, and produce automated, beautiful reports the RIGHT way.

About the Author

The DevOps Collective, Inc.
The DevOps Collective, Inc.

The DevOps Collective, Inc. is a US-based 501(c)(3) nonprofit dedicated to changing the way the industry thinks about DevOps. All proceeds from our ebook sales benefit the organization directly. Although all books are published by DevOps Collective, they have been authored by numerous community contributors. Please see each book's "About This Book" page for author credits.

Bundles that include this book

Creating HTML Reports in Windows PowerShell
A Unix Person's Guide to PowerShell
The Big Book of PowerShell Error Handling
DevOps: The Ops Perspective
The Monad Manifesto, Annotated
10 Books
$45.00
Suggested Price
$0.00
Bundle Price

Table of Contents

  • Making Historical and Trend Reports in PowerShell
  • Intro and Setting up the SQL Server
    • What This Book is About
    • System Requirements
    • Installing SQL Server 2012 Express
    • Setting Up a Database
    • Asking for a Database
    • Making a Database
  • Capturing the data
    • Collecting Data
    • Storing Your Data
    • Saving to Your Local SQL Server Express Instance
    • Saving to a Remote SQL Server
    • Reading Your Data
    • Collecting Performance Data
    • Methodology
    • Finding a Counter
  • Making a Report
    • Verifying Reporting Services
    • Accessing Report Manager
    • Building a Report
    • The Case for “Real” Reporting Services

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms...

Write and Publish on Leanpub

Authors, publishers and universities use Leanpub to publish amazing in-progress and completed books and courses, just like this one. You can use Leanpub to write, publish and sell your book or course as well! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub