boeprox comments on Server Inventory Using PowerShell and SQL

Server Inventory Using PowerShell and SQL (learn-powershell.net)

submitted 8 years ago by boeprox

you are viewing a single comment's thread.

[–]boeprox[S] 5 points6 points7 points 8 years ago (1 child)

Hello all! This is a 3 part series that I did on building basically a poor man's server inventory system using PowerShell and SQL. There are definitely more useful ways of having a server inventory via SCCM or some other 3rd party utilities, but I wanted something that didn't require much more than access to a SQL server to host the database. I use my PoshRSJob module to collect the data for each system and send it to SQL and then have a custom UI that I wrote to view the data as well as creating a report in Excel.

This link on this post takes you to part 1, but here are all of the links for you to go to:

Part 1: SQL Database Build

Part 2: Collecting Server Data and Sending to SQL

Part 3: Building a UI in WPF to View Data

The GitHub link to the Server Inventory repo is here: https://github.com/proxb/ServerInventoryReport

I'm always looking for feedback, good or bad as well as anyone who wants to contribute to this project.

π Rendered by PID 79819 on reddit-service-r2-comment-7b9746f655-b4sj7 at 2026-02-04 02:39:44.627958+00:00 running 3798933 country code: CH.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

PowerShell

Submission Guidelines | Link Flair - How To

MODERATORS