Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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)
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)
SELECT DATENAME(qq, CreatedOn) AS 'Quarter'
, YEAR(CreatedOn) AS 'Year'
, COUNT(*) AS 'Rows'
GROUP BY DATENAME(qq, CreatedOn), YEAR(CreatedOn)
ORDER BY 'Year','Quarter'
View from CRM:
view from SQL:
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.
We are using Enterprise version
What do those queries do?
We are running CRM 2015 RTM version
Business Applications communities