Tuesday, 1 March 2016

OneLiners for PowerShell with SharePoint for Visio Service Application

#View Visio External data
Get-SPVisioServiceApplication | Get-SPVisioExternalData|select *
#View Performance Related data
Get-SPVisioServiceApplication |Get-SPVisioPerformance
<#
MaxDiagramSize     : 25
MinDiagramCacheAge : 5
MaxDiagramCacheAge : 60
MaxRecalcDuration  : 60
MaxCacheSize       : 5120
#>
#View Data Providers for Visio
Get-SPVisioServiceApplication |Get-SPVisioSafeDataProvider
#View Visio Service App ID
Get-SPVisioServiceApplication
(Get-SPVisioServiceApplication).ID
#View Service Application Proxy
Get-SPVisioServiceApplicationProxy

Wednesday, 24 February 2016

OneLiners in PowerShell with SharePoint for User

#View Users for Web Application/Site collection
#To view sample sites Get-SpWeb -Site "http://intranet.contoso.com/sites/contoso/"
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2"
#View count of Users
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2" |measure
#View SiteAdmins
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2"|?{$_.IsSiteAdmin -eq $true}
#View Site Auditor
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2"|?{$_.IsSiteAuditor -eq $true}
#View Users starting with j
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2"|?{$_.DisplayName -like "j*"}
#View App Account
Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2"|?{$_.DisplayName -like "*app*"}
#View DisplayNames of all Users
(Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2").DisplayName
#View Emails
(Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2").Email
#View Groups
(Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2").Groups.Name
#View User IDs
(Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2").UserID
#ViewUSer Login
(Get-SPUser -Web "http://intranet.contoso.com/sites/contoso/blog2").UserLogin
Get-SPUserLicense
#View all claim-to-user license mappings
Get-SPUserLicenseMapping -WebApplication "http://w15-sp"
Get-SPUserLicenseMapping
#To add New-SPUserLicenseMapping -SecurityGroup "Viewers" -License Enterprise | Add-SPUserLicenseMapping
#Check if UserLicensing is Enabled
Get-SPUserLicensing
#User PRofile Settings
Get-SPUserSettingsProvider
#ID  of User PRofile Settings
(Get-SPUserSettingsProvider).ProviderIdentifier
#User PRofile Settings Manager
Get-SPUserSettingsProviderManager
# DisplayName of User PRofile Settings Manager
(Get-SPUserSettingsProviderManager).DisplayName
#Id of User PRofile Settings Manager
(Get-SPUserSettingsProviderManager).Id
#Version of User PRofile Settings Manager
(Get-SPUserSettingsProviderManager).Version
#Status of User PRofile Settings Manager
(Get-SPUserSettingsProviderManager).Status
#TypeName of User PRofile Settings Manager
(Get-SPUserSettingsProviderManager).TypeName

Tuesday, 23 February 2016

OneLiners in Powershell with SharePoint for Usage

#Get Usage Application details
Get-SPUsageApplication
#View Usage Definition
Get-SPUsageDefinition
#Usage Service
Get-SPUsageDefinition|select TableName,Description,DaysToKeepDetailedData
#View App related Usage
Get-SPUsageDefinition | ?{$_.Tablename -like "*App*"}|select *
#View Usage Directory Log
(Get-SPUsageService).UsageLogDir

Monday, 22 February 2016

OneLiners in POwerShell with SharePoint for Security

#Get Identity Token ISsuer
Get-SPTrustedIdentityTokenIssuer
#View Trusted Root Authority
Get-SPTrustedRootAuthority
#View all TRusted Root Authority
(Get-SPTrustedRootAuthority).Name
#View TRusted Root Authority for Exchange
(Get-SPTrustedRootAuthority)| ?{$_.Name -like "*Exchange*"}|select Name,Certificate
#View Security Token Issuer
(Get-SPTrustedSecurityTokenIssuer).NameID
#View Service Token ISsuer
Get-SPTrustedServiceTokenIssuer
#NEw Service Token Issuer for Sharepoint trust
New-SPTrustedServiceTokenIssuer -Name "WFEFarmTrust1" -Description "WFEFarm Trust1"  -MetadataEndPoint "https://liveid.com/STS/2007/03/fedmetadata.xml" -WhatIf

OneLiners in PowerShell with SharePoint for Translation Throttling Settings

#View Translation Throtting Settings
Get-SPTranslationThrottlingSetting
# View DiskSizeRequired for TranslationThrottlingSetting
(Get-SPTranslationThrottlingSetting).DiskSizeRequired
# View SiteQuota for TranslationThrottlingSetting
(Get-SPTranslationThrottlingSetting).SiteQuota
# View TenantQuota for TranslationThrottlingSetting
(Get-SPTranslationThrottlingSetting).TenantQuota
# View TypeName for TranslationThrottlingSetting
(Get-SPTranslationThrottlingSetting).TypeName
# View DisplayName for TranslationThrottlingSetting  
(Get-SPTranslationThrottlingSetting).DisplayName
# View Id for TranslationThrottlingSetting
(Get-SPTranslationThrottlingSetting).Id    

OneLiners in PowerShell with SharePoint for Topology/Application Discovery and Load Balancer Service Application

#View Topology Service App Details.Application Discovery and Load Balancer Service Application
Get-SPTopologyServiceApplication
#Load Balance Url
(Get-SPTopologyServiceApplication).LoadBalancerUrl
#View PRoxy of Topology Service App
Get-SPTopologyServiceApplicationProxy
#View BAd List Period
(Get-SPTopologyServiceApplicationProxy).BadListPeriod
#View Display Name
(Get-SPTopologyServiceApplicationProxy).TypeName
#To set LoadBalance URl
Set-SPTopologyServiceApplication -Identity (Get-SPTopologyServiceApplication).ID -LoadBalancerUrl "https://testurl" -whatif

Sunday, 21 February 2016

OneLiners in PowerShell with SharePoint for Timer Jobs

Add-PSSnapin "Microsoft.SharePoint.PowerShell"
#View timer jobs for a web application
Get-SPTimerJob -WebApplication "http://w15-sp"
#Site deletion timer job
Get-SPTimerJob -Identity "job-site-deletion"
#View workflow timerjobs
Get-SPTimerJob | ?{$_.Name -like "*workflow*"}
#View Recent Run Timer Jobs run in last hour
Get-SPTimerJob | ?{$_.LastRunTime -ge (Get-Date).AddHours(-1)}|measure
Measure-Command {Get-SPTimerJob | sort LastRunTime -Descending | select * -first 10}
Get-SPTimerJob | ?{$_.Schedule -like "*weekly*"}
Get-SPTimerJob | ?{$_.Schedule -like "*minutes*"}
Get-SPTimerJob | ?{$_.Schedule -like "*daily*"}
#Count of Jobs running hourly
Get-SPTimerJob | ?{$_.Schedule -like "*hourly*"} | measure
Get-SPTimerJob|sort Name|select Name,Description -Unique| out-gridview