Posts

Configure SharePoint Server to use Office Online Server

In a test environment that uses HTTP ======================================================================== Step 1: Create the binding between SharePoint 2016 and Office Web Apps Server New-SPWOPIBinding -ServerName <WacServerName> -AllowHTTP Step 2: View the WOPI zones for the SharePoint bindings Get-SPWOPIZone Step 3: Change the WOPI zone to internal-http Set-SPWOPIZone -zone "internal-http" Step 4: Change the AllowOAuthOverHttp setting in SharePoint 2016 to True (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp $config = (Get-SPSecurityTokenServiceConfig) $config.AllowOAuthOverHttp = $true $config.Update() (Get-SPSecurityTokenServiceConfig).AllowOAuthOverHttp Step 5: Enable the Excel SOAP API $Farm = Get-SPFarm $Farm.Properties.Add("WopiLegacySoapSupport", "<URL>/x/_vti_bin/ExcelServiceInternal.asmx"); $Farm.Update(); Step 6: Verify that Office Web Apps is working In a production environment that uses H

PowerShell command to import Module and Get-ADUser

PS C:\Users\adm_shahidul> Get-Module -ListAvailable     Directory: C:\Windows\system32\WindowsPowerShell\v1.0\Modules ModuleType Version    Name                                ExportedCommands ---------- -------    ----                                ---------------- Manifest   2.0.0.0    AppLocker                           {Get-AppLockerFile... Manifest   2.0.0.0    Appx                                {Add-AppxPackage, ... Manifest   1.0        BestPractices                       {Get-BpaModel, Get... Manifest   1.0.0.0    BitsTransfer                        {Add-BitsFile, Com... Manifest   1.0.0.0    BranchCache                         {Add-BCDataCacheEx... Manifest   1.0.0.0    CimCmdlets                          {Get-CimAssociated... Manifest   1.0.0.0    DirectAccessClientComponents        {Disable-DAManualE... Script     3.0        Dism                                {Add-AppxProvision... Manifest   1.0.0.0    DnsClient                           {Resolve-DnsN

Important PowerShell commands

1. List All Running Services: PS >Get-Service with parameter: PS >Get-Service | Where-Object { $_.Status -eq "Running" } more with parameters: Get-Service [[-Name] <String[]> ] [-ComputerName <String[]> ] [-DependentServices] [-Exclude <String[]> ] [-Include <String[]> ] [-RequiredServices] [ <CommonParameters>] Source : https://technet.microsoft.com/en-us/library/hh849804.aspx 1.  List All SharePoint Services Instances: PS >Get-SPServiceInstance with parameters: Get-SPServiceInstance -Server <SPServerPipeBind> [-All <SwitchParameter>] [-AssignmentCollection <SPAssignmentCollection>] Source : https://technet.microsoft.com/en-us/library/ff607570.aspx 2. List

List the checked out components in SharePoint site using Power Shell

Instruction: Source: http://www.topsharepoint.com/list-all-checked-out-items-using-powershell Prerequisite:  Windows PowerShell Integrated Scripting Environment (ISE) (Windows Server Feature) must be installed on the server. ISE installation instruction: 1.  Click the Server Manager button on the Quick Launch toolbar. Alternatively, click Start, point to Administrative Tools, and then click Server Manager.  2.  In Server Manager, select the Features node, and then click Add Features.  3.  In the Windows Features dialog box, scroll down, and then select Windows PowerShell Integrated Scripting Environment (ISE).  4.  Click Next, and then click Install.  Source: https://technet.microsoft.com/en-us/magazine/ff476072.aspx

INSTALLING SSL CERTIFICATE IN MICROSOFT IIS 7

Contents copied from:  https://www.godaddy.com/help/installing-an-ssl-certificate-in-microsoft-iis-7-4801   INSTALLING AN SSL CERTIFICATE IN MICROSOFT IIS 7 After you  request the certificate  in our online application and it's ready for installation, you must download the files  we provide. Once you download the files, install the intermediate certificate to your Microsoft® IIS 7 server. You also can download the intermediate certificate from the  repository . Then, to install the primary SSL certificate, you must complete the pending request, and then bind the certificate to your website. To Install an Intermediate Certificate in Microsoft IIS 7 Click  Start , and then click  Run... . Type  mmc , and then click  OK . The Microsoft Management Console (Console) window opens. In the  Console1  window, click the  File  menu, and then select  Add/Remove Snap-in . In the  Add or Remove Snap-in window , select  Certificates , and then click  Add . In the  Certific

Uninstall All SharePoint 2010 Solutions via PowerShell

original source: http://joelblogs.co.uk/2011/11/06/uninstall-all-sharepoint-2010-solutions-via-powershell/ The Script function Uninstall-AllSPSolutions { param ( [ switch ] $L ocal , [ switch ] $Confirm ) Start-SPAssignment -Global; foreach ($solution in (Get-SPSolution | Where-Object { $_.Deployed })) { write-host "Uninstalling Solution " $solution.Name; if ($solution.DeployedWebApplications.Count -gt 0) { Uninstall-SPSolution $solution –AllWebApplications -Local:$L ocal -Confirm:$Confirm; } else { Uninstall-SPSolution $solution -Local:$L ocal -Confirm:$Confirm; } do { Start-Sleep 5; $solution = Get-SPSolution $solution; } while ($solution.JobExists -and $solution.Deployed) } Stop-SPAssignment -Global; } function Remove-AllSPSolutions { param ( [ switch ] $Confirm ) Get-SPSolution | Where-Object { !$_.Deployed } | Remove-SPSolution -Confirm:$Confirm } Us

Configure Office Web Apps for SharePoint 2013

copied from: https://technet.microsoft.com/en-us/library/ff431687.aspx Configure SharePoint 2013 to use Office Web Apps Server Choose one of the following sections depending on whether you want to use HTTP or HTTPS. HTTP is generally recommended only for test environments. In production environments, the more secure HTTPS protocol is the better choice. In a test environment that uses HTTP For this configuration, make sure you have set up Office Web Apps Server by following the steps in  Deploy a single-server Office Web Apps Server farm in a test environment . Be sure to configure the Office Web Apps Server farm to use an internal URL and HTTP. The Video: Configure Office Web Apps for SharePoint 2013  shows how to set up Office Web Apps Server and configure SharePoint 2013 to use Office Web Apps Server in a test environment. Step 1: Open an elevated SharePoint 2013 Management Shell Choose the procedure that corresponds to your server operating system. In