Click here to Skip to main content
15,895,836 members
Articles / Desktop Programming / Windows Forms

NLog Log and Audit Advanced Target

Rate me:
Please Sign up or sign in to vote.
5.00/5 (3 votes)
26 May 2010CPOL6 min read 42.8K   750   35  
A way to audit your business objects using NLog.
SELECT 
	ld.ObjectLogDetailID,
	ld.ObjectLogID,
	ld.OperationID,
	ld.LevelID,
	ld.PropertyName,
	ld.PropertyType,
	ld.PropertyValue,
	l.Name AS ObjectName,
	l.ObjectType AS ObjectType, 
	op.[User],
	op.TimeStamp AS LastModified,
	op.KeyValue,
	lev.Description AS [Level]
FROM {0}ObjectLogDetails ld
LEFT JOIN {0}ObjectLogs l ON l.ObjectLogID = ld.ObjectLogID
LEFT JOIN {0}Operations op ON op.OperaionID = ld.OperationID
LEFT JOIN {0}Levels lev ON lev.LevelID = ld.LevelID
INNER JOIN 
(
	SELECT
		op.KeyValue,
		ol.Name,
		ol.ObjectType,
		ld.PropertyName,
		MAX(op.TimeStamp) AS [TimeStamp]
	from {0}ObjectLogDetails ld
	INNER JOIN {0}Operations op on op.OperaionID = ld.OperationID
	INNER JOIN {0}ObjectLogs ol ON ol.ObjectLogID = ld.ObjectLogID
	GROUP BY 
		op.KeyValue,
		ld.PropertyName,
		ol.Name,
		ol.ObjectType
) tbl1 ON tbl1.PropertyName = ld.PropertyName AND tbl1.TimeStamp = op.TimeStamp

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
Switzerland Switzerland
Senior IT Consultant working in Switzerland as Senior Software Engineer.

Find more at on my blog.

Comments and Discussions