List of user with X

Select distinct
    TopConsoleUser0
from
    dbo.v_Add_Remove_Programs ARP
    Join dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on ARP.ResourceId = SCUM.ResourceID
Where
    ARP.DisplayName0 = ‘Update for Windows Server 2003 (KB923845)’

Digg This

Leave a Reply

Your email address will not be published. Required fields are marked *