Administration

SharePoint Online PowerShell – Get started, issues and development

Posted on 20. July 201720. July 2017 by kampan

Get started 1. Download and open the SharePoint Online Management Shell Link: https://www.microsoft.com/en-us/download/details.aspx?id=35588 Open the shell (run as administrator) 2. Proxy authentication (Optional)

$cred = [System.Net.CredentialCache]::DefaultCredentials
[System.Net.WebRequest]::DefaultWebProxy.Credentials = $cred

1 2	$cred = [System.Net.CredentialCache]::DefaultCredentials [System.Net.WebRequest]::DefaultWebProxy.Credentials = $cred

3. Connect to your SharePoint Online Simple:

Connect-SPOService -Url "https://<mydomain>-admin.sharepoint.com" -Credential "<myname>@<mydomain>.com"

1	Connect-SPOService -Url "https://<mydomain>-admin.sharepoint.com" -Credential "<myname>@<mydomain>.com"

It will ask you for password. Complete: For more information: https://technet.microsoft.com/en-us/library/fp161372.aspx

$adminUPN="<the full email address of a SharePoint Online global administrator account, example: jdoe@contosotoycompany.onmicrosoft.com>"
$orgName="<name of your Office 365 organization, example: contosotoycompany>"
$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."
Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential

$adminUPN="<the full email address of a SharePoint Online global administrator account, example: jdoe@contosotoycompany.onmicrosoft.com>"

$orgName="<name of your Office 365 organization, example: contosotoycompany>"

$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."

Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential

Issues Import Module issue Run SharePoint Online Management Shell in administrator […]

Find out all site collections with activated enterprise feature

Posted on 13. March 201513. March 2015 by kampan

Currently I have a lot of administrative requests due to my migration projects. One of that is to find out all site collections with activated enterprise feature. When you activate the enterprise feature on site collection scope, the following features will be activated. SharePoint 2013 SharePoint 2010 enterprise feature also contains a feature with the […]

Grant permission to all existing databases to a user

Posted on 5. March 20155. March 2015 by kampan

First make sure you pick the right role: https://msdn.microsoft.com/en-us/library/ms189121.aspx For existing databases use this

-- ADD USERS

-- add the user to each database 
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')
BEGIN
CREATE USER [Domain\NT User] FOR LOGIN [Domain\NT User] 
PRINT ''User Created in '' + DB_NAME()
END
ELSE
PRINT ''User Already Existed in '' + DB_NAME() '
go

-- add the user to each database db_datareader role
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')
BEGIN
exec sp_addrolemember ''db_datareader'',''Domain\NT User'' 
PRINT ''User added to role in '' + DB_NAME()
END
ELSE
PRINT ''User does not exist in '' + DB_NAME() '
go

-- grant view any definition to user
USE master
go
GRANT VIEW ANY DATABASE TO [Domain\NT User]
PRINT 'Server wide permission granted'

/*
-- DROP USERS
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')
BEGIN
DROP USER [Domain\NT User];
PRINT ''User dropped from '' + DB_NAME()
END
Else
PRINT ''User did not exist in '' + DB_NAME()
*/

-- ADD USERS

-- add the user to each database

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')

BEGIN

CREATE USER [Domain\NT User] FOR LOGIN [Domain\NT User]

PRINT ''User Created in '' + DB_NAME()

END

ELSE

PRINT ''User Already Existed in '' + DB_NAME() '

-- add the user to each database db_datareader role

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')

BEGIN

exec sp_addrolemember ''db_datareader'',''Domain\NT User''

PRINT ''User added to role in '' + DB_NAME()

END

ELSE

PRINT ''User does not exist in '' + DB_NAME() '

-- grant view any definition to user

USE master

GRANT VIEW ANY DATABASE TO [Domain\NT User]

PRINT 'Server wide permission granted'

-- DROP USERS

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N''Domain\NT User'')

BEGIN

DROP USER [Domain\NT User];

PRINT ''User dropped from '' + DB_NAME()

END

Else

PRINT ''User did not exist in '' + DB_NAME()

For future ones use this

USE model
EXEC sp_addrolemember N'db_owner', N'Domain\NT User'

1 2	USE model EXEC sp_addrolemember N'db_owner', N'Domain\NT User'

Create content database and add the site collection in that particular content db by powershell

Posted on 26. February 201526. February 2015 by kampan

In the central administration there is no option to select the database when you create a site collection but my best friend can help you. Check out this powershell commands.

$ContentDatabase = "SP_Content_mysharepoint_myteamsite"
$DBServer = "DBServerAlias"
$WebApplicationURL = "http://mysharepoint.com"
$SiteURL= "http://mysharepoint.com/sites/myteamsite"
$WebsiteName = "My Teamsite"
$WebsiteDesc = "An awesome collaboration site"
$Template = "STS#1"
$PrimaryAdminLogin = "domain\Admin"
$PrimaryAdminEmail = "admin@sharepointloupe.com"
$SecondaryAdminLogin = "domain\Admin2"
$SecondaryAdminEmail = "admin2@sharepointloupe.com"
New-SPContentDatabase -Name $ContentDatabase -DatabaseServer $DBServer -WebApplication $WebApplicationURL

New-SPSite -Url $Site –ContentDatabase $ContentDatabase -Name $WebsiteName –Description $WebsiteDesc  -Template $Template -OwnerAlias $PrimaryLogin –OwnerEmail $PrimaryEmail -SecondaryOwnerAlias $SecondaryAdminLogin -SecondaryEmail $SecondaryAdminEmail

$ContentDatabase = "SP_Content_mysharepoint_myteamsite"

$DBServer = "DBServerAlias"

$WebApplicationURL = "http://mysharepoint.com"

$SiteURL= "http://mysharepoint.com/sites/myteamsite"

$WebsiteName = "My Teamsite"

$WebsiteDesc = "An awesome collaboration site"

$Template = "STS#1"

$PrimaryAdminLogin = "domain\Admin"

$PrimaryAdminEmail = "admin@sharepointloupe.com"

$SecondaryAdminLogin = "domain\Admin2"

$SecondaryAdminEmail = "admin2@sharepointloupe.com"

New-SPContentDatabase -Name $ContentDatabase -DatabaseServer $DBServer -WebApplication $WebApplicationURL

New-SPSite -Url $Site –ContentDatabase $ContentDatabase -Name $WebsiteName –Description $WebsiteDesc -Template $Template -OwnerAlias $PrimaryLogin –OwnerEmail $PrimaryEmail -SecondaryOwnerAlias $SecondaryAdminLogin -SecondaryEmail $SecondaryAdminEmail

Here is the SharePoint 2013 Site Template ID List. Happy SharePointing!

Get the size of all site collection

Posted on 2. February 2015 by kampan

Just another useful script. This powershell code shows the site url and the size in GB. If you need the size in MB, remove “/1024” and replace “GB” with “MB”.

$sites = Get-SPSite -Limit all
foreach ($site in $sites)
{
	$size = $site.Usage.Storage/1024/1024/1024;
	$size = "{0:n2}" -f $size;
	Write-Host $site.url $size GB
}

$sites = Get-SPSite -Limit all

foreach ($site in $sites)

{

$size = $site.Usage.Storage/1024/1024/1024;

$size = "{0:n2}" -f $size;

Write-Host $site.url $size GB

}

Enjoy!

Search Navigation (Dropdown) SP2013

Posted on 20. January 201520. January 2015 by kampan

Today my co-worker asked me for help “Can you setup the search dropdown navigation for all subsites in the site collection? The search navigation should inherit from the root site.”. Pretty simple requirement, I thought. I started to configure the search navigation setting. Issue: The dropdown displayed as expected but the sub-sites were not inheriting […]

Missing web application feature after deployment

Posted on 12. January 201527. February 2015 by kampan

Here is what to do when you miss the web application features after deploying a custom solution. 1. Check on which server the solution was deployed on Powershell: Get-SPSolution -identity “solution name” | fl LastOperationDetails You will find out that the solution was not installed on the server you run the CA. 2. Go Check and […]

CA on Application or Web Server

Posted on 12. January 201512. July 2015 by kampan

Lately I’ve discussed a lot about where the Central Administration should be and what services should run on which server. After facing some issues due to the wrong configuration and spending hours for troubleshooting, this is what I came up with. Reason to leave CA on an application Server: 1. Performance It is not a […]

Administration

SharePoint Online PowerShell – Get started, issues and development

Find out all site collections with activated enterprise feature

Grant permission to all existing databases to a user

Create content database and add the site collection in that particular content db by powershell

Get the size of all site collection

Search Navigation (Dropdown) SP2013

Missing web application feature after deployment

CA on Application or Web Server

Sponsors

Recent Posts

Archives

Categories