The built-in report “Local Groups with Members” contains all of the necessary data, but it also contains too much data. This report will be scheduled and sent to a folder in CSV format, which includes all of the RAW data in the CSV.

The columns that are included in the RAW CSV format are as follows:

Computer Name (Computer)

Account Name (Group)

Account Name (Group Member)

Account ID (Group Member)

Type of Account (Group Member)

RootAccountID

RootAccount

NestedGroup

MemberAccountID

MemberName

MembershipPath

Depth

ParentPath

Account Name (Nested Member)

The only required columns are as follows:

Computer Name (Computer)

Account Name (Group)

Account Name (Group Member)

MembershipPath

Type of Account (Group Member)