Retrive account password powershell

Start SharePoint Service Application Proxy using Powershell

If your Usage and Health Data Collection Proxy is in a stopped state here is a quick bit of PowerShell to to get it started:

$sap = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”}
$sap.Provision()

The above can easily be adapted to allow you to start any Service Application Proxy

Advertisements
Retrive account password powershell

Basic Powershell cmdlet sharepoint

Get-Command -Noun SP*
Get-Help Get-SPSite
Get-Help Get-SPSite -Examples
PS C:\Users\de.prasad.adm> Get-Command -Noun SPSite

CommandType Name ModuleName


Cmdlet Backup-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Copy-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Move-SPSite Microsoft.SharePoint.PowerShell
Cmdlet New-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Repair-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Restore-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Set-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Test-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPSite Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWeb

CommandType Name ModuleName


Cmdlet Export-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Import-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet New-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWeb Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWebApplication

CommandType Name ModuleName


Cmdlet Convert-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet New-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWebApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplication

CommandType Name ModuleName


Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Publish-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Unpublish-SPServiceApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplicationPool

CommandType Name ModuleName


Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet New-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPContentDatabase

CommandType Name ModuleName


Cmdlet Dismount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Mount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet New-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Set-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Test-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPContentDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPDatabase

CommandType Name ModuleName


Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPManagedAccount

CommandType Name ModuleName


Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet New-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Set-SPManagedAccount Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun STimerJob
PS C:\Users\de.prasad.adm> Get-Command -Noun SPTimerJob

CommandType Name ModuleName


Cmdlet Disable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Enable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Set-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Start-SPTimerJob Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPUser

CommandType Name ModuleName


Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Move-SPUser Microsoft.SharePoint.PowerShell
Cmdlet New-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Set-SPUser Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun WebApplication

CommandType Name ModuleName


Cmdlet ConvertTo-WebApplication WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet New-WebApplication WebAdministration
Cmdlet Remove-WebApplication WebAdministration
PS C:\Users\de.prasad.adm> Get-Command -Noun SPProcessAccount

CommandType Name ModuleName


Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell

PS C:\Users\de.prasad.adm> Get-Command -Verb Get

Cmdlet Get-PfxCertificate Microsoft.PowerShell.Security
Cmdlet Get-PfxData PKI
Cmdlet Get-Process Microsoft.PowerShell.Management
Cmdlet Get-PSBreakpoint Microsoft.PowerShell.Utility
Cmdlet Get-PSCallStack Microsoft.PowerShell.Utility
Cmdlet Get-PSDrive Microsoft.PowerShell.Management
Cmdlet Get-PSProvider Microsoft.PowerShell.Management
Cmdlet Get-PSSession Microsoft.PowerShell.Core
Cmdlet Get-PSSessionConfiguration Microsoft.PowerShell.Core
Cmdlet Get-PSSnapin Microsoft.PowerShell.Core
Cmdlet Get-Random Microsoft.PowerShell.Utility
Cmdlet Get-ScheduledJob PSScheduledJob
Cmdlet Get-ScheduledJobOption PSScheduledJob
Cmdlet Get-SecureBootPolicy SecureBoot
Cmdlet Get-SecureBootUEFI SecureBoot
Cmdlet Get-Service Microsoft.PowerShell.Management
Cmdlet Get-SPAccessServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroupMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAlternateURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAcquisitionConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAutoProvisionConnection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDeniedEndpointList Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDisablingConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppHostingQuotaConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppPrincipal Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppScaleProfile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppSiteSubscriptionName Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStoreConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationRealm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBackupHistory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsBlock Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsKey Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBrowserCustomerExperienceImprovementProgram Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogEntityNotificationWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogMetadataObject Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogThrottleConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCertificateAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimTypeEncoding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCustomLayoutsPage Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFileDependent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDeletedSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDesignerSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsPerformanceCounter Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDistributedCacheClientSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEduServiceSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchAdministrationComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchContentEnrichmentConfigur… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlContentSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlCustomConnector Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlLogReadPermission Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchFileFormat Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchHostController Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLanguageResourcePhrase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinguisticComponentsStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinksDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCategory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCrawledProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataManagedProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchOwner Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRuleCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryDemoted Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryKeyword Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScopeRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySpellingCorrection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySuggestionCandidates Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchRankingModel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultItemType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationBackupS… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSiteHitRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchTopology Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchVssDataPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBIServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBlockedFileType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataConnectionLibrary Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelFileLocation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelUserDefinedFunction Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarmConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFeature Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHealthAnalysisRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHelpCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathUserAgent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathWebServiceProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPIRMSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogEvent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogLevel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMobileMessagingAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSettingMetadata Microsoft.SharePoint.PowerShell
Cmdlet Get-SPOfficeStoreAppsDefaultActivation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPendingUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplicationTrusted… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPluggableSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProduct Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileLeader Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseQuota Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectEnterpriseProjectTaskSync Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectLogLevelManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectOdataConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPCSSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPermissionMode Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectQueueSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectWebInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRequestManagementSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachineInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachinePool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseCreationScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseRightsScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseUpgradeScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSProxyUrl Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationServers Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreSystemAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecurityTokenServiceConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationEndpoint Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxyGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceContext Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceHostConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSessionStateService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPShellAdmin Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteAdministration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscription Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoveryHub Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoverySearchScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionFeaturePack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionIRMConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionMetadataConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteUpgradeSessionInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTaxonomySession Microsoft.SharePoint.PowerShell
Cmdlet Get-SPThrottlingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTranslationThrottlingSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedIdentityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedRootAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedSecurityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedServiceTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageDefinition Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicense Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicenseMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicensing Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioExternalData Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioPerformance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioSafeDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationHttpThrottlingMonitor Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebPartPack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIBinding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPISuppressionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIZone Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-Tpm TrustedPlatformModule
Cmdlet Get-TpmEndorsementKeyInfo TrustedPlatformModule
Cmdlet Get-TpmSupportedFeature TrustedPlatformModule
Cmdlet Get-TraceSource Microsoft.PowerShell.Utility
Cmdlet Get-Transaction Microsoft.PowerShell.Management
Cmdlet Get-TroubleshootingPack TroubleshootingPack
Cmdlet Get-TypeData Microsoft.PowerShell.Utility
Cmdlet Get-UICulture Microsoft.PowerShell.Utility
Cmdlet Get-Unique Microsoft.PowerShell.Utility
Cmdlet Get-Variable Microsoft.PowerShell.Utility
Cmdlet Get-WebAppDomain WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet Get-WebApplicationMonitoringStatus Microsoft.MonitoringAgent.Pow…
Cmdlet Get-WebAppPoolState WebAdministration
Cmdlet Get-WebBinding WebAdministration
Cmdlet Get-WebCentralCertProvider WebAdministration
Cmdlet Get-WebConfigFile WebAdministration
Cmdlet Get-WebConfiguration WebAdministration
Cmdlet Get-WebConfigurationBackup WebAdministration
Cmdlet Get-WebConfigurationLocation WebAdministration
Cmdlet Get-WebConfigurationLock WebAdministration
Cmdlet Get-WebConfigurationProperty WebAdministration
Cmdlet Get-WebFilePath WebAdministration
Cmdlet Get-WebGlobalModule WebAdministration
Cmdlet Get-WebHandler WebAdministration
Cmdlet Get-WebItemState WebAdministration
Cmdlet Get-WebManagedModule WebAdministration
Cmdlet Get-WebRequest WebAdministration
Cmdlet Get-Website WebAdministration
Cmdlet Get-WebsiteState WebAdministration
Cmdlet Get-WebURL WebAdministration
Cmdlet Get-WebVirtualDirectory WebAdministration
Cmdlet Get-WheaMemoryPolicy Whea
Cmdlet Get-WIMBootEntry Dism
Cmdlet Get-WinAcceptLanguageFromLanguageListOptOut International
Cmdlet Get-WinCultureFromLanguageListOptOut International
Cmdlet Get-WinDefaultInputMethodOverride International
Cmdlet Get-WindowsDriver Dism
Cmdlet Get-WindowsEdition Dism
Cmdlet Get-WindowsErrorReporting WindowsErrorReporting
Cmdlet Get-WindowsImage Dism
Cmdlet Get-WindowsImageContent Dism
Cmdlet Get-WindowsOptionalFeature Dism
Cmdlet Get-WindowsPackage Dism
Cmdlet Get-WindowsSearchSetting WindowsSearch
Cmdlet Get-WinEvent Microsoft.PowerShell.Diagnostics
Cmdlet Get-WinHomeLocation International
Cmdlet Get-WinLanguageBarOption International
Cmdlet Get-WinSystemLocale International
Cmdlet Get-WinUILanguageOverride International
Cmdlet Get-WinUserLanguageList International
Cmdlet Get-WmiObject Microsoft.PowerShell.Management
Cmdlet Get-WSManCredSSP Microsoft.WSMan.Management
Cmdlet Get-WSManInstance Microsoft.WSMan.Management

Configure diagnostic logging SharePoint 2016

The SharePoint Server 2016 environment might require configuration of the diagnostic logging settings after initial deployment, after upgrade, and if a change is made to the environment, such as adding or removing a server.

The guidelines in the following list can help you form best practices for the specific environment.

* Change the drive to which the server writes logs:

By default, SharePoint Server 2016 writes diagnostic logs to the same drive and partition on which it was installed. Because diagnostic logging can use a large amount of drive space and compromise drive performance, you should configure SharePoint Server 2016 to write to another drive on which SharePoint Server 2016 is not installed.

You should also consider the connection speed to the drive on which SharePoint Server 2016 writes the logs. If verbose-level logging is configured, the server records a large amount of data. Therefore, a slow connection might result in poor log performance.

* Restrict log disk space usage:

By default, the amount of disk space that diagnostic logging can use is unlimited. Therefore, restrict the disk space that logging uses, especially if you configure logging to write verbose-level events. When the disk reaches the restriction, SharePoint Server 2016 removes the oldest logs before it records new logging data.

* Use the Verbose setting sparingly:

You can configure diagnostic logging to record verbose-level events. This means that SharePoint Server 2016 records every action that it takes. Verbose-level logging can quickly use drive space and affect drive and server performance. You can use verbose-level logging to record more detail when you are making critical changes and then reconfigure logging to record only higher-level events after you make the change.

* Regularly back up logs:

Diagnostic logs contain important data. Therefore, back up the logs regularly to ensure that this data is preserved. When you restrict log drive space usage, or if you keep logs for only a few days, SharePoint Server 2016 automatically deletes log files, starting with the oldest files first, when the threshold is met.

* Enable event log flooding protection:

When you enable this setting, SharePoint Server 2016 detects repeating events in the Windows event log, and suppresses them until conditions return to a typical state.

You can set the level of diagnostic logging for the event log and for the trace log. This limits the types and amount of information that are written to each log.

The following tables define the levels of logging that are available for the event log and trace log.

event-log-levels

trace-log-levels

Configure diagnostic logging by using Central Administration :

  1. In Central Administration, on the home page, click Monitoring.
  2. On the Monitoring page, in the Reporting section, click Configure diagnostic logging.
  3. On the Diagnostic Logging page, in the Event Throttling section, configure event throttling as follows:To configure event throttling for all categories:
    1. Select the All Categories check box.
    2. Select the event log level from the Least critical event to report to the event log list.
    3. Select the trace log level from the Least critical event to report to the trace log list.

    To configure event throttling for one or more categories:

    1. Select the check boxes of the categories that you want.
    2. Select the event log level from the Least critical event to report to the event log list.
    3. Select the trace log level from the Least critical event to report to the trace log list.

    To configure event throttling for one or more subcategories (you can expand one or more categories and select any subcategory):

    1. Click the plus (+) next to the category to expand the category.
    2. Select the check box of the subcategory.
    3. Select the event log level from the Least critical event to report to the event log list.
    4. Select the trace log level from the Least critical event to report to the trace log list.

    To return event throttling for all categories to default settings:

    1. Select the All Categories check box.
    2. Select Reset to default from the Least critical event to report to the event log list.
    3. Select Reset to default from the Least critical event to report to the trace log list.
  4. In the Event Log Flood Protection section, select the Enable Event Log Flood Protection check box.
  5. In the Trace Log section, in the Path box, type the path of the folder to which you want logs to be written.
  6. In the Number of days to store log files box, type the number of days (1-366) that you want logs to be kept. After this time, logs will automatically be deleted.
  7. To restrict the disk space that logs can use, select the Restrict Trace Log disk space usage check box, and then type the number gigabytes (GB) you want to restrict log files to. When logs reach this value, older logs will automatically be deleted.
  8. After you have made the changes that you want on the Diagnostic Logging page, click OK.

Configure diagnostic logging by using Windows PowerShell :

  1. Verify that you have the following memberships:
  • securityadmin fixed server role on the SQL Server instance.
  • db_owner fixed database role on all databases that are to be updated.
  • Administrators group on the server on which you are running the Windows PowerShell cmdlets.

An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint Server 2016 cmdlets.

  1. On the Start menu, click All Programs.
  2. Click SharePoint 2016.
  3. Click SharePoint 2016 Management Shell.
  4. To change the drive to which the server writes logs, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -LogLocation D:\DiagnosticLogs

  1. To restrict log disk space usage, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -LogMaxDiskSpaceUsageEnabled

Or assign the maximum disk space for logs:

Set-SPDiagnosticConfig -LogDiskSpaceUsageGB 500

  1. To view the current logging level, at the Windows PowerShell command prompt, type the following command:

Get-SPLogLevel

  1. To change the logging level, at the Windows PowerShell command prompt, type the following command:

Set-SPLogLevel -TraceSeverity Monitorable

To set all categories back to default levels, at the Windows PowerShell command prompt, type the following command, and then press ENTER:

Clear-SPLogLevel

9. To enable event log flooding protection, at the Windows PowerShell command prompt, type the following command:

Set-SPDiagnosticConfig -EventLogFloodProtectionEnabled

Set Maximum Number of Site Collections in SharePoint Content Database using PowerShell

For Particular Requirement, client want to dedicate a database for a single site collection. When we create a site collection from central admin, site is placed automatically in any available content database. To prevent any other sites to be created on the particular content database, We can set the maximum number of sites limit.

To set maximum number of site collections on a particular content database, navigate to:

  • Central Administration >> Application Management >> Management Content databases
  • Select our target web application in which the particular content database is attached
  • Pick the target database from the list
  • Now, in the “Manage Content Database Settings” page we can set the maximum number of sites for the content database.

set-max-number-of-site-collections-in-a-content-database

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Variables for processing
$WebAppURL =”https://sharepointtechnicalsupport.com”
$MaxSiteCount=1
$WarningSiteCount = 0

#Get all content databases of the web application
$ContentDBColl = Get-SPContentDatabase -webapplication $WebAppURL

#Iterate through each database in the web application
foreach($Database in $ContentDBColl)
{
#Check the current No. of sites
if($MaxSiteCount -ge $Database.CurrentSiteCount)
{
#Set Maximum Sites, warning level Counts
Set-SPContentDatabase -Identity $Database.Name -MaxSiteCount $MaxSiteCount -WarningSiteCount $WarningSiteCount
Write-host “Max Sites Settings updated for the database:” $Database.name -ForegroundColor Green
}
else
{
write-host “MaxSiteCount must be > = current site count! No changes made in $($Database.Name)” -ForegroundColor Red
}
}

SharePoint 2016 Help Collection

In this article, we will discuss ,how to use PowerShell cmdlets for managing Help Collections SharePoint.

SharePoint help collection is not configured with SharePoint Configuration, This needs to manually configured.SharePoint Help Files(.Cab) installed on the hive folder with SharePoint Installation but not configured by default. In order to configure it we have to run the PowerShell commands.

when users click on the Help button  on their site collection, they get the following error

help

” Unfortunately, Help Seems to be broken,There aren’t any help collections in the current language for the site you’re using.”

unfortunately-help-seems-to-be-broken

Even if go to Site settings > Site administration > Help Settings will get this

home-error

Clearly Help collection is broken and now it is SharePoint Admins responsibility to fix the broken Help Collection.

S0lution :

In order to fix the broken help collection, following activities needs to be done.

Check the CAB files exist
Get the Current Help File Status
Install the Help File(s)
Testing

Check Help Files :

Logon the SharePoint Server and browse to the hive folder.

Go to “C:\program Files\Common Files\microsoft shared\web server extensions\16\HCCab

In this folder, make sure you see cab files for 14 & 15.

cab-file

If you have multiple language packs then check each language folder i.e English is 1033

  • Log on the server with farm admin account
  • Open PowerShell windows (Run as Administrator)
  • Run the Get-sphelpcollection command

get-sphelp

you can see nothing return even command completed successfully

Install Help files :

install all the available help,run the command with all options

  • Log on the server with farm admin account
  • Open PowerShell (Run as Administrator) and run Install-SPHelpCollection – All

install-sphelp

This command will install the help files available in the hive folder.
Wait for 5 minutes to completely install it, if you have multiple language packs install then even wait little more.
Now run Get-SpHelpCollection and you will get something like this.

get-sphelp2

Test it at both locations via site settings as well as from the browsing the Site collection.

Go to Site collection > Site settings > help Settings and you will see this option

home

Now if you click on the “?” (help button) on the top suite bar, you will get this pop up

central-admin-help

Uninstall :

As we noticed, we have 2010 help files also installed, we have to uninstall one by one.

  • Log on the server with farm admin account
  • Open PowerShell ( Run as administrator) and run this command
  • Uninstall-SpHelpCollection –Name “OSSEndUser.1033.12”

uninstall-help

Conclusion :

In this session we learned how to fix the broken Help Collection.

Keep reading and learning.