Audit Log Management screen shows dates incorrectly and is also missing logs

(0) Share

Report

Posted on by G.Vetere

The Audit Log Management screen is showing the dates wrong, there are also logs missing in the CRM view

Anyone know how to fix it? Thanks!

I used the following query in SQL:

IF (CONVERT(int, (SELECT SERVERPROPERTY('EngineEdition'))) = 3) 
        BEGIN 
                SELECT  partition_number AS 'PartitionNumber' 
                                , prv.value AS 'End Date' 
                                , used_page_count*8 AS 'Size in KB' 
                FROM sys.dm_db_partition_stats pst LEFT OUTER JOIN sys.partition_range_values prv ON prv.boundary_id = pst.partition_number 
                WHERE object_id = object_id('AuditBase') 
                AND index_id in (0,1) 
        END 
ELSE 
        BEGIN 
                SELECT  DATENAME(qq, CreatedOn) AS 'Quarter' 
                                , YEAR(CreatedOn) AS 'Year' 
                                , COUNT(*) AS 'Rows' 
                FROM AuditBase 
                GROUP BY DATENAME(qq, CreatedOn), YEAR(CreatedOn) 
                ORDER BY 'Year','Quarter' 
        END

View from CRM:

view from SQL:

All responses (2)

Answers (0)

G.Vetere on at

Like (0)

Report

RE: Audit Log Management screen shows dates incorrectly and is also missing logs

Hi Gustavo

We are using Enterprise version

What do those queries do?

We are running CRM 2015 RTM version
Gustavo Longo on at

Like (0)

Report

RE: Audit Log Management screen shows dates incorrectly and is also missing logs

Hello G.Vetere,

I hope you are well and safe.

Basically we need pay attention about the SQL version, only version that supports partition is Enterprise.

If your SQL server is Enterprise, you can use these queries:

select * from sys.partition_functions

select * from sys.partition_parameters

select * from sys.partition_range_values

Based on the print-screen (CRM vision), apparently the rendering is not so good indeed.

Confirm if you are using the latest update package for CRM and eventually raise a ticket with Microsoft support for further investigation.

Regards,