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
Leave a Comment
  • Please add 2 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 3. Comment: Removed tag "SPS 2010"

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

  • 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
  • Craig Lussier edited Original. Comment: added en-US to tags and title

  • Good one.

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

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

Page 1 of 1 (4 items)