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.
