New command - Find-DBATrigger and Find-DBAView

[SQLDBAWithABeard]

Is this:

Just place "x" to indicate selection (e.g. "[x]")

• [ x] feature
• bug:

Request from James Anderson @databaseavenger

Please can you do the same magic for views and triggers as find-dbastoredprocedure please

[potatoqualitee]

ouuuu i dig. @ClaudioESSilva or @Staggerlee011

[SQLDBAWithABeard]

So this came about because of a conversation with James. He needed to find the Stored Procedures, Triggers and Views that referenced a specific column in a specific table in a specific way in a database.

He had to script out the entire database and use RegEx to do this. He asked if dbatools would do so and I said yes Find-DbaStoredProcedure could have done the Stored Procedures but not the triggers or the views.

Therefore the feature request is for Find- commands for Triggers and Views that will enable user to search them both using wildcard and regex in the same way as Find-DbaStoredProcedure

[ClaudioESSilva]

Done: #1521 😄

So for triggers I took into account the 3 levels (Server, Database and Object)

[potatoqualitee]

rock on, yall!