Add AD group membership to patch tuesday audit

[bg]

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.

[FrankSc]

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.