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