The Braun Blog

# Name:       Storage Center Search

# Usage:      Search for volume or server objects across a Storage Center

# Author:     Justin Braun

# Date:              February 17, 2010

# This sample script is provided "as is" with no warranty whatsoever; 

# you assume all responsibilty of the consequences of use.

$scname = Read-Host "What Storage Center do you want to search? (IP or hostname)"

$scusername = Read-Host "What is the username for your account on this Storage Center?"

$scpassword = Read-Host -AsSecureString -Prompt "What is the password?"

$findsource = Read-Host "What type of object are you looking for? (S=server, V=volume)"

$searchterm = Read-Host "Enter the text you want to search for (wildcards OK)"

if($findsource -ne "S" -and $findsource -ne "V")

{

       # Invalid parameter entered.

       Write-Host "`nInvalid search source specified.`n" -ForegroundColor Red

       Break

}

# Valid parameter found - start script

# Instantiate connection

Write-Host "`nOpening connection...";

try

{

       $conn = Get-SCConnection -HostName $scname -User $scusername -Password $scpassword;

}

catch

{

       Write-Host "Error: " $_;

       Break;

}

Write-Host "Connection established to $scname...";

# What are we searching for?

switch ($findsource)

{

       "S"

       {

              # Find a server

              $servers = Get-SCServer -Connection $conn | where { $_.Name -like $searchterm }

              if($servers -ne $null)

              {

                     # Found some objects that might match

                     Write-Host "`nThe following servers might match your query:"

                     $servers | ft -AutoSize Name, LogicalPath, WorldWideNames

              }

              else

              {

                     # No objects found

                     Write-Host "`nSorry, no objects were found that match your query."

              }

       }

       "V"

       {

              # Find a volume

              $vols = Get-SCVolume -Connection $conn | where { $_.Name -like $searchterm }

              if($vols -ne $null)

              {

                     # Found some objects that might match

                     Write-Host "`nThe following volumes might match your query:"

                     foreach($vol in $vols)

                     {

                           # Create an output object for table formatting

                           $obj = new-Object PSObject;

                           # Add member properties with their name and value pair

                           $obj | Add-Member NoteProperty VolumeName($vol.Name);

                           $obj | Add-Member NoteProperty LogicalPath($vol.LogicalPath);

                           #Get Mappings to volume

                           $mappings = Get-SCVolumeMap -VolumeIndex $vol.Index -Connection $conn

                           if($mappings -ne $null)

                           {

                                  $maps = ""

                                  foreach($mapping in $mappings)

                                  {

                                         $maps += $mapping.ServerName + " "

                                  }

                                  $obj | Add-Member NoteProperty Mappings($maps);

                           }

                           else

                           {

                                  # No mappings found

                                  $obj | Add-Member NoteProperty Mappings("None");

                           }

                           # Write the output to the screen

                           Write-Output $obj;

                     }

              }

              else

              {

                     # No objects found

                     Write-Host "`nSorry, no objects were found that match your query."

              }

       }

}

# 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}

# Continue to run script when an error occurs

$ErrorActionPreference = "SilentlyContinue"

# Process through the loop of IP addresses 1-254

1..254 | foreach -Process `

{

    # We're combining the contents of different objects, so create our own

    $obj = New-Object PSObject;

    # Perform the Ping using WMI

    $ping = get-WmiObject -Class Win32_PingStatus -Filter ("Address='10.10.2." + $_ + "'");

    # Put the IP Address into our object

    $obj | Add-Member NoteProperty IPAddress($ping.Address);

    # Take the Ping Status Code that is returned (0 = pingable)

    $obj | Add-Member NoteProperty StatusCode($ping.StatusCode);

    # If we can ping the address, let's try to resolve the hostname

    if($ping.StatusCode -eq 0)

    {

          # Record that the ping was successful

           $obj | Add-Member NoteProperty Status("Online");

        # Try to resolve the IP address to a hostname in DNS

        $dns = [System.Net.Dns]::GetHostByAddress($ping.Address);

           if($dns -ne $null)

           {

            # Add the resolved hostname to our collection

             $obj | Add-Member NoteProperty ResolvedHostName($dns.HostName);

           }

           else

           {

            # Couldn't resolve the IP address to a hostname

               $obj | Add-Member NoteProperty ResolvedHostName("");

           }

    }

    else

    {

        # Can't ping IP address, so mark host as offline

           $obj | Add-Member NoteProperty ResolvedHostName("");

           $obj | Add-Member NoteProperty Status("Offline");

    }

    # Write the collection out

    Write-Output $obj;

    # Cleanup DNS object

    $dns = $null;

}

function Get-DomainComputerAccounts

{   

    # Use Directory Services object to attach to the domain

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

    # Filter down to computer accounts

    $searcher.filter = "(&(objectClass=computer))"

    # Cache the results

    $searcher.CacheResults = $true

    $searcher.SearchScope = “Subtree”

    $searcher.PageSize = 1000

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

    $accounts = $searcher.FindAll()

    # Check to make sure we found some accounts

    if($accounts.Count -gt 0)

    {             

        foreach($account in $accounts)

        {

            # Property that contains the last password change in long integer format

            $pwdlastset = $account.Properties["pwdlastset"];

            # Convert the long integer to normal DateTime format

            $lastchange = [datetime]::FromFileTimeUTC($pwdlastset[0]);

            # Determine the timespan between the two dates

            $datediff = new-TimeSpan $lastchange $(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 ComputerName($account.Properties["name"][0]);

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

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

            # Write the output to the screen

            Write-Output $obj;

        }

    }

}

# Get computer 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-DomainComputerAccounts |Where-Object {$_.DaysSinceChange -gt 60}