Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 11 Dec 2011 7:12 AM
  • Last revision by (cMVP, Microsoft Community Contributo)
  • When: 19 Sep 2013 5:29 PM
  • Revisions: 5
  • Comments: 4
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: How to Find the User Who Deployed or Updated a Solution

SharePoint 2010: How to Find the User Who Deployed or Updated a Solution

SharePoint 2010: How to Find the User Who Deployed or Updated a Solution


I have observed a very growing requirement is to find out which user has deployed a solution or updated in sharepoint. This is of high importance when there are many administrators assigned to do such activities in sharepoint farm. So upon some research I found a way that is very useful in this regard.
In this article I am defining the steps based on a feature definition and a wsp file. Here are the steps needs to be followed:
  1. Login to the database.
  2. Go to the config database and select new query.
  3. Now we will find out the information about a solution solution1.wsp so we will execute this query:
  4. Select * From Objects With(NoLock)where Name = 'solution1.wsp'
  5. In the result returned our focus will be on the column "Properties" .
  6. Copy the contents and paste it somewhere in notepad. There are many properties exposed through this however we will focus on these 3:

<sFld type="String" name="m_LastUpdatedUser">
<sFld type="String" name="m_LastUpdatedMachine">
<sFld type="DateTime" name="m_LastUpdatedTime">

  1. As their names are already clear the first one shows the user name who has last updated it.The second one is the server where it was last updated. The third one shows the time when it was last updated. The last two information is available through UI as well.

In case of feature definitions we need to know the guid of the same. So this can be taken from the feature.xml file under the features folder. Then the following query can be executed:

Select * From Objects With(NoLock) where ID='Guid'


The output and next steps can be followed in the same way.
This works in both MOSS 2007 and SPS 2010
, , , , , , [Edit tags]
Leave a Comment
  • Please add 3 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 23 Jun 2013 2:32 PM

    Richard Mueller edited Revision 1. Comment: Removed (en-US) from title, modified title, added tag

  • 19 Sep 2013 5:29 PM

    Richard Mueller edited Revision 3. Comment: Removed tag "SPS 2010"

  • 18 Feb 2012 5:27 PM

    Craig Lussier edited Original. Comment: added en-US to tags and title

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 23 Jun 2013 2:32 PM

    Richard Mueller edited Revision 1. Comment: Removed (en-US) from title, modified title, added tag

  • Posted by
    on 19 Sep 2013 5:29 PM

    Richard Mueller edited Revision 3. Comment: Removed tag "SPS 2010"

  • Posted by
    on 18 Feb 2012 5:27 PM

    Craig Lussier edited Original. Comment: added en-US to tags and title

  • Posted by
    on 4 May 2012 5:40 AM

    Good one.

Page 1 of 1 (4 items)