ServiceBroker

Get-DbaDbServiceBrokerQueue

Ant Green (@ant_green)

Get-DbaDbServiceBrokerQueue View Source Ant Green (@ant_green) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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: Gets all database service broker queues PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance sql2016 Example 2: Gets the service broker queues for the db1 database PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance Server1 -Database db1 Example 3: Gets the service broker queues for all databases except db1 PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance Server1 -ExcludeDatabase db1 Example 4: Gets the service broker queues for all databases that are not system objects PS C:\> Get-DbaDbServiceBrokerQueue -SqlInstance Server1 -ExcludeSystemQueue Optional Parameters -SqlInstance The target SQL Server instance or instances

Get-DbaDbServiceBrokerService

Ant Green (@ant_green)

Get-DbaDbServiceBrokerService View Source Ant Green (@ant_green) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.