Queries for the AVNMNetworkGroupMembershipChange table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
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