Find-DbaObject

[shishini]

Summarize Command's Functionality

I need to search a database server (all databases on that server), perferable multiple services at once, but I guess I can loop I need to find all objects that match a pattern

For example, I want to find all tables, views, stored procedures that mention Service, Service can be the name of table or columns within table tables, or columns in views, or columns in stored precedure

Currently i Can search Stored Procedures, Triggers, View and User objects Using 4 different commands

1. Find-DbaStoredProcedure
2. Find-DbaTrigger
3. Find-DbaUserObject
4. Find-DbaView

But I cant find a way to search tables, or aliases or other objects

I need single command that search for all objects types, possibly with a parameter to specify a list of object types would be nice i.e. a global search command