Category: SharePoint

$mySiteUrl = "http://mysites.company.com"
$findProperty = "PictureUrl"
 
$mySiteHostSite = Get-SPSite $mySiteUrl
$mySiteHostWeb = $mySiteHostSite.OpenWeb()
$context = Get-SPServiceContext $mySiteHostSite
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$AllProfiles = $profileManager.GetEnumerator()
$outputCollection = @()
 
foreach ($profile in $AllProfiles)
{
    $output = New-Object System.Object
    $output | Add-Member -type NoteProperty -Name AccountName -Value $profile["AccountName"].ToString()
    $output | Add-Member -type NoteProperty -Name $findProperty -Value $profile[$findProperty] 
    $outputCollection += $output
}
 
$outputCollection | ? {$_.($findProperty) -ne ""} | Sort-Object -Property AccountName

function Replace-URL-In-List ([string]$webUrl, [string]$listName, [string]$columnName, [string]$oldValue, [string]$newValue) {
 
    $web = Get-SPWeb $webUrl
    $list = $web.Lists[$listName]
    $allItems = $list.Items
    foreach ($item in $allItems)
    {
         if ($item[$columnName] -like "*"+$oldValue+"*")
         {
            "OLD: " + $item[$columnName] + "    NEW: " + ($item[$columnName] -Replace $oldValue,$newValue)
            $item[$columnName] = ($item[$columnName] -Replace $oldValue,$newValue) #Comment this line out to run as a test
            $item.Update()  #Comment this line out to run as a test
          }
    }
#This is to confirm the values parsed in
"OLD VALUE: " + $oldValue
"NEW VALUE: " + $newValue
 
}
 
$webUrl = "https://portal/web/"
$oldValue = "https://oldK2/_tools"
$newValue = "https://newK2/tools"
 
Replace-URL-In-List -webUrl $webUrl  -listName "Requests" -columnName "ViewForm" -oldValue $oldValue -newValue $newValue

foreach ($server in Get-SPServer) {
		"Server: " + $server.Address
		"--------------------------"
		#TEST WMI CONNECTION
		try {
		#CPU
		$wmi = Get-WmiObject -Class Win32_processor -Computer $server.Address -ErrorAction SilentlyContinue
		"Total Cores: " + $wmi.NumberOfCores
		" "
 
		#RAM
		$wmi = Get-WmiObject -Class Win32_ComputerSystem -Computer $server.Address -ErrorAction SilentlyContinue
		"Total RAM (GB): "  + $wmi.TotalPhysicalMemory/1GB
		" "
 
		#DISKS
		$wmi = Get-WMIObject Win32_LogicalDisk -filter "DriveType=3" -Computer $server.Address -ErrorAction SilentlyContinue
		foreach ($drive in $wmi) {
			"Drive: " + $drive.DeviceID
			"Size (GB): " + $drive.Size/1gb
			"Free Space (GB): " + $drive.FreeSpace/1gb
			" "
		}
 
		#NIC
		$wmi = Get-WmiObject -Class Win32_NetworkAdapter -Computer $server.Address -ErrorAction SilentlyContinue
		foreach ($nic in ($wmi | ? {$_.Speed -gt "1"})) {
			"NIC Name: " + $nic.ServiceName
			"NIC Speed (Mbps): " + $nic.speed/1000/1000 # Mbps
			" "
			}
 
		$wmi = Get-WmiObject -Class Win32_NetworkAdapterConfiguration -Computer $server.Address -ErrorAction SilentlyContinue
		foreach ($con in ($wmi | ? {$_.IpEnabled -eq $true})) {
			"NIC Name: " + $con.ServiceName
			"IP Address: " + $con.IPAddress
			" "
		}
 
		#OS
		$wim = Get-WMIObject -Class Win32_OperatingSystem -Computer $server.Address -ErrorAction SilentlyContinue
		"Operating System: " + $wim.Caption
		"Operating Service Pack: " + $wim.ServicePackMajorVersion
 
		}
		catch {
			"Could not connect to WMI provider"
			}
		$wmi = ""
		" "
		" "
	}