get information from a service broker queue for monitoring purposes

gistfile1.txt

SELECT
	COUNT([QUEUENAME].[conversation_handle])
FROM [QUEUENAME]
INNER JOIN sys.service_message_types
	ON [QUEUENAME].[message_type_id] = sys.service_message_types.[message_type_id]
INNER JOIN sys.conversation_endpoints
	ON [QUEUENAME].[conversation_handle] = sys.conversation_endpoints.[conversation_handle]
WHERE sys.service_message_types.name = 'NServiceBusTransportMessage'
	AND sys.conversation_endpoints.security_timestamp > @minDate