PDQ Inventory - creating a filter

Comments

6 comments

  • Colby Bouma

    Are you OK with using the Current User field, or do you want to do an AD lookup?

    0
    Comment actions Permalink
  • Bailey, Matthew S

    I was going to use the Local User field, that way regardless of if the machine is logged on, you can still pull that user. 

    0
    Comment actions Permalink
  • Colby Bouma

    Where is the Local User field? I can't find it in PDQ or AD. Is that a Custom Field that you created?

    0
    Comment actions Permalink
  • Colby Bouma

    Oops, I'm blind. Disregard my previous comment :)

    0
    Comment actions Permalink
  • Bailey, Matthew S

    So how would you suggest I build that query in my original question?

    0
    Comment actions Permalink
  • Colby Bouma

    I think this SQL Report will do what you are asking for, but I'm not sure.

    select
    Computers.Name as "Computer Name",
    LocalGroupMembers.UserName as "User Name",
    LocalGroupMembers.GroupName as "Group Name"
    from Computers inner join
    LocalGroupMembers on LocalGroupMembers.ComputerId = Computers.ComputerId
    where
    LocalGroupMembers.UserName LIKE Computers.Name
    and
    <ComputerFilter>
    0
    Comment actions Permalink

Please sign in to leave a comment.