.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Loggin in audit

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
Is there any audit of users actions in sharepoint. I want to see who, when and from what computer were logged in to the portal.

View Complete Post

More Related Resource Links

Audit Trail


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 did
what 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.

Toolbox: Database Audit Logs, Joel on Software, Code Handouts, and More


This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.

Scott Mitchell

MSDN Magazine May 2008

Stay Alert: Use Managed Code To Generate A Secure Audit Trail


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.

Mark Novak

MSDN Magazine October 2005

Data Points: Creating Audit Tables, Invoking COM Objects, and More


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.

John Papa

MSDN Magazine April 2004

Implementation of Audit Fields and optimistic concurrency

What is the best way to implement Optimistic concurrency? Also, I have 4 audit columns in every table in my database. They are created date, updated date, created by, updated by. Application should populate these fields. I want to know how to populate created date , and updated date? From where application datetime or database datetime? On save button click, if I have to save data into 4 different tables, then I need to have same datetime in all 4 audit fields correct? What is the best way to implement this? What will be the design? Please let me know.  

Generic Audit Trigger CLR C#(Works when the trigger is attached to any Table)

This Audit Trigger is Generic (i.e. non-"Table Specific") attach it to any tabel and it should work.  Be sure and create the 'Audit' table first though. The following code write audit entries to a Table called'Audit' with columns 'ActionType'    //varchar'TableName'    //varchar'PK'    //varchar'FieldName'    //varchar'OldValue'    //varchar'NewValue'    //varchar'ChangeDateTime'    //datetime'ChangeBy'    //varchar using System;using System.Data;using System.Data.SqlClient;using Microsoft.SqlServer.Server; public partial class Triggers{//A Generic Trigger for Insert, Update and Delete Actions on any Table[Microsoft.SqlServer.Server.SqlTrigger(Name = "AuditTrigger", Event = "FOR INSERT, UPDATE, DELETE")] public static void AuditTrigger(){SqlTriggerContext tcontext = SqlContext.TriggerContext; //Trigger Contextstring TName; //Where we store the Altered Table's Namestring User; //Where we will store the Database UsernameDataRow iRow; //DataRow to hold the inserted valuesDataRow dRow; //DataRow to how the deleted/overwritten valuesDataRow aRow; //Audit DataRow to build our Audit entry withstring PKString; //Will temporarily store the Primary Key Column Names and Values hereusing (SqlConnection conn = new SqlConnection("context connection=true"))//Our Connection{conn.Open();//Open the Connection//Build the AuditAdapter an

SQL Audit: What operations are captured within DATABASE_OBJECT_ACCESS_GROUP?

What operations are captured in DATABASE_OBJECT_ACCESS_GROUP? I expected create/drop certificate/symmetric key is captured. But nothing is captured after I followed these steps: CREATE DATABASE DB1, Configure and enable Server and Database Audit Specs which includes (only) DATABASE_OBJECT_ACCESS_GROUP (in both Specs). Then execute the following T-SQL Script.   USE DB1 GO CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'P@ssw0rd!' GO CREATE CERTIFICATE MyDBCert WITH SUBJECT = 'My Database Certificate' GO CREATE SYMMETRIC KEY MySymKey WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE MyDBCert GO CREATE TABLE T1 (ID nvarchar(3), C1 nvarchar(50)) GO -------------------------------------------------------------- OPEN SYMMETRIC KEY MySymKey DECRYPTION BY CERTIFICATE MyDBCert DECLARE @I INT SET @I = 100 WHILE @I <> 0 BEGIN INSERT INTO T1(ID) VALUES(@I) SET @I = @I -1 END GO -------------------------------------------------------------- UPDATE T1 SET C1 = EncryptByKey(Key_GUID('MySymKey'),ID) OPEN SYMMETRIC KEY MySymKey DECRYPTION BY CERTIFICATE MyDBCert SELECT ID, C1, CONVERT(nvarchar, DECRYPTBYKEY(C1)) FROM T1 GO -------------------------------------------------------------- DROP TABLE T1 GO DROP SYMMETRIC KEY MySymKey GO DROP CERTIFICATE MyDBCert GO DROP MASTER KEY GO

How list all of the Actions in an MVC application for security audit?

Hi, We are developing a big MVC application and the numbers of published end-points (Controller Actions) -audit properly assigned authorization attributes - are getting out of hand. In WinForms, each aspx file is the end-point, so I can easily audit files and folders. Things in MVC are different.  I am looking for a tool based on reflection that searches actions in all controllers available in the solution and give me a list with assigned [Authorize] attribute. Is such tool or technique available? If such tool is not available, how can I audit the security attack surface of an MVC application? A new developer can easily add an action to a controller class (we have many controllers, can't inspect them manually) and the action become available to public. Thank you, Max

A way to monitor or audit what emails SharePoint sends

Hello, I am looking for a way to track what emails my SharePoint site sends out.  I am currently using workflows for an approval process and would like a way to check to make sure the correct emails have been sent without having to hound down each individual user and confirm through them.  Is there any way to do something like this? Thank you!

Generic Implementation of Audit Trail

I want to create a generic audit trail of my database in which I can store new/old values of fields. Now problem is that in most of the samples they create triggers which are specific to table and column. How can I implement a generic audit trail in Oracle.What I mean by generic is that there might be some SP and tables which I can add to any Oracle Database and system will start logging tables. I wont mind if I have to define triggers on every table for insert/delete/update but Code in all triggers should be same and not specific to that table. Can anyone help me out. Thanks in advance to all who will help me

Can't find audit log

Hello,i've created Group Work site in Sharepoint 2010, and enabled auditing policy for some document libraries. Problem is, I just can't seem to find where to find this log.Is it logged to trace log, or..?

audit permission changes



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....


Time displays in audit logs as GMT

I just played around with setting up SQL Server auditing in 2008 and noticed that the time displays in the audit logs show up as GMT rather than UTC. I'm in CST timezone. I'm wondering if there is a way to change the time in the audit logs to match the OS system time? Thanks!

SQL Server audit question

I've set up a SQL server audit to capture select statements against a table in my database.   That's working great with no problems my question is when I view the selected row details of my audit entry in the audit log I see the statement has been parameterized.  Here's an example of what I mean, in a query window I execute: 

select * from table where name = 'Smith'.  

The audit entry displays the statement as 

select * from table where name = @0
  My question is whether or not there is a way we can capture the where conditions in the audit event.

DB audit on merge replicated DB



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?


Audit logs on 2007 - specific items that have been viewed in lists


Hi all

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!

Weird SharePoint Audit Entries


Hi Everyone,

A customer is experiencing the following weird events with SharePoint 2007 Audit:

1.       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.

2.       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.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend