When providing (Full Contol) access to SharePoint WebApplications using Powershell, it sometimes is a good idea to add the flag ‘System User’ to the account, because otherwise it will show up in the permission views for end-users such as the UserInfoList. In Powershell this can be done by setting the Policy attribute IsSystemUser to $True.… Read More »
Sometimes you find a solution to a stubborn problem, that leaves you feeling kind of silly how you could have missed that. The SPUserLicenseMapping was one of those. The problem was related to new Mysites not being created properly. The solution was to add the correct value for the SPUserLicenseMapping. When using ADFS as a… Read More »
Recently we had installed a new SharePoint 2013 On Premise farm. Everything worked great with custom features and permissions and so on, however suddenly a Health Monitoring Rule came knocking about some missing dependencies. I fixed this specifically a few weeks ago, but now it reappeared without us changing anything that could trigger this. When I… Read More »
Retrieving SharePoint Enterprise Search Service Application monitoring information through Powershell requires some deeper digging than I imagined! We can get the last search crawl results from the CrawlHistory, we can get the current CrawlState (or CrawlStatus, 100% equal, see below), but to get the information that is shown in Central Administration under Search Administration proved… Read More »
Some Powershell examples of getting AppFabric Distributed Cache Instances. Work-in-progress article… Basic Cluster Info:
|
1 2 3 4 5 |
$SPFarm = Get-SPFarm $cacheClusterName = "SPDistributedCacheCluster_" + $SPFarm.Id.ToString() $cacheClusterManager = [Microsoft.SharePoint.DistributedCaching.Utilities.SPDistributedCacheClusterInfoManager]::Local $cacheClusterInfo = $cacheClusterManager.GetSPDistributedCacheClusterInfo($cacheClusterName); $cacheClusterInfo.CacheHostsInfoCollection |
CacheStatistics per CacheHost
|
1 |
Get-CacheHost | %{$HostName = $_.HostName;Get-CacheStatistics -ComputerName $HostName -CachePort $_.PortNo | Add-Member -MemberType NoteProperty -Name 'HostName' -Value $HostName -PassThru} |
CacheStatistics per NamedCache
|
1 |
Get-Cache | %{$CacheName = $_.CacheName;Get-CacheStatistics $CacheName | Add-Member -NotePropertyName "CacheName" -NotePropertyValue $CacheName -PassThru} |
Very Basis Cache Cluster Info:
|
1 2 3 |
$Provider = "SPDistributedCacheClusterProvider" $ConnectionString = (Get-SPDatabase | ?{$_.Type -match "Configuration"}).DatabaseConnectionString Get-CacheClusterInfo -ProviderType $Provider -ConnectionString $ConnectionString |
Advanced CacheHost Status, where Distributed Cache resides on all SharePoint Front-End servers which do not host the Central Administration.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 |
#Status Defaults $TxtStatusArr = @("OK","WARN","CRIT") #Determine servers #We assume AppFabric Distributed Cache is activated on the Front-End servers $SharePointServers = @(Get-SPServer | ?{$_.Role -eq "Application"} | %{$_.Name}) #Handle all-in-one development server If (@($SharePointServers).Count -eq 1){ $FrontEndServers = @($SharePointServers) }Else{ $WebAppServers = @(Get-SPServiceInstance | ?{$_.TypeName -eq "Microsoft SharePoint Foundation Web Application"} | ?{$_.Status -eq "Online"} | %{$_.Server.Name}) $BackEndServers = @(Get-SPServiceInstance | ?{$_.TypeName -eq "Central Administration"} | ?{$_.Status -eq "Online"} | %{$_.Server.Name}) $FrontEndServers = @(Get-SPServer | ?{$_.Role -eq "Application"} | %{$_.Name} | ?{$_ -NotIn $BackEndServers}) #Handle farm where Central Admin is hosted on every SP Server If (@($FrontEndServers).Count -eq 0){ $FrontEndServers = @($BackEndServers) } } #AppFabricDistributedCache check $CheckName = "SP_DistributedCache_CacheHosts" $ResultStatus = 1 Try{ $CacheServices = @(Get-SPServiceInstance | ?{$_.TypeName -eq "Distributed Cache"}) Use-CacheCluster $CacheHosts = @(Get-CacheHost -ErrorAction:SilentlyContinue) If ( $CacheServices.Count -eq $FrontEndServers.Count ){ #CacheServiceCount If ( @($CacheServices | ?{$_.Status -eq "Online"}).Count -eq $CacheServices.Count){ #CacheServiceStatus If ( $CacheHosts.Count -eq $CacheServices.Count ){ #CacheHostsCount If ( @($CacheHosts | ?{$_.Status -eq "Up"}).Count -eq $CacheServices.Count){ #CacheHostsStatus $ResultTxt = "All cache hosts are OK" $ResultStatus = 0 }Else{ #CacheHostsStatus $FailedCacheHosts = @($CacheHosts | ?{$_.Status -ne "Up"} | %{ @($_.Hostname,$_.Status) -Join ":" }) -Join "," $ResultTxt = "Some cache hosts in down status: $FailedCacheHosts" } }Else{ #CacheHostsCount $FailedCacheHosts = @($FrontEndServers | ?{$_ -NotIn @($CacheServices).Server.Name}) $ResultTxt = "Some FrontEnd servers do not have the cache host: $FailedCacheHosts" } }Else{ #CacheServiceStatus $FailedCacheHosts = @($CacheServices | ?{$_.Status -ne "Online"} | %{ @($_.Server.Name,$_.Status) -Join ":" }) -Join "," $ResultTxt = "Some cache services in down status: $FailedCacheHosts" } }Else{ #CacheServiceCount $FailedCacheHosts = @($FrontEndServers | ?{$_ -NotIn @($CacheServices).Server.Name}) $ResultTxt = "Some FrontEnd servers do not have the cache service: $FailedCacheHosts" } }Catch{ $ResultTxt = $_.Exception.Message $ResultStatus = 2 } Write-Host "$ResultStatus $CheckName $($TxtStatusArr[$ResultStatus]) - $ResultTxt" |
A powerful, yet easy solution to simplify the process of recreating the OfficeWebApps Farm after an upgrade. As mentioned in the article from Microsoft Technet, when you want to apply a patch and/or upgrade to the OfficeWebApps software, you need to remove the OfficeWebApps Machine (Remove-OfficeWebAppsMachine) prior to the upgrade and recreate the Farm (New-OfficeWebAppsFarm)… Read More »
This SharePoint Powershell command stalls: “New-SPMetadataServiceApplication” Using the AutoSPInstaller script, the deployment hangs. The script finally stalls with the following: Provisioning Managed Metadata Service Application Creating SharePoint Hosted Services Application Pool… Starting Managed Metadata Service: Starting Metadata Service Instance… Waiting for Metadata service…Online Creating Metadata Service Application… ULS Log: Blocking until timer job ‘—GUID—‘… Read More »
You probably have encountered it already some time ago. You want to check the status of your Distributed Cache Cluster and you login to a back-end server where there is no Distributed Cache component. You open up Powershell and start with Use-CacheCluster. It fails. You failed. You need to login to a server which is… Read More »
The AppFabric Distributed Cache Service is an important yet fragile part of SharePoint 2013. To get the last status and for example use it in your monitoring might be a wanted solution to get a trigger when something is wrong with it. The command “Get-CacheClusterHealth” gives a lot of textual results about the current state… Read More »
Let’s drill down to the methods we can use within Powershell to retrieve Active Directory permissions and translate the GUID: How can we get the name of a property or (extended) right in the Active Directory that a specific user has on a specific OU (path)? How can we do this without having to install… Read More »