Elencare i database di una farm SharePoint con PowerShell
26 ottobre 2020
Tramite il comando Get-SPServer di PowerShell è possibile elencare i database che compongono una farm SharePoint OnPrem
da un risultato simile al seguente
Anche in questo caso, come nel precedente, va prestata attenzione alla colonna NeedsUpgrade.
Se True il flag indica che sono stati installati degli aggiornamenti, ma non è stato eseguito lo SharePoint 2010 Products Configuration Wizard su ogni server della farm.
Questo vuol dire che il database si trova in uno stato di compatibilità, indicato nella Central Administration (/_admin/DatabaseStatus.aspx) con la scritta Database is in compatibility range and upgrade is recommended.
PowerShell
# Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPDatabase | select DisplayName, Server, Version, Status, Exists, NeedsUpgrade, IsReadOnly,TypeName, id | Format-Table -AutoSize
DisplayName Server Version Status Exists NeedsUpgrade IsReadOnly TypeName
----------- ------ ------- ------ ------ ------------ ---------- --------
StateService SPServer Name=SharePointDB 35467 Online True False False Microsoft.Office.Server.Administration.StateDatabase d82...
Secure_Store_Service_DB SPServer Name=SharePointDB 35470 Online True False False Microsoft.Office.SecureStoreService.Server.SecureStoreServiceDatabase b93...
WordAutomationServices SPServer Name=SharePointDB 35489 Online True False False Microsoft.Office.Word.Server.Service.QueueDatabase 467...
User Profile Service Application_SocialDB SPServer Name=SharePointDB 35493 Online True True False Microsoft.Office.Server.Administration.SocialDatabase f71...
Bdc_Service_DB SPServer Name=SharePointDB 92984 Online True False False Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase a9b...
WebAnalyticsServiceApplication_StagingDB SPServer Name=SharePointDB 35532 Online True True False Microsoft.Office.Server.WebAnalytics.Administration.WebAnalyticsStagerDatabase 659...
SharePoint_Config SPServer Name=SharePointDB 201 Online True True False Configuration Database 817...
PerformancePoint Service Application SPServer Name=SharePointDB 35473 Online True False False Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceDatabase 660...
Search_Service_Application_CrawlStoreDB SPServer Name=SharePointDB 1162825 Online True False False Microsoft.Office.Server.Search.Administration.SearchGathererDatabase 83b...
Search_Service_Application_PropertyStoreDB SPServer Name=SharePointDB 1162817 Online True False False Microsoft.Office.Server.Search.Administration.SearchPropertyStoreDatabase 9c3...
Application_Registry_Service_DB SPServer Name=SharePointDB 1136 Online True False False Microsoft.Office.Server.ApplicationRegistry.SharedService.ApplicationRegistryServiceDatabase 662...
SharePoint_AdminContent SharePointDB\Instance1 35527 Online True True False Content Database 36e...
WSS_Content_Principale SharePointDB\Instance1 909867 Online True True False Content Database 183...
WSS_Content_WeabApp2 SharePointDB\Instance1 909879 Online True False False Content Database 25a...
WSS_Search_IDX SPServer Name=SharePointDB 1395249 Online True True False Microsoft.SharePoint.Search.Administration.SPSearchDatabase bcb...
Search_Service_Application_DB SPServer Name=SharePointDB 1162780 Online True False False Microsoft.Office.Server.Search.Administration.SearchAdminDatabase 775...
Managed Metadata SPServer Name=SharePointDB 708856 Online True False False Microsoft.SharePoint.Taxonomy.MetadataWebServiceDatabase fcb...
User Profile Service Application_ProfileDB SPServer Name=SharePointDB 35492 Online True True False Microsoft.Office.Server.Administration.ProfileDatabase fd9...
WSS_Logging SPServer Name=SharePointDB 35486 Online True True False Microsoft.SharePoint.Administration.SPUsageDatabase 0ca...
User Profile Service Application_SyncDB SPServer Name=SharePointDB 35494 Online True False False Microsoft.Office.Server.Administration.SynchronizationDatabase ec0...
WebAnalyticsServiceApplication_ReportingDB SPServer Name=SharePointDB 35534 Online True True False Microsoft.Office.Server.WebAnalytics.Administration.WebAnalyticsWarehouseDatabase 054...
Se True il flag indica che sono stati installati degli aggiornamenti, ma non è stato eseguito lo SharePoint 2010 Products Configuration Wizard su ogni server della farm.
Questo vuol dire che il database si trova in uno stato di compatibilità, indicato nella Central Administration (/_admin/DatabaseStatus.aspx) con la scritta Database is in compatibility range and upgrade is recommended.