All hidden advertisements

A report to show all advertisements that are hidden from the users.

SELECT AdvertisementID, AdvertisementName,
CASE
  WHEN AdvertFlags & 0x02000000 = 0x02000000 Then 'Yes'
  ELSE 'No'
END AS 'No Display'
FROM v_Advertisement
WHERE AdvertFlags & 0x02000000 = 0x02000000

AdvertFlags

• 0x00000020 (5)
  IMMEDIATE. Announce the advertisement to the user immediately.
• 0x00000100 (8)
  ONSYSTEMSTARTUP. Announce the advertisement to the user on system startup.
• 0x00000200 (9)
  ONUSERLOGON. Announce the advertisement to the user on logon.
• 0x00000400 (10)
  ONUSERLOGOFF. Announce the advertisement to the user on logoff.
• 0x00008000 (15)
  WINDOWS_CE. The advertisement is for a device client.
• 0x00020000 (17)
  DONOT_FALLBACK. Do not fall back to unprotected distribution points.
• 0x00040000 (18)
  ENABLE_TS_FROM_CD_AND_PXE. The task sequence is available to removable media and the pre-boot execution environment (PXE) service point.
• 0x00100000 (20)
  OVERRIDE_SERVICE_WINDOWS. Override maintenance windows in announcing the advertisement to the user.
• 0x00200000 (21)
  REBOOT_OUTSIDE_OF_SERVICE_WINDOWS. Reboot outside of maintenance windows.
• 0x00400000 (22)
  WAKE_ON_LAN_ENABLED. Announce the advertisement to the user with Wake On LAN enabled.
• 0x00800000 (23)
  SHOW_PROGRESS. Announce the advertisement to the user showing task sequence progress.
• 0x02000000 (25)
  NO_DISPLAY. The user should not run programs independently of the assignment.
• 0x04000000 (26)
  ONSLOWNET. Assignments are mandatory over a slow network connection.

http://msdn.microsoft.com/en-us/library/cc146108.aspx