Wednesday, 30 November 2011

Query for All Local Administrators account on Workstations

SELECT     dbo.v_R_System.Name0, dbo.v_GS_SMXLOCALADMINSMIF.Account0, dbo.v_R_System.Operating_System_Name_and0
FROM         dbo.v_R_System INNER JOIN
                      dbo.v_GS_SMXLOCALADMINSMIF ON dbo.v_R_System.ResourceID = dbo.v_GS_SMXLOCALADMINSMIF.ResourceID
WHERE     (dbo.v_R_System.Operating_System_Name_and0 LIKE '%workstation%')
Posted by at

1 comment:

  1. oxy6en26 February 2014 at 19:21

    Hi, when I copied and pasted your query to my SCCM DB, I've got this error " Msg 208, Level 16, State 1, Line 1
    Invalid object name 'dbo.v_R_System'."

    Any help will be appreciated

    ReplyDelete

Subscribe to: Post Comments (Atom)