ServiceBroker

Get-DbaDbServiceBrokerQueue

Ant Green (@ant_green)

Get-DbaDbServiceBrokerQueue View Source Ant Green (@ant_green) Windows, Linux, macOS Synopsis Gets database service broker queues Description Gets database Sservice broker queue Syntax Get-DbaDbServiceBrokerQueue [[-SqlInstance] <DbaInstanceParameter[]>] [[-SqlCredential] <PSCredential>] [[-Database] <Object[]>] [[-ExcludeDatabase] <Object[]>] [-ExcludeSystemQueue] [-EnableException] [<CommonParameters>] Examples Example: 1 PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance sql2016 Gets all database service broker queues Example: 2 PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance Server1 -Database db1 Gets the service broker queues for the db1 database Example: 3 PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance Server1 -ExcludeDatabase db1 Gets the service broker queues for all databases except db1

Get-DbaDbServiceBrokerService

Ant Green (@ant_green)

Get-DbaDbServiceBrokerService View Source Ant Green (@ant_green) Windows, Linux, macOS Synopsis Retrieves Service Broker services from SQL Server databases for auditing and troubleshooting messaging configurations Description Retrieves detailed information about Service Broker services configured in SQL Server databases, including service names, associated queues, schemas, and ownership details. Service Broker services define the endpoints for reliable messaging between applications and databases. This function helps DBAs audit Service Broker implementations, troubleshoot message-based applications, and document messaging configurations for compliance or migration planning.