Skip to content

Instantly share code, notes, and snippets.

@shaneis
Last active March 15, 2018 23:58
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
We have a match!
$DatabaseParam = @{
SqlInstance = 'localhost\SQLDEV2K14'
Database = 'DMODisabled'
}
Get-DbaDatabase @DatabaseParam |
Select-Object -ExpandProperty Tables |
Where-Object { $_.Name -notmatch "\d{4,6}$" } |
ForEach-Object -Process {
[PSCustomObject]@{
Name = $_.Name
RowCount = $_.RowCount
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment