Today I needed get a list of deployments that had the user notification set to “Display in Software Center and show all notifications” so I could update the deployments so users would not get the “New Software is Available” toast on available deployments. I was able to use this query to determine this.
1 2 3 4 5 6 |
SELECT [AssignmentName] ,[CollectionName] ,[NotifyUser] ,[EnforcementDeadline] FROM [vSMS_AssignmentBase] WHERE (NotifyUser='1' AND EnforcementDeadline Is Null) |