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