Test-CsDatabase shortcuts

I don’t know about you, but I’m not getting any younger, and my eyes often glaze over when faced with a table of numbers to compare for differences.

This is often the case when I issue one of my fave p$ shortcuts to test my SfB server’s databases:

Test-csDatabase -LocalService | ft *name,*edver*

Do this on every server in a large pool – or every server in a vast environment – and you might start to experience the same optical distress.

Here’s a variation on the above that ONLY reveals the Databases that fail to match:

Test-CsDatabase -LocalService | where-object {$_.InstalledVersion -notMatch $_.ExpectedVersion} | Select *Name,*edVersion

Replace “-LocalService” with “-ConfiguredDatabases -SqlServerFqdn”, etc, for an Enterprise Edition pool and for Monitoring or Chat databases. (Cmdlet reference).
 
– G.

Leave a Reply

Your email address will not be published. Required fields are marked *

... and please just confirm for me that you're not a bot first: Time limit is exhausted. Please reload the CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.