Monday, April 27, 2015

SharePoint Rest Services CRUID operations

SharePoint Rest service 


+ "/"+ paramValues[0] +"/_api/lists/getbytitle('"+ paramValues[1] +"')/items?$orderby=Created desc &$Select=ID,FileRef," +paramValues[2]+","+paramValues[3]+","+paramValues[4];


Please Refer: 

SharePoint REST Service:
https://msdn.microsoft.com/en-us/library/fp142380.aspx

https://msdn.microsoft.com/en-us/library/office/jj164022.aspx


OData sources with Business Connectivity Services in SharePoint 2013:
https://msdn.microsoft.com/en-us/library/jj163802.aspx


Authorization and authentication of apps for SharePoint 2013:
https://msdn.microsoft.com/en-us/library/fp142384.aspx

SharePoint: Change User email address for a site collection PowerShell

Change User email address for a site collection PowerShell


Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue
$User = Get-SPUser -identity " Domain\User" -Email" -web "https://xyz.com"
write-output $($User.Email)
Set-SPUser -Identity "Domain\User" -Email "rku@nz.com" -Web "https://xyz.com"
write-output $($User.Email)



$web =Get-SPWeb http://rku:1111/sites/dev/
$list=$web.Lists["User Information List"]
$user =$list.GetItemById(3)
$user["SipAddress"]=""
$user["EMail"]="Rku@test.com"
$user.update()
$list.update()
$web.update()

Sunday, April 19, 2015

SQL Server Product and current version

SQL Server Product and current version

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')