dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Find-DbaCommand

Finds dbatools commands searching through the inline help text, building a consolidated json index and querying it because Get-Help is too slow.

Screenshots

Examples

For lazy typers: to find all commands searching the entire help for “snapshot”

Find-DbaCommand snapshot

For rigorous typers: to find all commands searching the entire help for “snapshot”

Find-DbaCommand -Pattern snapshot

To find all commands tagged with DisasterRecovery

Find-DbaCommand -Tag DisasterRecovery

To find all commands tagged with BOTH “copy” and “user”

Find-DbaCommand -Tag Backup, Restore

To find every command whose author contains our beloved “chrissy”

Find-DbaCommand -Author chrissy

To find every command whose author contains our beloved “chrissy” and it tagged as “Migration”

Find-DbaCommand -Author chrissy -Tag Migration

To find all commands searching the entire help for “snapshot”, rebuilding the index (good for developers)

Find-DbaCommand -Pattern snapshot -Rebuild

Author

This command was created by Simone Bizzotto. You can find Simone on LinkedIn.

Get-Help

From PowerShell, execute Get-Help Find-DbaCommand -Detailed for more information on this function.

Source Code

Want to see the source code? View Find-DbaCommand.ps1 on GitHub
 

Related commands