SharePoint Health Analyser automated mail using Powershell

Hi guys,

Got a requirement to send the farm health report to the farm adminstrators group to get the updates automatically throgh the mail.

After some research, I found the basic power shell script which pulls the data from Health Reports list in the central administration web application

I modified and updated the script to get the severity incidents in the HTML tabular form ,

We can execute the script with task scheduler for automation.

	#Loading SharePoint Powershell Snaping
	Add-PSSnapin Microsoft.SharePoint.Powershell -ErrorAction SilentlyContinue
	#Get central administration web application details
	$caWebApp=(Get-SPWebApplication -IncludeCentralAdministration) | ? {$_.IsAdministrationWebApplication -eq $true}
	$caWeb=Get-SPWeb -Identity $caWebApp.url;
	#Get health reports list
	$healthList=$caWeb.GetList("\Lists\HealthReports")
	$displayURL=$caWeb.Url + ($healthList.Forms | where {$_.Type -eq "PAGE_DISPLAYFORM"}).ServerRelativeURL
	#write-host $displayURL
	# Get query results
	#$queryString="<Query><Where><Eq><FieldRef Name='HealthReportSeverity'/><Value Type='Text'>2 - Warning</Value></Eq></Where><OrderBy><FieldRef Name='Modified'
	Ascending='FALSE' /></OrderBy></Query>"
	$queryString = "<Where><And><Neq><FieldRef Name='HealthReportSeverity' /><Value Type='Text'>4 - Success</Value></Neq><Eq><FieldRef Name='Modified'/><Value
	Type='DateTime'><Today /></Value></Eq></And></Where><OrderBy><FieldRef Name='Modified' Ascending='FALSE' /></OrderBy>"
	$query=New-Object Microsoft.SharePoint.SPQuery
	$query.Query=$queryString
	#$query.RowLimit=10
	$resultItems=$healthList.GetItems($query)
	#write-host $resultitems.Count
	#Write HTML Table
	[Array]$servers=$caWebApp.Farm.Servers
	$msgTitle="Health Analyzer results for SharePoint farm "+ $caWebApp.Farm.DisplayName + " "+(Get-Date)
	$head = "<style type=`"text/css`">.tableStyle { border: 1px solid #000000; }</style>"
	$head=$head+ "<Titel>$msgTitle</Title>"
	#$body = "<H2>$msgTitle</H2><table cellspacing=`"0`" class=`"tableStyle`" style=`"width: 100%`">"
	#Table for displaying server names
	$body = "<H2>$msgTitle</H2><table cellspacing=`"0`" style=`"width: 50%`">"
	$servers | ForEach-Object {
	$body=$body+"<tr><td>$_</td></tr>" }
	$body=$body+"</table>"
	$body=$body+"<br/>"
	$body=$body+"<br/>"
	$body =$body+"<table cellspacing=`"0`" class=`"tableStyle`" style=`"width: 100%`">"
	$body =$body+"<tr><th>URL</th><th>Severity</th><th>Category</th><th>Explanation</th><th>Modified Date</th></tr>"
	foreach ($item in $resultItems)
	{
	$itemUrl = $displayURL + "?id=" + $item.ID
	[array]$itemValues = @($item["Severity"], $item["Category"], $item["Explanation"], $item["Modified"])
	$body = $body + "<tr>"
	$body = $body + "<td class=`"tableStyle`"><a href=`"" + $itemUrl + "`">" + $item.Title + "</a></td>"
	$itemValues | ForEach-Object {
	$body = $body + "<td class=`"tableStyle`">$_</td>"
	}
	$body = $body + "</tr>"
	}
	$body = $body + "</table>"
	# Create message body using the ConvertTo-Html PowerShell cmdlet
	$msgBody = ConvertTo-Html -Head $head -Body $body |Out-string
	# write to address, from address
	$toAddress="" #SPECIFY THE RECIPIENT ADDRESS
	$ccAddress="" #SPECIFY COPY ADDRESS
	#$shareAddress=$caWebApp.OutboundMailReplyToAddress
	$shareAddress="admin@DOMAIN.COM"
	$serverAddress=$caWebApp.OutboundMailServiceInstance.Server.Address
	#initiating server smtp client intantc
	Send-MailMessage -To $toAddress -Cc $ccAddress -From $shareAddress -Body $msgBody -SmtpServer $serverAddress -Subject $msgTitle -BodyAsHtml
	#write-host "Mail sent succesfully"+(Get-Date)

view raw gistfile1.txt hosted with ❤ by GitHub

Content Query web part --Querying multiple specific lists

Hi guys,

How to query the data from multiple lists in SharePoint using content query webpart?

 I have a simple requirement to display the latest 5 document links from multiple document libraries in the current site.

 In general, share point out of the box feature provides the way to query the data from a particular list or all the lists/document libraries in a site or entire site collection.

 If you want to query the data from multiple specific lists, you have to do in in the below way.

 Add the content query webpart to the page,by editing the page and it comes in Content Roll up category. Note- if you are not able to see content query webpart in content roll up category, then your site's publishing feature is not activated. Activate that feature at the site collection level and also at the site level [make sure you have site collection administrator rights.]

 In the content query web part tool box section, select the radio button, that shows "select all the lists/document libraries in the site" and do the remaining filter and sort options, presentation things as per your requirement.

 Finally click Apply button ,then save the page and do the export web part.

 Open the .webpart file after you export it, modify the .webpart file in designer and then find the below property "ListsOverride ".

Get the List GUIDs from the list settings page, for which you want to query the lists.

 Modify that tag similar to the below one.

<property name="ListsOverride" type="string"><![CDATA[<Lists><List ID="31A7C09D-52CC-4585-B998-A3F180A9BD07"/><List ID="7382D66D-2E4C-47CB-A95C-5EECD68F5E61"/></Lists> ]]></property>

view raw gistfile1.txt hosted with ❤ by GitHub

SharePoint 2010 List color codes indiacator using HTML calculated columns

Hi guys,

I have the requirement to build the dashboard designer based on the data from the list. After research on the google, I am able to find the simple way to achieve it using html calculated columns.

Below is the brief description about it for reference.

For example, you have the choice field to show the field "Kickoff" status to green for in progress, red for delay and yellow for hold on.

I created the calculated column to name it as "KICKOFF" and wrote the calculated formula as follows.

KICKOFF: ="

•

"

Once the user selects the Kickoff field to green from choice dropdown, the dashboard field will be updated with green bullet.

Similarly for other fields, you can write the html calculated fields easily based on the choice specified in the original field.

PRESENT: ="

•

"

In above one ,if the choice field "Final presentation" selected by user is Red, the calculated field show red bullet in dash board.

Once you insert the list view webpart in the page, modify the view of list to display the calculated fields .

After that , your job is not completely done.  You have to modify the columns value in sharepoint designer.

Open the list view webpart in designer and select the calculated field, then go to properties and then write

xsl:value-of disable-output-escaping="yes"

Save and close the page. Refresh the page in webpage and see the color dashboard.

Dataform webpart throws error XSLT timeout error

In the data form webpart, if the xslt transformation takes more than one second, the stack overflow exception would be thrown and error message displayed to the user.

To increase the transformation time out, the below power shell script is required.

	$farrn=Get-SPFarm
	$farm.XSLTransferTimeOut=5
	$farm.update()

view raw gistfile1.txt hosted with ❤ by GitHub

Activating FAST search feature using power shell script

Hi Guys,

I had a chance to check whether the fast search feature is activated on your site collection or not using power shell script.

If you navigate to the below url, then you are able to find the fast search feature status
http://sitecollectionurl/_layouts/contextualkeywordmanagement.aspx

Fast search feature is the hidden one, where you need to activate that one using power shell console only through farm administration rights.

Here is the powershell command to know the features activated on your site collection

Get-SPFeature -site siteurl |sort displayname.

If you do not find the feature named "Search Extensions" in the activated features list, you need to activate the hidden feature manually using Fast search feature GUID.

Enable-SPFeature -ID "5EAC763D-FBF5-4d6f-A76B-EDED7DD7B0A5" -site sitecollectionurl

SharePoint List item do not update modified time and modified user

Hi,

I had a requirement to not update the modified user and modified date on the list items with the ability to update the items in the list.

This situation comes like in the production sharepoint sites, the documents modified time and modified by fields are updated by business users and while doing code executions on these items, those modified fields on the lists items should not be updated with system account and latest time.

For this, we used the item.systemupdate(true/false) method.

Here is the script, we had to run on each item in the document library in the entire site collection to make the item update , but without updating modified by and modified time.

Our requirement was to delete the minor versions in the entire site collection, so we recommended the approach of enabling version history with setting "Keep the following no of minor versions" to 1 or 2 or 3.

So if we set 1 for the setting, only the current published minor versions other published versions will exist and all other minor versions will be deleted.
But this job will be done only the item has to be checked out with check in /discard checkout action.

To avoid manual action on each item, we prepared the following script.

	ADD-PSSnapin Microsoft.SharePoint.Powershell -erroraction silentlycontinue
	$url=read-host "Please enter site url"
	$web=Get-SPWeb $url
	$documentlib=read-host "Please enter document libary name"
	$list=$web.Lists.TryGetList($documentlib)
	if($list -ne $null) # checking document library name
	{
	write-host "Document library name is " $list -foregroundcolor DarkGreen
	foreach ($item in $list.Items)
	{
	$item.systemupdate($false)
	}
	}
	else
	{
	write-host "List not found " $documentlib -foregroundcolor DarkGreen
	}
	$web.dispose()

view raw gistfile1.txt hosted with ❤ by GitHub