.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

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

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :SharePoint

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!

View Complete Post

More Related Resource Links

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

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

Submtting Calendar items with variable date information via InfoPath 2007 form



I've seen several posts regarding submitting to a list using and InfoPath form which I am successfully able to do in limited form. (only passing a basic date value) My environment: MOSS 2007 Enterprise w/SP2, InfoPath 2007, SPD 2007.

I'm basically trying to recreate a calendar form with the same data elements (and some additional ones for a specific business requirement) as the standard calendar newform.aspx form. (start time, end time broken down by date, hour, minute and All day event)

I need the form users to be able to select the date and if it is not an All day event...be able to select the hours and minutes just like on the newform.aspx. (date picker control for date and drop downs for hour and minute selection)

On submit I then need to create the list item with the appropriate data passed via a workflow.

My Start Time has a validation rule to not allow dates prior to the current date (and it can't blank) The End Time has a validation rule to not allow dates prior to what is specified as the Start Time value. (Also can't be blank) When I attempt to include conditonal formatting to hide the hour and minute drop downs if 'All Day Event' is selected I get errors stating the fields can't be blank.

I also can't figure out how to pass the entire date/time values or the All Day Event to the list withou

Cannot properly join lists in SPD 2007


Ok, I have been reading all sorts of posts and such for about a week and still have no come up with any concrete answers.


I cannot properly join lists in SP 07. I say properly because I never get the option to select a field to associate one with the other. 

I select "Create new linked data source" from Data Source Library; Pane opens; Left Click "Configure Linked Data Source"; Add 4 to 5 lists from "Current Site"; Select Next; Select Join option but Next is greyed out. Is this supposed to be greyed out because they are lists? Can lists be joined? I see alot of examples on joining databases and excel pages but not too many on lists.

If I select next from the last point, open the linked sources and select my newly created linked source and click to show data, I can see all of the information in there. Problem is I don't believe the lists are really joined by anything since I never received an option for it. 

I also have been reading up on joined subviews but I never receive an option for  joined subview. Is the joined subview the way to go for lists? If so how?


I know these boards are fairly active and any information or help would be greatly appreciated.

Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Versioning lists in Sharepoint (not list items)

I need to keep a track of what all changes have been made to a custom list since it was first created. I need to have track of what columns were added/removed and when. I know that we have versioning for list items so as to keep track of what all changes have been made to an item but what I am looking for is versioning of the list itself rather than the list items. Is this possible?

How do I get the Sharepoint 2007 KPI to use the "Calculation using all list items in the view"

I have a custom SP list that contains a numeric column in the list and the view selected for the KPI. The option to calculate using all items in the view is grayed out.  Sometimes SP will let me create a KPI like this, then I go back to the webpart and the indicator has reverted back to just a simple count of the number of items in the list.  I want to use the "calculate all items" from a numeric column and have my KPI stay that way? Any thoughts?

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Is there any facility to auto archive List items In Sharepoint 2007 and 2010?

i work for a software company, Recently client gave us a requirement where he need a functionality to archive list items based on its retention period... so i just wanted to know that is there any facility in Sarepoint 2007 or 2010 where we can auto archive list items.Kindly provide some information on this. thank you.

IE9, Site Specific Browsers, and adding your own Jump List Items to Pinned Tabs

Site Specific Browsers aren't a really new idea. In 2005 there was an app called Bubbles I ran for a while that would let you run a website with minimal "browser chrome." Mozilla Prism (né WebRunner) is a Firefox add-in that does a similar thing. Google Chrome includes the idea of Application Shortcuts. The idea of all this is that some web apps are really applications and you think about them as applications. For me, I think of Gmail and Facebook and Twitter and Basecamp as applications not necessarily as browser tabs. The notion of Site-Specific Browsers is definitely arriving. Internet Explorer 9 Beta (IE9) is out now and includes a featured called " Site Pinning " which is a effectively Site Specific Browsers. It's...(read more)

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!

can i access sharepoint 2007 'Document Library' items into WPF directly. or iwant to use any WCF o


please suggest me.

and give the proper coading..

thanks for any help

Setting permissions on specific items


I'm following a Books Online tutorial for setting up permissions.  I'm on to the 3rd and final stage of the tutorial, the part where I set specific permissions for users to a folder or a report.  (Here's the web page: http://msdn.microsoft.com/en-us/library/aa337494.aspx)

I'm confused about these instructions from that page:

To create a role definition for navigating folders

  1. In SQL Server Management Studio, connect to a report server, and then expand the report server node.

  2. Open Security folder.

  3. Right-click Roles and select New Role. The New User Role dialog box appears.

  4. In Name, enter Folder Navigation.

  5. In Task, select View Folders.

  6. Click OK.

Assuming step 1 refers to the ReportServer database, should it be a database role or an application role?  And where do I find "Task"?  There must be several errors in this page.  Could somebody please clarify these instructio

add new items to sql server using infopath 2007


can someone help me with this adding new items using infopath 2007.

i have create a form based on sql database connection.

i have 2 tables that are related to each other. table A is the user table with the user name and id in it. table B is the vacation days table that has the days that the user went or will go on vacation.

in my form i have set 2 field with the user and the user id and a repeating section with the absence/vacation days in it.

when i go to preview the form and click on the "run query" both the fields and the repeating section are filled correctly. and if i click on insert item to insert a new item it submit fine to the database.

but what i need is that the user must fill a new form. when i click on the "new" button it cleared all the fields. but i dont want it to clear the username and the userid field.

i want the user to open a blank form with only his username and userid already filled in.

i know how to autopapulate those fields. but everytime i try to insert new absence dates. it gives me this error:

Violation of PRIMARY KEY constraint 'PK_USER'. Cannot insert duplicate key in object 'dbo.USER'.

another error i have got once was that i need to insert the 2 keys i have in the tables.

but i dont want that the user fill in the keys

can someone

Dropdown lists - showing items based on value


Hi, i have over 100 items all loaded in a dropdown list. They all are assigned a value between 1-10 which represent 10 categories.

When certain buttons are clicked, i want the dropdown list to display only items with a value "1" or "2", etc.

How can this be done?

Sharepoint 2010 Audit Logs with Report Builder 3.0



I'm trying to create a report using Report builder of a sharepoint 2010 list's custom audit log, is there a way to create a report using report builder 3.0 without directly using sharepoint's Database tables?


MOSS 2007 - Propagate changes to multiple sites and lists

We use MOSS 2007 for doc mngmt and maintain individual sites containing lists and libraries for each of our 90+ projects.  All sites are created from a site template and we wish to keep them all identical.  How should I push out changes and updates as business requirements change?  In other words, if we change/update the template, how can I make all the sites and lists look the same?
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