Saturday, July 27, 2019

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


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

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


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
#Create credential object
$credObject = Get-Credential
#Import the Exchange Online ps session
$ExchOnlineSession = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $credObject -Authentication Basic -AllowRedirection
Import-PSSession $ExchOnlineSession

Import-CSv -Path “C:\Users\sanjivk\D365\Assisgn Bulk license script\Assign D365 license user 1.0.CSV” | ForEach {

$UPN=$_.UserPrincipalName

Write-Host $UPN
Add-UnifiedGroupLinks –Identity "D365Prod-CR Account Configuration Team-OSG" –LinkType Members  –Links $UPN
}

Friday, July 19, 2019

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}

}


Tuesday, May 21, 2019

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"}

 }

Thursday, May 9, 2019

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

Saturday, December 8, 2018

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



Thursday, October 4, 2018

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


Friday, September 21, 2018

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.



HTML

Script:

JS