Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version
Go to top

NLog Log and Audit Advanced Target

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

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.

| Advertise | Privacy | Mobile
Web02 | 2.8.140905.1 | Last Updated 26 May 2010
Article Copyright 2010 by AlexCode
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid