You’re offline. This is a read only version of the page.
Announcements
2
Hi,
I've been asked to write a PowerShell script to get all SharePoint site URLs which are associated with DataVerse. Any suggestions how to go about that?
Thanks,
Zain
So you can get a range of site information via powershell regarding sharepoint:
Get-SPOSiteGroup (Microsoft.Online.SharePoint.PowerShell) | Microsoft Learn
But its looks limited to dataverse connections.
I found this script:
Share
Report
All responses (
Answers (
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA 0
Start-SPAssignment –Global
$spSites = Get-SPSite -Limit All
$spWAs = Get-SPWebApplication -IncludeCentralAdministration
$csvs = @()
#Get Web Application Data
Write-Host("Getting Web Application Data")
$spWAs | select Name, DisplayName, Id, Url, ApplicationPool, @{Expression={$_.ApplicationPool.Name}}, @{Expression={$_.ApplicationPool.UserName}}, DefaultQuotaTemplate | Export-CSV $bkdir\SPWebApplication.csv
$csvs += C:\SPWebApplication.csv
#Get Site Collection Data
Write-Host("Getting Site Collection Data")
$spSites | select Id, HostName, Url, Owner,WebApplication, ContentDatabase, RootWeb, LastContentModifiedDate, @{Expression={$_.Usage.Storage}} | Export-CSV $bkdir\SPSite.csv
$csvs += C:\SPSite.csv
#Get Site Data
Write-Host("Getting Site Data")
$spSites | Get-SPWeb -Limit All | select ID, Title, Author, Url, WebTemplate, LastItemModifiedDate, IsRootWeb | Export-CSV $bkdir\SPWeb.csv
$csvs += C:\SPWeb.csv
Stop-SPAssignment –Global
The #getsitedata section may help if you have a field that mirrors a dataverse field.
