Paul, this provided exactly what I was looking for. Thanks! Query I used in SQL:
SELECT AssignmentName
,CollectionName
,NotifyUser
,UserUIExperience
,ApplicationName
FROM v_ApplicationAssignment
Where NotifyUser = 1
This allowed me to find all the ones that were set to show all notifications,
which I then went back and fixed in the console.
Thanks again!
-Phil
_________________________________________________________________
Phil Schwan | Technical Specialist, Enterprise Windows Services
Project Leadership Associates | 2000 Town Center, Suite 1900, Southfield, MI
48075
Lync: 312.756.1626 Mobile: 419.262.5133
www.projectleadership.net<http://www.projectleadership.net/>
[Description: Description: Description: Arrow email]Lead with Strategy.
Leverage Technology. Deliver Results.
[linkedin_logo-19x20]<http://www.linkedin.com/in/philschwan>[Twitter-Logo1-20x20]<https://twitter.com/philschwan>
[wordpress-logo3] <http://myitforum.com/myitforumwp/author/philschwan>
From: [email protected] [mailto:[email protected]] On
Behalf Of Schwan, Phil
Sent: Thursday, December 12, 2013 5:05 PM
To: [email protected]
Subject: [mssms] RE: Query for Deployment Notification Settings
Cool...I'll take a look. Thanks!
-Phil
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Paul Kaufman
Sent: Thursday, December 12, 2013 1:28 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: Query for Deployment Notification Settings
This might get you started in PowerShell. Note the WHERE clause in the query
statement - you might want to adjust that to fit your needs better.
# hide all notifications
#NofityUser = False
#UserUIExperience=False
# display all notifications
#NofityUser = True
#UserUIExperience=True
# display restart notification only
#NofityUser = True
#UserUIExperience=False
$server = "YOURSERVER"
$namespace = "Root\SMS\site_YOURSITECODE"
$class = "SMS_ApplicationAssignment"
$query = "SELECT * FROM $class WHERE NotifyUser='True' OR
UserUIExperience='True'"
$assignments = Get-WmiObject -query $query -ComputerName $server -Namespace
$namespace
$assignments | select ApplicationName, CollectionName, UserUIExperience,
NotifyUser
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Schwan, Phil
Sent: Thursday, December 12, 2013 10:22 AM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] Query for Deployment Notification Settings
I could have sworn somebody had posted this previously, but my Google Fu is
weak today.
Does anyone know of a way...SQL query, PowerShell cmdlet, etc....to generate a
list of deployments and the user experience notification settings? I've seen a
couple situations now where reports have come in of users receiving popup
notifications that new software is available, and those notifications are
supposed to be suppressed for any standard applications. It would be extremely
helpful to have a way to quickly identify which applications were set to
display all notifications.
Many thanks in advance,
Phil
_________________________________________________________________
Phil Schwan | Technical Specialist, Enterprise Windows Services
Project Leadership Associates | 2000 Town Center, Suite 1900, Southfield, MI
48075
Lync: 312.756.1626 Mobile: 419.262.5133
www.projectleadership.net<http://www.projectleadership.net/>
[Description: Description: Description: Arrow email]Lead with Strategy.
Leverage Technology. Deliver Results.
[linkedin_logo-19x20]<http://www.linkedin.com/in/philschwan>[Twitter-Logo1-20x20]<https://twitter.com/philschwan>
[wordpress-logo3] <http://myitforum.com/myitforumwp/author/philschwan>
________________________________
PRIVILEGED AND CONFIDENTIAL. This email and any files transmitted with it are
privileged and confidential and intended solely for the use of the individual
or entity to whom they are addressed. If you have received this email in error
please notify the sender. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail or any of its attachments.
<<inline: image001.jpg>>
<<inline: image002.jpg>>
<<inline: image003.jpg>>
<<inline: image004.jpg>>
