Is it possible to create a dynamic group where the current user of a workstation is a member of the local administrators group?

• 

  Colby Bouma

  June 27, 2022 21:22 (Edited June 27, 2022 21:24)

  Unfortunately, filters cannot compare fields to each other, only static data, Variables, and other collections.

  However, a SQL Report should be able to do that.

  1
• 

  Ryan Mortier

  June 28, 2022 12:42

  I've never messed around with SQL reports until your comment, but this was easy, thanks.

  For anyone who might hit this from Google, here is the query I created:

  SELECT [Computers].[Name],
      [Computers].[CurrentUser],
      [LocalGroupMembers].[GroupName],
      [LocalGroupMembers].[UserDomain],
      [LocalGroupMembers].[UserName]
  FROM [Computers]
  INNER JOIN [LocalGroupMembers] ON [Computers].[ComputerId] = [LocalGroupMembers].[ComputerId]
  WHERE [LocalGroupMembers].[GroupName] = 'Administrators'
      AND [LocalGroupMembers].[UserDomain] || '\' || [LocalGroupMembers].[UserName] = [Computers].[CurrentUser]

   

  2

Please sign in to leave a comment.