cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bg
Engaged Sweeper

Hello!

I am trying to add a field to the patch tuesday audit for AD Group Membership, and not succeeding.

Is there a way to add this field? We have servers in patching groups kept in AD Security Groups.

I'd like to be able to filter or query the audit based on a servers membership in a specific AD group.

 

1 REPLY 1
FrankSc
Lansweeper Tech Support
Lansweeper Tech Support

Dear bg, 
This requires a bit of a specific approach. 

The database documentation may be useful to identify where data is stored on how it is linked to each other. 

 

Adding an extra join to tblcplogoninfo, will bring you the username in the report and then you can join on the username to the AD tables. 
The built-in report "Users: AD users and their AD groups" can be then used as an example to join further on the AD membership and Groups.