How to add office 365 users in Office 365 security groups = Group type "Security"

Script to bulk upload user to use Office 365 Group of type "Security" Not "Office 365".

1) Create a CSV file with colum name  "UserPrincipalName"
Add all the email, which needs Microsoft 365 license .

Set-ExecutionPolicy unrestricted
Install-Module MSOnline
$AzureAdCred = Get-Credential
Connect-MsolService -Credential $AzureAdCred


Import-CSv -Path “D:\Assign D365 license user 1.0.CSV” | ForEach {

$UPN=$_.UserPrincipalName

$Users=Get-MsolUser -UserPrincipalName $UPN

# Get the Security Group id from Azure Ad 

$Groupid = Get-MsolGroup -ObjectId “1349607e-825a-45d0-b3a2-068de8f6”

$Users | ForEach {Add-MsolGroupMember -GroupObjectId $GroupID.ObjectID -GroupMemberObjectId $Users.ObjectID -GroupMemberType User}

}

Office 365 Password never expire change for Single user

1 2 3 4 5 6 7 8 9 10 11 12 13 14

#Get the office 365 credential $AzureAdCred = Get-Credential Connect-MsolService -Credential $AzureAdCred Connect-AzureAD -Credential $AzureAdCred # Below powershell command is used to set the PasswordNeverExpires to True. Set-MsolUser -UserPrincipalName sanjiv@softpoc.com -PasswordNeverExpires $true # Below powershell command is used to Get the PasswordNeverExpires status for individual user. Get-AzureADUser -ObjectId sanjiv@softpoc.com | Select-Object UserprincipalName,@{ N="PasswordNeverExpires";E={$_.PasswordPolicies -contains "DisablePasswordExpiration"} }

Get SharePoint Online all site collection details using power shell

   # If you find error related with  Connect-SPOService . You need to download and install the SharePoint Online Management Shell : DOWNLOAD

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
$SPOModulePath = 'C:\Program Files\SharePoint Online Management Shell\'
$adminUPN = 'Admin.User@softPOC.com'
$orgName = 'SOFTPOC'

$userCredential = Get-Credential -UserName $adminUPN
$Env:PSModulePath = '{0};{1}' -f $Env:PSModulePath, $SPOModulePath
Import-Module Microsoft.Online.SharePoint.PowerShell -DisableNameChecking
$uri = "https://$orgName-admin.sharepoint.com"
Connect-SPOService -Url $uri -Credential $userCredential
$sites = Get-SPOSite -Limit All
$sites | select url,owner

# Create a folder with name Temp in C:\ drive
$CSVpath = "C:\Temp\SharePoint-SiteCollection-Report-New.csv"
$sites | Export-CSV -Path $CSVpath -Append -NoTypeInformation

rewrite_2.0_rtw_x64.msi Skype for business 2015 installation error on Windows server 2016

While installing Skype for business 2015 on windows server 2016 throws 

Prerequisite installation failed: RewriteModule error.

Resolution : open registry file start-> Run -> Regedit -> search for InetStpComputer\HKLM\Software\Microsoft\InetStp

change the Reg_DWORD "Major version" value from 10 to 7 , This is a bug of Skype for business where rewrite_2.0_rtw_x64.msi installation is looking for IIS7 , As Windows 2016 server has IIS 10 , This throws an error.

Once the Skype installation gets done change the Reg_DWORD vaue back to 10

SharePoint 2016 Change server role

Before putting the May 2018 sharepoint 2016 service pack roles is 4 (FE,Search,App and Distributed cache)

After putiing the May 2018 service pack roles is 6 (FE,Search,App, Distributed cache , WFEand DC, Search and App server

• sts2016-kb4018381-fullfile-x64-glb
• wssloc2016-kb4018386-fullfile-x64-glb

How to host multiple subdomain sharepoint website under Godaddy

Scenario : I do have multiple wild card sharepoint sites need to be hosted under single domain ,

in my case i have domain name "SoftPOC.com"

1) SoftPOC.com is a static company site and hosted under different domain hosting provider freehostia.com.
x

2) I need to host a sharePoint site my.softpoc.com , sg.softpoc.com , I have added a "A" record and pointed this to my Loadbalncer IP or my Static IP of the sharepoint WFE azure server.

3) I need to host my mails to zoho.com , Keept the MX entry accordingly.

Change SP2016 WFE as WFE with Distributed cache (2 WFE +1SQL +1 Search)

I have 2 WFE and 1SQL and 1 Search server in single farm, As per the requirement both the WFE now needs to change the role from WFE to WFE+Distributed cache.

1) Run the below command in both the WFE
Add-SPDistributedCacheServiceInstance -Role WebFrontEndWithDistributedCache

2) Wait for few minutes and go to

go to CA -> System Settings > Convert server role in this farm

Select the role under New Role drop down and change this to Front end with Distributed cache, Click Apply .

3)V erify that the Distributed Cache service is started. To do this, in the SharePoint Central Administration website, click Application Management. In the Service Applications section, click Manage services on server.