Click here to Skip to main content
12,356,455 members (59,053 online)
Click here to Skip to main content

Stats

21.1K views
478 downloads
32 bookmarked
Posted

NLog Log and Audit Advanced Target

, 26 May 2010 CPOL
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)

Share

About the Author

AlexCode
Architect
Switzerland Switzerland
Senior IT Consultant working in Switzerland as Senior Software Engineer.

Find more at on my blog.

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.160621.1 | Last Updated 26 May 2010
Article Copyright 2010 by AlexCode
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid