IT - Lessons Learned

Launch MSOnline powershell as admin Install-Module MSOnline -Force Connect-SPOService -Url "https://TENANT_NAME.sharepoint.com" authentication prompt

Get-SPOSite -Limit ALL | Select Title, Url, Owner, SharingCapability, Status, IsHubSite| Export-CSV "C:\\TEMP\SPO-Sites.csv" -NoTypeInformation -Encoding UTF8

For a list of all available attributes use 

First launch powershell as administrator

Install Microsoft Online Module and Connect to the Microsoft Online service 

Install-Module MSOnline -Force Connect-MsolService

To find how many people have each license type run

Get-MsolAccountSku

This will provide you with something like this information

AccountSkuId                         ActiveUnits WarningUnits ConsumedUnits ------------                         ----------- ------------ ------------- TENANTNAME:STREAM            100000      0            100 TENANTNAME:EMSPREMIUM        10          0            10 TENANTNAME:ENTERPRISEPREMIUM 10          0            10 TENANTNAME:ENTERPRISEPACK    10          0            10 TENANTNAME:FLOW_FREE         1000        0            50 TENANTNAME:POWERAPPS_VIRAL   1000        0            100 TENANTNAME:POWER_BI_STANDARD 1000000     0            1000 TENANTNAME:WIN_DEF_ATP       10          0            1 TENANTNAME:EMS               10          0            1

To find out the License that applies to each AccountSkuId look at this MS page 

https://docs.microsoft.com/en-us/azure/active-directory/users-groups-roles/licensing-service-plan-reference 

Example: An OFFICE 365 ENTERPRISE E5 License has AccountSkuId ENTERPRISEPREMIUM

If you want to get a list of users who have each license type...

Get-MsolUser -All | Where-Object {($_.licenses).AccountSkuId -match "EnterprisePremium"}  | Out-file C:\temp\EnterprisePremiumUsers.csv

We often come across large logs or other files that crash standard applications when we try to open them on a Windows based computer.  Another QUICK option is to search for text via the command line.  One good option is the Select-String cmdlet.   

First a simple query.  Search for the word ‘error’ in all log files in the c:\logs directory would look like this: 

> Select_String -Path c:\logs\*.log -Pattern error

But you can also search multiple file types and for multiple patterns.  What if you want to find ‘error’ or ‘fail’ in all txt, csv and log files in the c:\logs directory?

Continuous crawl really isn’t continuous.  It is more like incremental crawls done close together.  The default interval for continuous crawl is actually every 15 minutes.  But you can change this.

To get the names of your search service applications

$ssa = Get-SPEnterpriseSearchServiceApplication $ssa

To get the current setting for continuous crawl intervals of a specific Search Service Application.  Replace “Search Service Name" below.

$ssa = Get-SPEnterpriseSearchServiceApplication "Search Service Name" $ssa.GetProperty("ContinuousCrawlInterval")

To set the interval of continuous crawls.  Change the 5 example below to the number of minutes between crawls.

# Variables

$HostA = "spwfm01"

$HostB = "spwfm02"

$HostC = "spwfm03"

$interface = "Ethernet"

$ClusterVIP = "10.49.99.70"

 # Create a new NLB Cluster

New-NLBCluster -Interface $interface -OperationMode Multicast -ClusterPrimaryIP $ClusterVIP -ClusterName "WFMCluster" -HostName $HostA

# Remove the stupid default port rule for everything

Get-NlbClusterPortRule -HostName $HostA | Remove-NlbClusterPortRule -Force

# Add port rules for 12290

Add-NlbClusterPortRule -HostName $HostA -StartPort 12290 -EndPort 12290 -InterfaceName $interface

# Add other 2 hosts to cluster

Add-NlbClusterNode -HostName $HostA -InterfaceName $interface -NewNodeName $HostB -NewNodeInterface $interface

# Launch PowerShell ISE, run the following:

# From the looks of your screenshot, I'd run ISE on WEB002, because WEB001 appears to be down

Set-ExecutionPolicy unrestricted

Add-PSSnapin Microsoft.SharePoint.PowerShell

import-module distributedcacheconfiguration

 # Get the current status

Use-CacheCluster

Get-CacheHost

 ##############################

# On each server where Distributed Cache is not listed as "UP", do the following:

# Login to each one of those servers (cannot issue these commands remotely), then run:

##############################

 Stop-SPDistributedCacheServiceInstance -Graceful

Remove-SPDistributedCacheServiceInstance

 # Confirm that the only servers left show "UP" as the status, and all others have been removed

Use-CacheCluster

Get-CacheHost

 # Now go back to each server that you removed and run:

Add-SPDistributedCacheServiceInstance

 # Confirm that the server has been added back, and the status now shows "UP"

Use-CacheCluster

Get-CacheHost

1. Create an input file with only IP addresses and put in location like c:\temp\IPAddress.txt

2. From Powershell window run the following:

#************************************************************************************** # Curtis McDonald # 7 June 2017 #************************************************************************************** #************************************************************************************** $snapin = Get-PSSnapin | Where-Object {$_.Name -eq 'Microsoft.SharePoint.Powershell'} if ($snapin -eq $null) {    Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue } #************************************************************************************** # This script will loop through all the servers in a SharePoint farm, then perform # IISRESET on those servers which match the naming criteria. # # For example, using the values "SPWEB" and "10" would perform an IISRESET on all servers # in the SharePoint farm whose name contains "SPWEB", and pause for 10 seconds between # each one. #**************************************************************************************

### BEGIN VARIABLES ###

# The portion of the server's name to match, for example "SPWEB" $nameMatch = "SPWEB"

# Pause for this number of seconds between each server, so that you don't bounce them all at once $timeInterval = 3

### END VARIABLES ###

# Get a list of all servers in the farm, then loop through them $farmServers = Get-SPServer | where {$_.Name -imatch $nameMatch}

foreach ($server in $farmServers) {

   write-host ""    Write-Host  -foregroundcolor Yellow "Restarting IIS on server $server..."    Write-Host "IIS status for server" $server    Invoke-Command -ComputerName $server.Name -ScriptBlock {iisreset /restart}    write-host ""    Write-Host "Pausing before continuing to next server for" $timeInterval "seconds..."    Start-Sleep -Milliseconds ($timeInterval * 1000)    Write-host "" }

Launch regedit.exe and navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp

Set Minimum Encryption Level to "High" instead of "Client Compatible":

HKLM\System\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp\MinEncryptionLevel REG_DWORD Value: 3

Set Security Layer to "SSL (TLS 1.0)" instead of "Negotiate":

Would you like to customize the output from powershell commands?  You can easily do this in powershell itself, no need to move the output to a unix shell for properly formatting your data.  

Example:

Getting information about currently running processes.  The standard output for the Get-Process cmdlet looks like this

PS C:\Users\name> Get-Process ie*

But there are MANY other attributes available from this command.  To learn what the other attributes are we append '| Format-List *' to the command line and get a long listing returned (partial list shown).

PS C:\Users\name> Get-Process ie* | Format-List *

For our report, we only want to return the name, id and PeakPagedMemorySize.  We can do so with the following command.

Get-Process ie* | Format-List name, id, Responding, PeakPagedMemorySize

But, this listing isn't very user friendly.  It would require additional formatting to put this data into excel for further processing.  So, we use Format-Table to change the view into a table.

Get-Process ie* | Format-Table name, id, Responding, PeakPagedMemorySize