April 16, 2019 / Last updated : April 16, 2019 Sethu Customization

How to get alerts for a specific policy in Cloud app security using Powershell

Hello Bloggers, In this blog, we can see how to get alerts for a specific policy in Cloud app security using Powershell. —————————————————————————————————————————– $Body = @{ “filters” = @{ “entity.policy”=@{“eq”=”5ae2481bfddeab61625fb5ef”} “resolutionStatus”=@{“eq”=0} } } | ConvertTo-Json $Header = @{Authorization =”Token Your Token”} $response = Invoke-RestMethod  -Uri “https://yourportal.us2.portal.cloudappsecurity.com/cas/api/v1/alerts/” -Headers $Header -Method POST -body $body -Verbose $response.data
April 9, 2019 / Last updated : April 9, 2019 Sethu Customization

How to get the list of custom apps in App catalog using Powershell?

Hello Sharepointers. Below are the powershell script get the list of custom apps in App catalog using Powershell using (ClientContext context = new ClientContext(“https://youroffice-admin.sharepoint.com”)) { Tenant tenant = new Tenant(context); tenant.Context.Load(tenant); tenant.Context.ExecuteQueryRetry(); var appCatalogAppInfoCollection = tenant.GetAppInfoByName(string.Empty); tenant.Context.Load(appCatalogAppInfoCollection); tenant.Context.ExecuteQueryRetry(); foreach (var app in appCatalogAppInfoCollection) { Debug.WriteLine(“APP: ” + app.Name); Debug.WriteLine(“Source: ” + app.Source); } } Happy […]
March 6, 2019 / Last updated : March 6, 2019 Sethu Customization

How to get all site owners in SharePoint Online using Powershell?

Hello SharePointers. Below are the powershell script to get all the site owners of all the SharePoint sites. foreach($site in $sites) { $siteURL = $site.Url $siteOwner = $site.Owner Write-Host $siteURL -ForegroundColor Blue Write-Host $siteOwner -ForegroundColor Blue $siteAdmins = Get-SPOUser -Site $siteURL -Limit All | select LoginName,IsSiteAdmin | ? { $_.ISSiteAdmin } $siteUsers = “” foreach($siteAdmin […]
December 22, 2018 / Last updated : December 22, 2018 Sethu Customization

How to use Compare Block helpers in SPfx framework ?

In SharePoint Online, you can user Compare block helpers to render data based on the condition. Here are the examples {{#compare pageContext.web.language ‘==’ 1033}} <h1>This is rendered if current language is 1033</h1> {{else}} <h1>This is rendered if current language is anything else {{/compare}} In this sample, based on the language , the SharePoint content will […]
December 19, 2018 / Last updated : December 19, 2018 Sethu Customization

How to get SharePoint List Version using JSOM in SharePoint Online?

var Ctx = new SP.ClientContext.get_current(); if (Ctx) { var Web = Ctx.get_web(); var List = Web.get_lists().getByTitle(Name); var query = new SP.CamlQuery(); query.set_viewXml(xmlQuery); var listItems = List.getItems(query); Ctx.load(listItems); Ctx.executeQueryAsync(function (sender, args) { that.DataSet = []; var objlistEnumerator = objlistItems.getEnumerator(); while (objlistEnumerator.moveNext()) { var objListItem = objlistEnumerator.get_current(); var id = objListItem.get_item(‘ID’); var filePath = ‘https://mysharepoint/Lists/Preservenature/’+id+’_.000’ var web […]
June 24, 2017 / Last updated : June 24, 2017 Sethu Customization

How to Check if Site exists in SharePoint Online/ Office 365 using CSOM?

Hello SharePointers, Below is the CSOM code to check  if site exists in SharePoint Online/ Office 365. function CheckifSiteExists() { param( [Parameter(Mandatory=$true)][string]$siteurl  )   begin{ $context = New-Object Microsoft.SharePoint.Client.ClientContext($siteurl) $web = $context.Web $context.Load($web) try {    $context.ExecuteQuery()         return $true        }   catch { return $false        […]
May 25, 2017 / Last updated : May 25, 2017 Sethu Client Side Object Model

How to Set People Picker value in SharePoint using CSOM and Powershell?

Hello SharePointers, Below are the CSOM script to set/populate People Picker value in a SharePoint list . $userName = “domain\username” $spuser = EnsureUser $context $userName $lookupValue = @() if($spuser -ne $null){ $spuserValue = New-Object Microsoft.SharePoint.Client.FieldUserValue $spuserValue.LookupId = $spuser.id $lookupValue += $spuserValue } $userValue = [Microsoft.SharePoint.Client.FieldUserValue[]]$lookupValue $listItem[“Your People Picker FieldColumn name”] = $userValue $listItem.Update() Happy SharePointing […]
May 25, 2017 / Last updated : May 25, 2017 Sethu Customization

How to get SharePoint list item counts using REST API?

Hello SharePointers Below is REST API code to get the sharepoint list item counts using REST API. var ListUrl = _spPageContextInfo.webServerRelativeUrl + “/_api/web/lists/getbytitle(‘yourlistname’)/items”; getJsonFormat(ListUrl) .done(function(data) { var itemsCount = data.d.results.length;  }) .fail( function(error){ console.log(JSON.stringify(error)); }); function getJsonFormat(ListUrl) { return $.ajax({ url: ListUrl, type: “GET”, contentType: “application/json;odata=verbose”, headers: { “Accept”: “application/json;odata=verbose” } }); } Happy SharePointing […]