I have a new series of articles that will be focusing on trend reporting using PowerShell and SQL. Be sure to check them out and let me know what you think!
Awards
Omaha PowerShell Users Group
Books
2013 Powershell Scripting Games
Translate This Blog
-
Recent Posts
Top Posts
- Changing Ownership of File or Folder Using PowerShell
- Setting up Local Administrator Password Solution (LAPS)
- PowerShell and Excel: Adding Some Formatting To Your Report
- PowerShell 4.0 Now Available for Download
- Using PowerShell to Query Web Site Information
- Using PowerShell Parameter Validation to Make Your Day Easier
- Quick-Hits: Find currently logged on users
- List All Files Regardless of 260 Character Path Restriction Using PowerShell and Robocopy
- Starting,Stopping and Restarting Remote Services with PowerShell
- Quick Hits: Adding Items to an Array and a Look at Performance
Archives
Categories
- .net api array background jobs binary book c# clock codeplex com object convert CTP database deep dive excel Favorites function groups guest blog hash table Internet Explorer ise mcpmag module MVP network news parameter patches performance pinvoke podcast port PoshChat poshpaig PoshRSJob poshwsus powercli powerscripting Powershell printers quickhits reflection regex registry Regular Expressions report runspace runspaces scripting games 2012 scripting games 2013 scripting guy scripts SMO Speaker speaking SQL tcp tips Trace-Command tsql updates user group V3 V4 v5 weather widget win32API winter scriting games 2014 wmi word WPF wsus xaml
Is there a special reason you calculate the usedspaceGB from size and freespace, instead of just converting the usedspace value from the table to GB?
That would be a fail on my part. 🙂 The better approach would be to take the UsedSpace from the table and convert it to GB rather than wasting cycles on calculating for UsedSpace like I did. Must have been napping while writing out that code block.
Aww, that ended right now before the good stuff!
Always keep them wanting more, eh?
Good one, Boe!
😉 Thanks! I was back and forth between how I was going to split this up into 3 parts and figured it would make the most sense to do the data gathering as one part and then cover the SQL part as the next section.