Queries for the AVNMNetworkGroupMembershipChange table

Get recent Network Group Membership changes

List 10 most recent Network Group Membership changes.

//GroupMemberships column would have list of NetworkGroupIds and the respective MembershipDetails(Membership type - Static/Policy and their respective Ids) which NetworkResourceIds are part of.
AVNMNetworkGroupMembershipChange
|top 10 by TimeGenerated desc
|project TimeGenerated, NetworkResourceIds, GroupMemberships, ResultType

Failed Network Group Membership Changes

List failed Network Group Membership changes.

AVNMNetworkGroupMembershipChange
|where ResultType != "Success"
|sort by TimeGenerated desc
|take 100