Elencare i database di una farm SharePoint con PowerShell / Sgart.it

Tramite il comando Get-SPServer di PowerShell è possibile elencare i database che compongono una farm SharePoint OnPrem

# Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPDatabase | select DisplayName, Server, Version, Status, Exists, NeedsUpgrade, IsReadOnly,TypeName, id | Format-Table -AutoSize

da un risultato simile al seguente

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...

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.