kwizcom banner advertisement

Usage and Health Data Collection Proxy Stopped in SharePoint 2013

4:32 PM    , , ,
Problem: Usage and Health Data Collection Service Application collects Data for Health Monitoring and usage Analytics Service. We found the Usage and Health Data Collection Proxy status in "Stopped" state, after deploying SharePoint 2013 to a new environment, from: Central Administration >> Application Management  Manage Service Applications Page Solution: If you see Usage and Health Data Collection Proxy in "Stopped" state, you can start the Usage and Health Data Collection Proxy using these two lines of PowerShell Command: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $UsageAppProxy = Get-SPServiceApplicationProxy | Where {$_.TypeName -eq "Usage and Health Data Collection Proxy"} $UsageAppProxy.Provision() This should get your Usage and Health Data Collection Proxy started!
Usage and Health Data Collection Proxy Stopped in SharePoint 2013  Usage and Health Data Collection Proxy Stopped in SharePoint 2013 Reviewed by Salaudeen Rajack on 4:32 PM Rating: 5

Find SharePoint Site Column Usage - Report

5:35 PM    , , , ,
When trying to delete a SharePoint site column, it gave me an alert saying "Site columns which are included in content types cannot be deleted.Remove all references to this site column prior to deleting it."  Alright, Lets use PowerShell to find what lists or content types are using a particular site column, before deleting it. PowerShell script to Find and delete a site column from Content type Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $web= Get-SPWeb "http://sharepoint.crescent.com/sites/operations" $ColumnInternalName = "BranchLocation" #Get All Content Types $CTypes = $web.site.rootweb.ContentTypes foreach($ContentType in $CTypes) { $FieldInUse = $ContentType.FieldLinks | Where {$_.Name -eq $ColumnInternalName } if($FieldInUse -ne $null) { Write-Host "Found the Column in Content Type:" $ContentType.Name -ForegroundColor DarkGreen #To Remove the field from content t
Find SharePoint Site Column Usage - Report Find SharePoint Site Column Usage - Report Reviewed by Salaudeen Rajack on 5:35 PM Rating: 5

How to Add your SharePoint Library to "Favorites" in Windows?

5:18 PM    , , ,
Here is a nifty trick to add your SharePoint library under "Favorites" section. Open your SharePoint library in Explorer view Right click on "Favorites" and choose "Add current location to favorites" Alternatively, you can just drag and drop the folder icon from address bar to Favorites. This will add the current document library to Favorites menu. If needed, you can rename it even. Once added, this location can be used from Open/Save dialog boxes!
How to Add your SharePoint Library to "Favorites" in Windows? How to Add your SharePoint Library to "Favorites" in Windows? Reviewed by Salaudeen Rajack on 5:18 PM Rating: 5

How to Upload a List Template in SharePoint 2013 using PowerShell?

9:13 PM    , , , , ,
Requirement: Upload a custom list template to specific site collections in a web application. While upload a list template using from SharePoint web interface is simple, wanted to automate this process as its repeating for multiple site collections. PowerShell to Upload list template in SharePoint 2013: Here is the PowerShell script to upload custom list template to SharePoint site : Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue Function Upload-ListTemplate($WebURL, $TemplateFilePath) { #Get the Web $web = Get-SPWeb $WebURL #Get the List template Gallery Folder $TemplateFolder = $web.GetFolder("List Template Gallery") #Get the Files collection $TemplateFileCollection = $TemplateFolder.Files #Get the Template file from Local File system $TemplateFile = Get-ChildItem $TemplateFilePath #Open the File in Read mode and Add to Templates collection $TemplateFileCollection.Add("_catalogs/lt/$($TemplateFile.Name)", $Template
How to Upload a List Template in SharePoint 2013 using PowerShell? How to Upload a List Template in SharePoint 2013 using PowerShell? Reviewed by Salaudeen Rajack on 9:13 PM Rating: 5

Copy SharePoint List Column Values from One to Another using PowerShell

4:17 PM    , , , , ,
Requirement: Copy Column Values from One to Another in SharePoint In some situations, we may have to copy SharePoint list column values from one column to another. Say, for E.g. OOTB column doesn't provide a way to enter more than 255 characters in Multiple Lines of Text field. As user already entered values in it and wants to make it allow more than 255 chars. When a SharePoint field's internal name needs to be changed. There is requirement to add a new column, whose values are partially based on an existing column While the Data Sheet view is one solution, Its not available for all lists. And even in datasheet view, some columns like people picker values can't be copy/pasted. So, the solution is: PowerShell PowerShell to Copy Column Values from one to another in SharePoint Here is the PowerShell script to copy SharePoint list / library field data from one column to another column: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoi
Copy SharePoint List Column Values from One to Another using PowerShell Copy SharePoint List Column Values from One to Another using PowerShell Reviewed by Salaudeen Rajack on 4:17 PM Rating: 5

How to Use RunWithElevatedPrivileges in PowerShell Scripts for SharePoint?

6:43 PM    , ,
We use RunWithElevatedPrivileges method to impersonate System Account (Application pool identity), which is granted with FULL control access rights via web application user policy. Here is an example of using RunwithElevatedPrivileges with PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue [Microsoft.SharePoint.SPSecurity]::RunWithElevatedPrivileges( { #Define the parameter values: Site collection URL and user account to remove $siteURL = "http://sharepoint.crescent.com/sites/sales" $userAccount = "crescent\Salaudeen" #Get the RootWeb $web= Get-SPWeb $siteURL #Get the user acount - If doesn't exists ADD $user = $web.EnsureUser($userAccount) #Make the user as Site collection Admin $user.IsSiteAdmin = $true $user.Update() #Print a message Write-host "User: $($userAccount) has been added as site collection administrator!" } ) This PowerShell example u
How to Use RunWithElevatedPrivileges in PowerShell Scripts for SharePoint? How to Use RunWithElevatedPrivileges in PowerShell Scripts for SharePoint? Reviewed by Salaudeen Rajack on 6:43 PM Rating: 5

SharePoint Rich Text Editor Toolbar Missing - Solution

6:37 PM    ,
User reported an issue: SharePoint rich text editor toolbar is missing on list columns! I verified that the SharePoint list columns are enabled with "Rich Text" capabilities, but still rich text editor toolbars are missing! Solution: Open SharePoint site in Internet Explorer 32 bit mode! Here is how: Type "Internet explorer" in Start menu, Choose "Internet Explorer" link as in the screen. Here is the Rich text editor/multi-line column with rich text editing toolbar:
SharePoint Rich Text Editor Toolbar Missing - Solution SharePoint Rich Text Editor Toolbar Missing - Solution Reviewed by Salaudeen Rajack on 6:37 PM Rating: 5

SharePoint 2013 Search Query Suggestions

3:24 PM    , , , , ,
Search suggestions are one of the great new feature introduced in SharePoint 2010, enhanced in SharePoint 2013. Search query suggestions are words that appear under the search box as users type a Search query. (also known as: Pre-query suggestions). SharePoint Search suggestions are automatically generated: When users have clicked any of the search results for that query at least six times, then that query will be automatically added to search suggestions. Technically, on a daily basis, the SharePoint timer job titled "Prepare Query Suggestions" handles compiling them. So the automatic query suggestions can be different for different result sources and site collections. Although Search query suggestions are auto populated based on user searches, It would be helpful to manually add search query suggestions to promote specific areas of your SharePoint. Isn't it? How to Add SharePoint 2013 Search Suggestions using PowerShell: Lets add SharePoint 2010 search suggesti
SharePoint 2013 Search Query Suggestions SharePoint 2013 Search Query Suggestions Reviewed by Salaudeen Rajack on 3:24 PM Rating: 5

Find Top 10 Site Collections based on its Usage during Last Month

5:25 PM    , , , , ,
PowerShell Script to find top 10 SharePoint 2007 site collections based on its usage hits: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") #Functions to Imitate SharePoint 2010 Cmdlets in MOSS 2007 function global:Get-SPWebApplication($WebAppURL) { return [Microsoft.SharePoint.Administration.SPWebApplication]::Lookup($WebAppURL) } function global:Get-SPSite($url) { return new-Object Microsoft.SharePoint.SPSite($url) } function global:Get-SPWeb($url) { $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb(); } return $web } #Get all site collections of the provided web application $WebApp = Get-SPWebApplication "https://intranet.crescent.com" $SitesCollection = $WebApp.Sites $UsageDataCollection = @() #Iterate through each site collection ForEach($site in $SitesCollection) { $web = Get-SPWeb $site.URL $LastMonthUsage
Find Top 10 Site Collections based on its Usage during Last Month Find Top 10 Site Collections based on its Usage during Last Month Reviewed by Salaudeen Rajack on 5:25 PM Rating: 5

Force Run SharePoint Health Analyzer Jobs on Demand using PowerShell

8:08 PM    , , , , ,
We may want to run SharePoint health analyzer on-demand to check if everything is alright in the farm, without waiting for them to run automatically. Well, as discussed in my another article, Run SharePoint 2010 Timer Jobs On-Demand with PowerShell , we can force run SharePoint Health Analyzer timer Jobs on Demand with PowerShell! How to run SharePoint 2010/2013 health analyzer with PowerShell: Lets use PowerShell to force run health analyzer jobs. Here is the PowerShell to rerun health analyzer Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Display name of the Timer Job to Run on-demand $TimerJobName = "Health Analysis Job" #Get the Timer Job $TimerJobs = Get-SPTimerJob | where { $_.DisplayName -match $TimerJobName} foreach($TimerJob in $TimerJobs) { Write-Host "Running:" $TimerJob.DisplayName $TimerJob.RunNow() } This script executes all timer jobs with "Health Analysis Job" in its display name which pe
Force Run SharePoint Health Analyzer Jobs on Demand using PowerShell Force Run SharePoint Health Analyzer Jobs on Demand using PowerShell Reviewed by Salaudeen Rajack on 8:08 PM Rating: 5

How to Disable "I Like It" "Tags & Notes" in SharePoint 2010?

3:18 PM    ,
'I Like it' and 'Tags and Notes' features are introduced in SharePoint 2010 to improve user collaboration, social communication capabilities and to enable users to provide their feedback on items, pages, etc. However, not all SharePoint environments requires this feature, so here are some ways to to remove "I like it" and "Tags & Notes" tag buttons from SharePoint 2010.   SharePoint 2010 disable "I Like It" "Tags and notes" at farm level: If you want to remove "I like It" , "Tags & Notes" at farm level, follow these steps: Go to Central Administration >> System Settings >> Click on "Manage Farm Features" Deactivate "Social Tags and Note board Ribbon Controls" Or you can disable by PowerShell Disable-SPFeature –Identity SocialRibbonControl To enable, use: Enable-SPFeature –Identity SocialRibbonControl Microsoft KB to turn off the "I Like It" and th
How to Disable "I Like It" "Tags & Notes" in SharePoint 2010? How to Disable "I Like It" "Tags & Notes" in SharePoint 2010? Reviewed by Salaudeen Rajack on 3:18 PM Rating: 5

Document Expiration Monitor - Automation with PowerShell Script

1:19 PM    , , ,
Requirement: There are bunch of document libraries with several documents loaded on various site collections. We've to monitor their expiry date based on a column and send e-mail notification to all members of  a  SharePoint Group. Also all E-mails sent should be logged in a tracking list. Solution: Lets write a PowerShell script to scan required document libraries and send E-mail. BTW - Its for MOSS 2007 (But the script works on any SharePoint versions, of course!) PowerShell Script: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") ################################################################################## ## VARIABLES SECTION ## ################################################################################## $LibraryURLs = @("https://intranet.Crescent.com/sites/IT/docs/", "https://intranet.Crescent.com/sites/operations/inventory/", "https://intranet.Crescent.com/sites/Sales/documents") ###
Document Expiration Monitor - Automation with PowerShell Script Document Expiration Monitor - Automation with PowerShell Script Reviewed by Salaudeen Rajack on 1:19 PM Rating: 5

Fix "Sorry, this site hasn't been shared with you." Error in SharePoint 2013

6:59 PM    , , , , , , ,
Typically, if you don't have access to a SharePoint 2013 site and access requests are not enabled, You get : "Sorry, this site hasn't been shared with you" message when you try to access any SharePoint 2013 sites. Its a common issue and simply means that you have not been granted access to the site! OK, How to solve this error? Login to the site collection with either site collection administrator or Farm Admin (granted with "Full control" Web Application user policy!), grant appropriate access to the user in question by going to Site Settings >> People and Groups. Once you do this, users prompted for credentials instead of the Sorry, this site hasn't been shared with you error. To confirm this issue is specific to a particular user's access rights, Try Login as a different user who has permission to the site already: http:/sharepoint-site-url/_layouts/closeConnection.aspx?loginasanotheruser=true Still getting same "Sorry, this s
Fix "Sorry, this site hasn't been shared with you." Error in SharePoint 2013 Fix "Sorry, this site hasn't been shared with you." Error in SharePoint 2013 Reviewed by Salaudeen Rajack on 6:59 PM Rating: 5

Start SharePoint Search Crawl using PowerShell

8:14 PM    , , , , , ,
For some reasons, SharePoint search crawl scheduled didn't trigger. So I used this PowerShell script and Windows Task scheduler to trigger Incremental crawls. Start SharePoint Search Full/Incremental Crawl using PowerShell: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue #Get the search service application $SSA = Get-SPEnterpriseSearchServiceApplication -Identity "Search Service Application" #Get the Local SharePoint sites content source $ContentSource = $SSA | Get-SPEnterpriseSearchCrawlContentSource -Identity "Local SharePoint sites" #Check if Crawler is not already running if($ContentSource.CrawlState -eq "Idle") { Write-Host "Starting Incremental Crawl..." $ContentSource.StartIncrementalCrawl() #$ContentSource.StartFullCrawl(); #$ContentSource.PauseCrawl() #$ContentSource.StopCrawl() } else { Write-Host &qu
Start SharePoint Search Crawl using PowerShell Start SharePoint Search Crawl using PowerShell Reviewed by Salaudeen Rajack on 8:14 PM Rating: 5

SharePoint 2013 Import Spreadsheet Errors and Solutions

3:08 PM    , ,
Error: The list cannot be imported because a Microsoft SharePoint foundation-compatible spreadsheet application is not not installed or is not compatible with your browser. Solution: Use Internet Explorer 32 bit version! How to Open Internet Explorer 32 bit version? Go to start >> Type "Internet Explorer" and pick the "Internet Explorer" link as in this screenshot. Error: The specified file is not a valid spreadsheet or contains no data to import. I'm sure the data is valid and in right format. I know the data is in right format, What's wrong? Solution: Well, SharePoint 2013 expects your SharePoint 2013 site to be in Trusted Sites List! So, Add your SharePoint site to Trusted Sites zone. Here is How to Add SharePoint Site to Trusted Sites Zone: Go to Internet Explorer >> Click on "Tools" Menu >> Internet Options >> Security >> Trusted Sites >> click on "Sites" button and Enter
SharePoint 2013 Import Spreadsheet Errors and Solutions SharePoint 2013 Import Spreadsheet Errors and Solutions Reviewed by Salaudeen Rajack on 3:08 PM Rating: 5

"This field can have no more than 255 characters." Error in Multiline Text Columns

3:05 PM    , , ,
Getting  "This field can have no more than 255 characters." error on SharePoint Multiple lines of text  columns? Well, the fix is simple, we've the property  "Allow Unlimited length in document libraries" on Multiple lines of text fields. Once enabled, technically it can hold content up to 2 GB. We can also set this property programmatically either with C# or PowerShell: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") #Get-SPSite cmdlet for MOSS 2007 function global:Get-SPSite($url) { return new-Object Microsoft.SharePoint.SPSite($url) } #Get-SPWeb cmdlet for MOSS 2007 Function global:Get-SPWeb($url) { $site= New-Object Microsoft.SharePoint.SPSite($url) if($site -ne $null) { $web=$site.OpenWeb(); } return $web } #Parameters $web = Get-SPweb "http://sharepoint.crescent.com/regions/emea/se/" $ListName = "Employee of the Mo
"This field can have no more than 255 characters." Error in Multiline Text Columns "This field can have no more than 255 characters." Error in Multiline Text Columns Reviewed by Salaudeen Rajack on 3:05 PM Rating: 5

How to Get Managed Account Password in SharePoint?

3:09 PM    , , , , , , ,
SharePoint Managed accounts feature was introduced in its 2010 version, and of course its a wonderful feature to manage service accounts (I remember those old days.. We used to create a batch file to update password for each and everything in SharePoint 2007!). So, We utilized managed accounts in SharePoint 2013, enabled automatic password change. All went well until we needed the password for a particular managed account to install a third-party add-on! Luckily found this script to get managed account passwords in SharePoint. Important: You must run this script as Farm Administrator! and make sure you are running the script as "Administrator"!! Recover SharePoint managed account password Here is the PowerShell script to retrieve SharePoint managed account passwords: Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue function Bindings() { return [System.Reflection.BindingFlags]::CreateInstance -bor [System.Reflection.BindingFlags]::GetFiel
How to Get Managed Account Password in SharePoint? How to Get Managed Account Password in SharePoint? Reviewed by Salaudeen Rajack on 3:09 PM Rating: 5
Powered by Blogger.