# NAME: VolumeInfo.ps1

# DESC: PowerShell script to report on volume information

# BY  : Justin Braun, Compellent Technologies, Inc.

# DATE: December 1, 2009

# VER : 1.0

#

# THIS CODE IS MADE AVAILABLE AS IS, WITHOUT WARRANTY OF ANY KIND.  THE ENTIRE

# RISK OF THE USE OR THE RESULTS FROM THE USE OF THIS CODE REMAINS WITH THE USER.

#

# NOTE: This script assumes a default Get-SCConnection already exists.

# Collection

$colVolumes = @()

foreach($volume in Get-SCVolume)

{

    Write-Host "Gathering volume data for $volume.Name..."

    $replays = $null

    $mappings = $null

    $pagecount = 0

    # Volume Information

    $ReportData = New-Object System.Object

    $ReportData | Add-Member -Type NoteProperty -Name "Volume Index" -Value $volume.Index

    $ReportData | Add-Member -Type NoteProperty -Name "Volume Name" -Value $volume.Name

    $ReportData | Add-Member -Type NoteProperty -Name "Volume Size" -Value $volume.Size

    $ReportData | Add-Member -Type NoteProperty -Name "Block Count" -Value $volume.BlockCount

    $ReportData | Add-Member -Type NoteProperty -Name "Created By" -Value $volume.CreateUser

    $ReportData | Add-Member -Type NoteProperty -Name "Created On" -Value $volume.CreateTime

    $ReportData | Add-Member -Type NoteProperty -Name "Modified By" -Value $volume.ModifyUser

    $ReportData | Add-Member -Type NoteProperty -Name "Modified On" -Value $volume.ModifyTime

    $ReportData | Add-Member -Type NoteProperty -Name "Folder" -Value $volume.ParentFolder

    # Replay Count Information

    Write-Host "Gathering replay information for $volume.Name..."

    $replays = Get-SCReplay -SourceVolumeIndex $volume.Index

    $ReportData | Add-Member -Type NoteProperty -Name "Replay Count" -Value $replays.Count

    # Replay Cumulative Page Information

    Write-Host "Gathering replay page count information for $volume.Name..."

    foreach($replay in $replays)

    {

        $pagecount += $replay.OwnedPageCount

    }

    $ReportData | Add-Member -Type NoteProperty -Name "Total Replay Pages" -Value $pagecount

    # Volume Mapping Information

    Write-Host "Gathering volume mapping information for $volume.Name..."

    $mappings = Get-SCVolumeMap -VolumeIndex $volume.Index

    if($mappings -eq $null)

    {

        $ReportData | Add-Member -Type NoteProperty -Name "Mappings" -Value "No"

    }

    else

    {

        $ReportData | Add-Member -Type NoteProperty -Name "Mappings" -Value "Yes"

    }

    # Add to collection

    $colVolumes += $ReportData

}

# Outfile ReportData Contents

Write-Host "Writing output file..."

$colVolumes | export-csv -path "c:\volumeinfo.txt"

Write-Host "Done!"

Write-Output "Bringing Disk Online..."

Set-DiskDevice -SerialNumber $scvolume.SerialNumber -Online

Set-DiskDevice -SerialNumber $scvolume.SerialNumber -ReadOnly:$false

$OffsetKB = @{label=”Offset(KB)”;Expression={$_.StartingOffset/1024 -as [int]}}

$SizeMB = @{label=”Size(MB)”;Expression={$_.Size/1MB -as [int]}} 

Get-WmiObject -ComputerName "localhost" -Class "Win32_DiskPartition" | ft`

SystemName, Name, DiskIndex, $SizeMB, $OffsetKB  -AutoSize

function Get-StaleUserAccounts

{   

    # Use Directory Services object to attach to the domain

    $searcher = new-object DirectoryServices.DirectorySearcher([ADSI]"")

    # Filter down to user accounts

    #when you query for objectClass=User, you will not only get user accounts but also computer accounts. 

    #To limit the search to true user accounts, you would have to also include the objectCategory

    $searcher.filter = "(&(objectCategory=person)(objectClass=User))"

    # Cache the results

    $searcher.CacheResults = $true

    $searcher.SearchScope = “Subtree”

    $searcher.PageSize = 1000

    # Find anything you can that matches the definition of being a user object

    $accounts = $searcher.FindAll()

    # Check to make sure we found some accounts

    if($accounts.Count -gt 0)

    {             

        foreach($account in $accounts)

        {

            $LastPassChange = [datetime]::FromFileTimeUTC($account.Properties["pwdlastset"][0]);    

            # Determine the timespan between the two dates

            $datediff = new-TimeSpan $LastPassChange $(Get-Date);

            # Create an output object for table formatting

            $obj = new-Object PSObject;

            # Add member properties with their name and value pair

            $obj | Add-Member NoteProperty AccountName($account.Properties["name"][0]);

            $obj | Add-Member NoteProperty LastPasswordChange($LastPassChange);

            $obj | Add-Member NoteProperty DaysSinceChange($datediff.Days);

            # Write the output to the screen

            Write-Output $obj;

        }

    }

}

# Get user accounts where a password change hasn't occurred in 60 days or more

# If nothing outputted, then there are no accounts that meet that criteria

Get-StaleUserAccounts |Where-Object {$_.DaysSinceChange -gt 60}