View Complete Post
In my MySql Table I need to keep track of all the changes, especially create,update, and delete changes each record. I need to keep track of who didwhat changes.
This is MySQL Create table Query
create table quotes(QuoteNumber int(15) ,Revision timestamp,Vendor varchar(45),PartNumber varchar(60),Status varchar(20),Customer varchar(45),Requestor varchar(20),X varchar(20),Xin varchar(10),Y varchar(20),Yin varchar(10),Layers Varchar(20),BlindVia varchar(20),Impedence varchar(20))
How can i implement the Audit trail to above table.Please help me,Thanks.
This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.
MSDN Magazine May 2008
In today's security-conscious environments, a reliable audit trail is a valuable forensic tool The Windows Server 2003 operating system provides features that let you enable a wide range of applications to make use of auditing functionality. This article looks at auditing from the operating system perspective and describes a sample managed code implementation that will allow you to add auditing to your own server applications.
MSDN Magazine October 2005
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.
MSDN Magazine April 2004
We don't have our site collection audit settings enabled. http://nickgrattan.wordpress.com/2007/11/27/auditing-permission-changes/
Is there another way we can trace to see who modified the permissions on the site such as in the Database, etc?
Thanks in advance....
I have merge replication configured on sql server 2008. My question is can i create DB audit(which is available from 2008) on merge replicated db. creating db audit causes any issues in replication?
I'm far from being an expert in SP, so please would you treat me like you're responding to your granny ;-) I'm a basic user, who has set up a team site (one of thousands) within a coropration.
I've created a 'list' to use to post briefings. I now want to track who has clicked on the briefing to read it, and when they did that. I've tried creating a custom audit log, and that tells me they visited the list, and that they clicked
into an item, just not which specific item in the list.
The 'document location' tells me the visited 'sites/Trainingdelivery/Lists/General message/DispForm.aspx' but the URL to a specific item looks like this 'sites/Trainingdelivery/Lists/General%20message/DispForm.aspx?ID=207'.
How do I capture the specific ID?
Or, is there a way to add something into my list to get users to click to say they've read the message? my problems with this so far, is I target messages at groups, not individuals, so each item in the list could not be edited to say read, as they
would update it for everyone in the group, not just the individual.
Thanks in advance for your help!
A customer is experiencing the following weird events with SharePoint 2007 Audit:
When a user uploads a Microsoft Office file to a document library the dbo.AuditData table registers a View entry minutes later, even when no one accessed the file.
When a user opens a Microsoft Office file in a document library the dbo.AuditData table registers another View entry minutes later, even when the file was only opened once.