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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Get Listtiem Audit Track

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


can any one tell how to get list item audit track in webpart like (how many time list item view by users i want total view count) ??



View Complete Post

More Related Resource Links

Webpart - Get list item audit track in webpart



can any one tell how to get list item audit track in webpart like (how many time list item view by users i want total view count) ??


Track: SharePoint for Developers - Part 1

Are you a developer who wants to learn more about Microsoft Office SharePoint Server (MOSS)? MOSS is based on Microsoft Windows SharePoint Services, which will make it easier for you to get more problems solved with less effort. Windows SharePoint Services 3.0 takes full advantage of Microsoft ASP.NET and the Microsoft .NET runtime. In this course, you will be immersed in the new features and added programmability that is support in MOSS, which will provide you with a wealth of development opportunities.

How to track the changes of user contacts(colleagues) by using SharePoint API

We might have seen colleague tracker web part which keep tracks the changes made in our contacts/colleagues details like profile/lists/sites. The same tracking mechanism can be implemented by using MOSS API in any custom web part/ web control/ feature/web service...

UserProfile.GetColleagueChanges is the method which returns all changes happened with the contacts, this method also accepts a Query (UserProfileChangeQuery) where we can specify different parameters to filter the changes

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

Virus Hunting: Track and Report Server Attacks Quickly and Easily with the .NET Networking Classes


To help stop the spread of worms, viruses, and other hostile activity, it is important to track down and report the servers used in these attacks along with those used to send spam. Many Web administrators, however, don't take the time to track them because the manual process can be quite cumbersome. The Microsoft .NET Framework comes to the rescue with several networking classes, including the Dns class and the TcpClient class, that abstract away the complexity of performing DNS and WHOIS lookups. These classes make it easy to create a simple, straightforward ASP.NET-based utility for performing these lookups and automating this very important task.

G. Andrew Duthie

MSDN Magazine April 2002

.NET CLR Profiling Services: Track Your Managed Components to Boost Application Performance


The Microsoft .NET platform provides you with a rich set of services for building profilers and application monitors for applications targeting the Common Language Runtime (CLR). These services expose runtime events that occur during the execution of a .NET application. They can be used to obtain information about managed code being executed under the runtime. This article describes the .NET CLR Profiling Services and shows how to use the services to build a simple profiler that will provide hot spot information for any .NET application. The sample profiler can easily be modified to suit other profiling and monitoring needs.

Anastasios Kasiolas

MSDN Magazine November 2001

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

Loggin in audit

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.

Track declining information over time

I am having some annoying problems, both based on the same principles. For the first issue, I am trying to track a census.  Basically, I have a list of people at a place, and want to figure out how many came in, and how many left, which will give me a positive or negative number. I want to compare this number to the original count of everyone, and then increase or decrease the amount by that factor. For example"   Starting number of people: 400     People Added: 2  People Subtracted: 10 Net loss or gain: -8  New number: 392.   I want that number that keeps track of everyone to be plotted out by month, in a line graph, so my chart would be something like   400 350        0 300                                0 250                                                 0            August             S

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!

Is there a way to track web traffic for an intranet site?

Hello - I have built my intranet using MS Visual Web Developer Express 2008. There are several secured areas and my manager asked me to find out if tracking the traffic is possible. Things that I would need to track include: Which unique user ID's logged in and when? How many times did the same user login? Last login What info was accessed? What page(s) had the most hits? Would I need a database for tracking purposes? Would this info be available with a "dashboard" interface? Thanks,Kirsten  
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