Sharepoint Powershell - Enable logging - Verbose

To view the current Log Level in Sharepoint

Get-SPLogLevel

To create a new log file

New- SPLogFile

To set the ULS logging to Verbose

Set-SpLogLevel -TraceSeverity Verbose

To set the ULS logging to VerboseEx - Verbose Extended Logs- This will captured SQL queries in the log.

Set-SpLogLevel -TraceSeverity VerboseEx 

To set Eventlog along with trace log(ULS)

Set-SpLogLevel -TraceSeverity Verbose  -EventSeverity Verbose

To Clear the Log Level

Clear-SPLogLevel

To collect logs from all the servers based on Correlation

Merge-SPLogFile -Path "C:\Logs\Log.log" -correlation <correlation id>

To collect logs from all the servers based on date & time

Merge-SPLogFile -Path "C:\Logs\Log.log" -Overwrite -StartTime "mm/dd/yyyy hh:mm" -EndTime "mm/dd/yyyy hh:mm"

For more options check https://technet.microsoft.com/en-us/library/ff607721(v=office.15).aspx 

Sharepoint Powershell - Add bulk items to Sharepoint lists

cls

$webURL = "http://SiteURL"

$listName = "List_Name"

$web = Get-SPWeb $webURL

  

$list = $web.Lists[$listName]

#Add 1000 items to the list

for ($i=1;$i -lt 1001; $i++) {

$newItem = $list.Items.Add()

           #Add properties to this list item

           $newItem["Title"] = "Test Item"+ $i.ToString()

            $newItem.Update()

}

Sharepoint Powershell - To set master page

To find out which master page is currently applied

$web = Get-SPWeb http://siteurl

$web.CustomMasterUrl

$web.MasterUrl

To set a custom master page to the site

$web = Get-SPWeb http://siteurl

$web.CustomMasterUrl = "/_catalogs/masterpage/custom.master"

$web.MasterUrl = "/_catalogs/masterpage/custom.master"

$web.Update() 

Sharepoint 2013 Workflow Error Invalid JWT token

I had a Sharepoint 2013 Workflow in my site. 

I have configured Workflow manager correctly.

But my workflows weren't running fine. Its status is always "Workflow Cancelled"

When I click the details, it showed the below error

RequestorId: c4f69ed9-ce23-c0b4-b587-620ae350f156. Details: System.ApplicationException: HTTP 401 {"error_description":"Invalid JWT token. Could not resolve issuer token."}

Solution

Run the timer job "Refresh Trusted Security Token Services Metadata feed" to fix the issue

Sharepoint App deployment Error - The content database on the server is temporarily unavailable

When you try to deploy an app via Visual Studio, you might get the below error

The content database on the server is temporarily unavailable

Solution

Configure Managed Metadata service application correctly.

Also make sure you have the below service applications configured correctly

1. App Management Service Application.

2. Microsoft SharePoint Foundation Subscription Settings Service Application.

How to create a BCC Rule in Outlook

1. Open the email where your email is mentioned in BCC
2. Go to File -> Properties -> Internet headers
3. You can find the BCC entry at the end. Usually it would be X-MS-Exchange-Organization-Recipient-P2-Type: Bcc
4. Now create a Rule of type "with specific words in message header"

Powershell- Create folders and sub-folders in sharepoint library

The below script creates multiple folders within a document library; Each folder will have one single subfolder within it.

$webUrl = "http://<siteURL>"

$listName = "Library_Name"

$numberFoldersToCreate = 5;

$folderNamePrefix = "folder";

$web = Get-SPWeb $webUrl

$list = $web.Lists[$listName]

 $StartDateFolder = get-date

for($i=1; $i -le $numberFoldersToCreate; $i++)

{ 

 $folder = $list.AddItem("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, "$folderNamePrefix$i")

 $folder.Update()

 Write-Output "Folder created " $folder.Url

# // Creating One subfolder within the folder

 $subFolderURL=$list.ParentWebUrl +"/" + $folder.Url;

#// if your site is a root site collection, then $list.ParentWebUrl will return "/" 

#so use the  line as  $subFolderURL=$list.ParentWebUrl  + $folder.Url; 

 $folder2 = $list.AddItem($subFolderURL, [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, "Subfolder")

 $folder2.Update()

 Write-Output "Sub Folder created = " $folder2.Url

  

  

}

$EndDatefolder=get-date

 $foldercreationtime=NEW-TIMESPAN –Start $StartDateFolder  –End $EndDatefolder

 $f=[string]::Concat("Folder creation time = " ,  $foldercreationtime.Hours , ":" , $foldercreationtime.Minutes,  ":" , $foldercreationtime.Seconds   )

Write-Output   $f

$web.Dispose()

ULS viewer is showing blank data when we use RealTime option

If your ULS viewer  (download from here ) shows blank data when you use "RealTime" as below

then try the following.

Option #1: Clear everything from logs folder

1. Go to  Services.msc
2. Stop the "Sharepoint Tracing Service"
3. Navigate to C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\LOGS and clear everything.
4. Start the "Sharepoint Tracing Service"
5. Try to open ULSViewer and check for real-time logs


In case, if you still face the issue, try the next option

Option #2 : Change the default location of ULS log

1. Go to Central admin site
2. Got to Monitoring -> Configure Diagnostic logging
3. Change the "Trace Log Path" to any folder, say C:\ULSLogs
4. Try to open ULSViewer and check for real-time logs


Hope it helps !!