SharePoint 2007: Showing recently added people in the SharePoint Group

Question

We have developed a job that syncs information from Active Directory group onto SharePoint groups.
The job runs everyday and pulls new users added onto Active directory group,

I wanted to know if there is way I can show recently added people from SharePoint Group. Sharepoint group does not allows to create views.

Any thoughts/ideas?

Thanks in advance

Answer 1

SharePoint does not automatically record the time and date a user was added to a SharePoint group. As you can see the SPGroup does not have a "LastModified" date or something like that - the SPUser does neither for that matter.

You have two options to get the recently added users to a SharePoint group:

1. You can use SPAudit to generate an event when a user is added to a group, like so (as explained here):

   using (SPSite site = new SPSite("url"){
   
           SPAuditQuery auditQuery;
           SPAuditEntryCollection auditCol;
   
           auditQuery = new SPAuditQuery(site);
           auditQuery.AddEventRestriction(SPAuditEventType.SecGroupMemberAdd);
   
            // SecGroupMemberAdd: Addition of a new member to a group that is associated with a SharePoint site collection
           //Also some Enum type for group:
           //SecGroupCreate/SecGroupDelete/SecGroupMemberAdd/SecGroupMemberDel
   
           auditCol = site.Audit.GetEntries(auditQuery);
   
           foreach (SPAuditEntry entry in auditCol)
           {
                //Execute send mail action here
           }
       }
   

2. Check the SharePoint database. This is not recommended by Microsoft, but it certainly doesn't hurt to take a peek. The database contains the usual columns like LastModified and CreatedOn so you check which users where added when.