cleanup, no more pipeline, .where

[CodyMathis123]

Automatically determine site code, only need SMS Provider FQDN.

Remove the use of pipeline

$null on left side of comparison to keep pester tests happy

Implement 'foreach' loop instead of .where filter for cleaning up unneeded / bad deployments

Switch to SQL queries to improve run time

Testing with @TeslaSysA to ensure functionality.

[Ebag333]

@CodyMathis123 this now has a conflict with the previous PR that Tesla submitted. You'll need to resolve that commit (you can try using rebase).

[CodyMathis123]

@Ebag333 thanks for the heads up.

It looks to be resolved now. Worked with @TeslaSysA to make this potentially usable as a status filter rule script.