Home / Commands / Find-sqmDatabaseObject
Find-sqmDatabaseObject
Inventory sqmSQLTool v1.8.2+
Searches all (or selected) databases on an instance for an object name.

Examples

Find-sqmDatabaseObject -SqlInstance "SQL01" -ObjectName "sp_GetOrders"
Find-sqmDatabaseObject -SqlInstance "SQL01" -ObjectName "sp_GetOrders"
Find-sqmDatabaseObject -SqlInstance "SQL01" -ObjectName "*log*" -ObjectType "TABLE","VIEW" -Database "Sales*"
Find-sqmDatabaseObject -SqlInstance "SQL01" -ObjectName "*log*" -ObjectType "TABLE","VIEW" -Database "Sales*"
← Previous Command
Export-sqmServerConfiguration
Next Command →
Get-sqmLinkedServerUsage