How do I get the SharePoint farm database status using below PowerShell script?
$baddb = Get-SPDatabase -id 25dfdfdf73-d941-4f66-9e92-18b19e7e5c79
It returns Name, Typd & Id but not status...
-
What kind of status are you expecting? Read-Only? Orphaned items?Benny Skogberg– Benny Skogberg ♦2016-12-05 09:27:47 +00:00Commented Dec 5, 2016 at 9:27
Add a comment
|
1 Answer
Try this
$baddb = Get-SPDatabase -id 25dfdfdf73-d941-4f66-9e92-18b19e7e5c79
$baddb | Select Name,Status
It should show Name and online or offline status based on database status
[OutPut]
[Update]
Based on your comment, in this case , you will need to show NeedsUpgrade that has true or false value
- False refer to no action required.
- True refer to Database running in compatibility range and upgrade recommended
EX: get all SharePoint databases name with upgrade status
Get-SPDatabase | select Name,NeedsUpgrade
answered Dec 5, 2016 at 9:32
-
i tried this its not showing like in central admin page _admin/DatabaseStatus.aspx status like not respondingadilahmed– adilahmed2016-12-05 10:38:28 +00:00Commented Dec 5, 2016 at 10:38
-
in this case, you need to show NeedsUpgrade column, it shows false if no action required and true if require upgrade , let me update my answer based on your comment2016-12-05 10:54:57 +00:00Commented Dec 5, 2016 at 10:54