Click the Azure Resource Graph tab to view the query
//AzureResourceGraphQuery//FindallNetworkSecurityGroupswithoutalertsformodificationconfigured.resources|wheretype=~"Microsoft.Network/networkSecurityGroups"|projectname,id,tags,lowerCaseNsgId=tolower(id)|joinkind=leftouter(resources|wheretype=~"Microsoft.Insights/activityLogAlerts"andproperties.enabled==true|mv-expandscope=properties.scopes|wherescopehas"Microsoft.Network/networkSecurityGroups"|projectalertName=name,conditionJson=dynamic_to_json(properties.condition.allOf),scope|whereconditionJsonhas'"Administrative"'and(//CreateorUpdateNetworkSecurityGroup(conditionJsonhas'"Microsoft.Network/networkSecurityGroups/write"')or//Alladministrativeoperations(conditionJson!has'"Microsoft.Network/networkSecurityGroups/write"'andconditionJson!has'"Microsoft.Network/networkSecurityGroups/delete"'andconditionJson!has'"Microsoft.Network/networkSecurityGroups/join/action"'))|projectlowerCaseNsgIdOfScope=tolower(scope))on$left.lowerCaseNsgId==$right.lowerCaseNsgIdOfScope|whereisempty(lowerCaseNsgIdOfScope)|projectrecommendationId="8bb4a57b-55e4-d24e-9c19-2679d8bc779f",name,id,tags,param1="ModificationAlert: Not configured/Disabled"
Click the Azure Resource Graph tab to view the query
//AzureResourceGraphQuery//FindallNetworkSecurityGroupswithoutNSGFlowlogsconfiguredordisabled.resources|wheretype=~"Microsoft.Network/networkSecurityGroups"|projectname,id,tags,lowerCaseNsgId=tolower(id)|joinkind=leftouter(resources|wheretype=="microsoft.network/networkwatchers/flowlogs"andproperties.enabled==true|projectflowLogName=name,lowerCaseTargetNsgId=tolower(properties.targetResourceId))on$left.lowerCaseNsgId==$right.lowerCaseTargetNsgId|whereisempty(lowerCaseTargetNsgId)|projectrecommendationId="da1a3c06-d1d5-a940-9a99-fcc05966fe7c",name,id,tags,param1="NSGFlowLog: Not configured/Disabled"