Display Folder Child Count and Item Child Count Columns - SharePoint

Edit the view on a SharePoint Document Library and mark the checkboxes next to Folder Child Count and Item Child Count Columns

Find All Alerts for all Users in Entire Site collection - SharePoint

How to see all alerts for all users?


Start Sharepoint Management Shell as Administrator

Add-PSSnapin Microsoft.SharePoint.PowerShell
$SPSiteCollection = Get-SPSite “https://SiteCollectionName”

$object = foreach($SpWeb in $SPSiteCollection.AllWebs)
{
foreach($alert in $SpWeb.Alerts)
{
Write-Output “$($alert.AlertFrequency),$($alert.user),$($alert.ListUrl),$($alert.title),”
}
}
$object | Out-file ‘C:\Temp\output.txt’ -Append


Ref:https://www.techrevmarrell.com/get-all-user-alerts-for-sharepoint-site-collection/

MySite - Newsfeed cache size increase SharePoint 2013

On the Newsfeed section of MySite we can see the posts added by colleagues and events on different entities we follow. Newsfeed functionality is supported by Distributed Cache service. The feeds are stored on distributed cache and displayed from it.
There are some settings on User Profile application related to feed cache

Start Sharepoint Management Shell as Administrator

$upa = Get-SPServiceApplication | where {$_.TypeName -Like "User Profile Service Application"}
$upa.FeedCacheTTLHours = 168
$upa.FeedCacheLastModifiedTimeTtlDeltaHours=168
$upa.FeedCacheObjectCountLimit=500
$upa.FeedCacheRoomForGrowth=200
$upa.Update()





"FeedCacheTTLHours" - The default Time To Live of entries in feed cache in hours.
Default value is 168

"FeedCacheLastModifiedTimeTtlDeltaHours" - Additional time added to keep FeedCacheTTLHours for LMT entries. LMT items are kept for 14 days. 7 days for FeedCacheTTLHours plus 7 days for FeedCacheLastModifiedTimeTtlDeltaHours.

"FeedCacheObjectCountLimit" - The maximum number of posts for a given entity that can exist in feed cache.
Default value is 500.

 "FeedCacheRoomForGrowth" - The amount of posts to delete when the number of posts for a given entity reaches FeedCacheObjectCountLimit.
 Default value is 200

User with Full Control cannot Create Subsites in SharePoint

When a user with full control want to create subsite in the site collection he get message:
“Sorry, you don’t have access to this page”

Taxonomy Hidden List list was not inheriting security and was found to be stripped bare of any user or group listings.

SharePoint Taxonomy Hidden List is a storage area for specific term store information for the SharePoint managed metadata service.

The list can be reached through the UI using the following URL [site]/lists/taxonomyhiddenlist.

The solution is simple, give the SharePoint Taxonomy Hidden List read access for all Authenticated Users operating within the Site Collection.

Insert in single line of text only numbers SharePoint 2013

Insert in single line of text only numbers, which will be displayed without a commas.


Insert in Column Validation =ISNUMBER([My Column]+0)





When we try to write letters, we get a warning message.



When we enter numbers, we get numbers without  commas.

 

SharePoint column validation formula for time value - input in a single line of text field.

Here is a Column validation formulas for time value only input in a single line of text field:


Formula for hours, minutes and seconds(e.g.02:30:00):

=AND(TIMEVALUE(FieldName)<>TEXT(FieldName,"HH:MM:SS"),LEN(FieldName)=8)

 Formula for hours and minutes(e.g.02:30):

=AND(TIMEVALUE(FieldName)<>TEXT(FieldName,"HH:MM"),LEN(FieldName)=5)

Change certificate - Office Web Apps

Certificate has been expired and now we need to configure new certificate for existing web farm.
How to change office web apps certificate with powershell?


Before PowerShell command import certifikate in Personal Certifikate Store.


Open a Microsoft PowerShell window as Administrator.

Set-OfficeWebappsFarm -CertificateName "CertifikateFriendlyName"


After this command server restart is required.

Get number of subsite in a site collection - SharePoint

How to get number of subsites in a site collection using Powershell?

$site = Get-SPSite http://YourSharePointSite
$site.AllWebs.Count