Dynamics Community Forum Thread Details

Get Report from AuditBase table

Hi there
I have installed CRM 2011 in my local Network.
I wanna develop and get report from auditBase table.
I googled and now I can run this query ( for example ) :

select top 200 * from AuditBase inner join StringMapBase
     on ( AuditBase.Action=StringMapbase.AttributeValue and AuditBase.ObjectTypeCode=1084 and
     StringMapBase.LangId=1065 and (AttributeName='action' or AttributeName='operation'))
     inner join Quote on (AuditBase.ObjectId=quote.QuoteId);

I used the condition AuditBase.ObjectId=quote.QuoteId to display quotes related to the auditBase table.
First of all, my question is that am I doing right? Is the AuditBase.ObjectId=quote.QuoteId true? Is the objectId always the same value just like QuoteId?
And another problem :
I want to do a filter on this.
The objectId is too long and complex to use in the filter box(ex, in a textbox) , I wanna filter every change of any entity by entityId or something simpler.( for example states changed in the quote entity )
Is it possible?

Quick Links