which policy will it take to trigger the alerts??

[MPalagiri]

Hi Friends,

We have a policy called "Azure SQL Server audit log retention is less than 91 days" with several alerts triggered for this.Now we have cloned the same policy with modified query inside the policy as 90 days.Here my doubt is what will happen to the open alerts with respect to the old policy??which criteria it will match in future for the further alerts?Either cloned policy or normal one??

Also please let me know the frequency of each scan it will take place on resources by policies/metaconfig collector to check for the criteria to match?

Please some experts reply on this.Awaiting some kind responses.

Thanks in advance.

Mahesh.

[ebeuerlein · Accepted solution]

I would recommend disabling the policy for 91 days and only have the custom policy enabled.  Also, make sure this policy is added to any alert rules since alert rules are what causes policies to alert.  In regards to frequency of scans, it is usually between 15 and 45 mins per scan.

[MPalagiri]

Hi Edward,

Appreciated your kind response for the query.Regarding scan frequency i wanted to know Cycle of the scan ex:-for every half n our it will take or for every 45 minutes?

[ebeuerlein · Accepted solution]

Once the scan is completed, the config scan kicks off that actually generates the alerts.  Once that is finished, another ingestion cycle kicks off.  So you data will be pulled in about once an hour.

Thanks,

Eddie

[MPalagiri]

Thank you kindly for your prompt response