SCSM Views Not Replicating To Other Consoles

I recently had an issue with our own environment where any views created on the primary SCSM server were not visible by Service Desk staff. Also, any changes made to the current views were only visible on the primary Service Manager server.

This brought me back to when another customer had this issue in the past. The fix is actually fairly simple; you just need to ensure that the SQL broker is enabled on the ServiceManager primary database.

I believe the broker sometimes gets disabled when you upgrade Service Manager or SQL (I’m yet to confirm this).

To check if the broker is enabled run the following query in SQL Management Studio:

SELECT is_broker_enabled FROM sys.databases WHERE name =’ServiceManager’

 

If this returns ‘0’ rather than ‘1’ you’ll need to enable it with the following query (make sure you do this out of hours as it will drop any live connections to the DB):

USE master

GO

ALTER DATABASE ServiceManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE ServiceManager SET ENABLE_BROKER

ALTER DATABASE ServiceManager SET MULTI_USER