背景:
阅读新闻

get site, web and list information with PowerShell for SharePoint Online

  作者: 今日评论: [字体: ]
function connectToO365 {   # Let the user fill in their admin url, username and password   $userName = "XXXX"   $passwordOrg = "XXXX"   $password = $(convertto-securestring $passwordOrg -asplaintext -force)   $adminUrl = "https://XXXX-admin.sharepoint.com/" #SharePoint Online Administration Center   # set credentials   $credentials = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $userName, $password   $SPOCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userName, $password)   #connect to to Office 365   try {     Connect-SPOService -Url $adminUrl -Credential $credentials     write-host "Info: Connected succesfully to Office 365" -foregroundcolor green   }   catch {     write-host "Error: Could not connect to Office 365" -foregroundcolor red     Break connectToO365   }      #create HTML file   $filePath = create-outputfile      #start getting site collections   get-siteCollections   add-content -value "   </body>   </html>   " -path $filePath }    function create-outputfile() {   #Create unique string from the date   $date = get-date -format dMMyyyyhhmm      #set the full path   $filePath = "$($PSScriptRoot)\Output$($date).html"      #test path   if (!(Test-Path -path $filePath)) {     #create file     New-Item $filePath -type file | out-null        #print info     write-host “File created: $($filePath)” -foregroundcolor green        #add start HTML information to file     add-content -value "   <html>   <body>   <h1>Sites information Office 365</h1>   <table border='1' style='font-family: Calibri, sans-serif'>   <tr>   <th style='background-color:blue; color:white'>URL</th>   <th style='background-color:blue; color:white'>Type</th>   <th style='background-color:blue; color:white'>Template</th>   <th style='background-color:blue; color:white'>Item Count</th>   </tr>   " -path $filePath   }      else {     #break so there won't be duplicate files     write-host "Output file already exists, wait 1 minute" -foregroundcolor yellow     Break create-outputfile   }   return $filePath }    function get-siteCollections {   #Get all site collections   $siteCollections = Get-SPOSite      #loop through all site collections   foreach ($siteCollection in $siteCollections) {     #set variable for a tab in the table     $pixelsweb = 0     $pixelslist = 0        #add info to HTML document     add-content -value "<tr style='background-color:cyan'><td>$($siteCollection.url)</td><td>TopSite</td><td>$($sitecollection.template)</td><td></td></tr>" -path $filePath     write-host "Info: Found $($siteCollection.url)" -foregroundcolor green     #search for webs     $AllWebs = Get-SPOWebs($siteCollection.url)   } }    function Get-SPOWebs($url) {      #fill metadata information to the client context variable   $context = New-Object Microsoft.SharePoint.Client.ClientContext($url)   $context.Credentials = $SPOcredentials   $web = $context.Web   $context.Load($web)   $context.Load($web.Webs)   $context.load($web.lists)   try {        $context.ExecuteQuery()     #loop through all lists in the web     foreach ($list in $web.lists) {       add-content -value "<tr><td><span style='margin-left:$($pixelslist)px'>$($list.title)</td><td>$($list.BaseType)</td><td></td><td>$($list.itemcount)</td></tr>" -path $filePath     }        #loop through all webs in the web and start again to find more subwebs     $pixelsweb = $pixelsweb + 15     $pixelslist = $pixelslist + 15        foreach ($web in $web.Webs) {       add-content -value "<tr style='background-color:yellow'><td><span style='margin-left:$($pixelsweb)px'>$($web.url)</td><td>Web</td><td>$($web.webtemplate)</td><td></td></tr>" -path $filePath       write-host "Info: Found $($web.url)" -foregroundcolor green       Get-SPOWebs($web.url)     }   }   catch {     write-host "Could not find web" -foregroundcolor red   } }    connectToO365
来源:https://www.cloudsecuritea.com/2016/01/get-site-web-and-list-information-with-powershell-for-sharepo
录入日期:[2020/06/29 18:41:00]
收藏 推荐 打印 | 录入:mikebai | 阅读:
文章评论      
正在加载评论列表...
评论关闭