widsnet.com
4Jul/110

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

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.