How can I access Audit records from the perspective of the system (or a workspace), not an individua

I would like to periodically access a subset of Audit records, using the the SOAP interface, in a manner similar to the 'Query Audit Log' function available in the Admin pages of the web interface. This would serve as a mechanism to feed into an external event queue to trigger automation operating against the CWS API.

Looking through the docs I can see the various mechanisms for working with NodeAuditRecord objects in the context of a given Node object, but I'm unclear how (or where) to query for a list of NodeAuditRecord based on specific criteria, as can be done in the admin page.

Given the responsiveness I suspect the Admin page is using a SQL statement directly against the database. Are there any SOAP methods available to me to achieve the same outcome with the same performance? Something in SearchService.svc or XmlService.svc perhaps?

Any guidance would be appreciated.

Find more posts tagged with

Comments

Kyle_Swidrovich

Hi Kris,

You are correct. The Admin page for querying the audit log is just running fairly simplistic SQL directly against the database.

This admin function is not exposed via web services.

However, there is a RunReport method in the DocumentManagement service that will allow you to run a known LiveReport via web services.

You could author a LiveReport that goes against the DAuditNew table (and possibly DAuditMore if necessary) to pull audit information.

With appropriate parameters, you could programmatically call upon this report to pull select audit records.

Cheers,

Kyle

Kris Boutilier

Thanks for the tip Kyle, I'll see what I can do using a LiveReport.