Why are some SQL Server reports showing no data?
Case 1: Are the required audit policies configured?
Open SQL Server Management Studio application in the Windows machine in which SQL Server is installed, and connect to the required instance.
Click the Security option.
The Server Audit Specifications section should have an audit specification with a name starting with ME_LOG360.
Double-click the audit specification. The Audit Action Type table should contain the required policies for the corresponding reports. Refer to the Required Server-level Audit Action Types column of the table from this link: What are the audit policies required to generate events for an SQL Server report?
Case 2: Are the required events logged to the Event Viewer?
In the target Windows machine on which SQL Server is installed, open the Event Viewer > Application.
Search for events with EVENTID=33205 that also match the given report's criteria. Refer to the Criteria column of the table from this link: What are the audit policies required to generate events for an SQL Server report?
Case 3: Is the Event Viewer holding events for more than the monitoring interval (default: 10 minutes)?
Are events in the Event Viewer getting overwritten with new events before EventLog Analyzer can collect them? Ensure that the time difference between the first and the last log of the Event Viewer is greater than the monitor interval. If not, increase the size of the Application category.
Case 4: Are any Log Collection Filter profiles in EventLog Analyzer filtering out the logs?
In EventLog Analyzer, go to Settings > Admin Settings > Log Collection Filters, ensure that no filter profiles are configured to drop the expected logs.
New to ADSelfService Plus?
Related Articles
What are the audit policies required to generate events for an SQL Server report?
Existing Reports vs SQL Server Policies S. no. Report Group Total Reports Report Name Criteria Required Server-level Audit Action Types 1 SQL Server Events 2 All Events - - Important Events - - 2 SQLServer Trend Report 2 Read Event Trend ...Time delay in exporting reports
One of the main reasons for delay in report exports is the large volume of report entries. To reduce the report export time, we recommend you generate and export only the information needed. Select the exact time period and columns that are required ...Scheduled reports are not getting delivered
There could be many reasons why the scheduled reports were not delivered to the specified email ID. The most common reasons include improper configuration of the mail server, generation of empty reports with settings that specify not to deliver empty ...Why are SQL Server audit logs not collected?
Case 1: Is Advanced Auditing enabled? Open EventLog Analyzer and go to Settings > Database Audit > SQL Servers. The DDL/DML Monitoring column should show Manage for the required instance. If it says Not configured, then edit the required instance, ...How to collect the users Enabled/Disabled SQL logs?
The Enable/Disable logs will be recorded in the Event Viewer in the following scenarios: In SQL Server Management Studio, Security ⇾ Logins ⇾ Right-click on any user ⇾ Properties ⇾ Status ⇾ Login section ⇾ select Disabled/Enabled. By executing the ...