Thursday, May 12, 2011

Sharepoint users who have not viewed documents in a SharePoint document library

        public string[] GetAllSharePointPeople()
        {
            SPSite Site = new SPSite("http://crm-srv:6677/");
            SPUserCollection AllUsers = Site.RootWeb.AllUsers;
            string strUserName = string.Empty;
            foreach (SPUser user in AllUsers)
            {
                if (strUserName == string.Empty)
                {
                    strUserName = user.Name.ToString();
                }
                else
                {
                    strUserName += "/" + user.Name.ToString();
                }
            }
            return strUserName.Split('/');
        }
        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dtTable = new DataTable();
            dtTable.Columns.Add("DocumentName");
            dtTable.Columns.Add("UnViewedPeopleName");
            string[] arrAllUsers = GetAllSharePointPeople().Distinct().ToArray();
            SPSite oSiteCollection = new SPSite("http://crm-srv:6677/");
            SPWebCollection collWebsites = oSiteCollection.AllWebs;
            foreach (SPWeb oWebsite in collWebsites)
            {
                SPListCollection collLists = oWebsite.Lists;
                foreach (SPList oList in collLists)
                {
                    if (oList.BaseType == SPBaseType.DocumentLibrary)
                    {
                        SPDocumentLibrary oDocumentLibrary = (SPDocumentLibrary)oList;
                        if (oList.BaseTemplate == SPListTemplateType.DocumentLibrary)
                        {
                            SPListItemCollection collListItems = oDocumentLibrary.Items;
                            string viewedUserName = string.Empty;
                            foreach (SPListItem oListItem in collListItems)
                            {
                                if (oList.Title != "Site Collection Images" &&
                                    oList.Title != "Images" &&
                                    oList.Title != "Style Library" &&
                                    oList.Title != "Reporting Templates" &&
                                    oList.Title != "Application Pages")
                                {
                                    string strWebSiteName = oWebsite.Name;
                                    string strListTitle = oList.Title;
                                    string strListItemName = oListItem.Name;
                                    SPAuditQuery wssQuery;
                                    SPAuditEntryCollection auditCol;
                                    wssQuery = new SPAuditQuery(oSiteCollection);
                                    wssQuery.RestrictToListItem(oListItem);
                                    auditCol = oWebsite.Audit.GetEntries(wssQuery);
                                    foreach (SPAuditEntry oAuditEntry in auditCol)
                                    {
                                        if (oAuditEntry.Event.ToString()  == "View")
                                        {
                                            string[] strArray = oAuditEntry.DocLocation.ToString().Split('/');
                                            if (strArray[strArray.Length - 1] == strListItemName)
                                            {
                                                if (viewedUserName == string.Empty)
                                                {
                                                    viewedUserName = oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
                                                }
                                                else
                                                {
                                                    viewedUserName += "/" + oWebsite.AllUsers.GetByID(Convert.ToInt32(oAuditEntry.UserId)).Name;
                                                }
                                                strListItemName = string.Empty;
                                            }
                                        }
                                       
                                    }
                                }
                                string[] arrViewedUsers=viewedUserName.Split('/');
                                string[] arrNotViewUsers = arrAllUsers.Except(arrViewedUsers).ToArray();
                                foreach (string arr in arrNotViewUsers)
                                {
                                    DataRow dr = dtTable.NewRow();
                                    dr["DocumentName"]=oListItem.Name;
                                    dr["UnViewedPeopleName"] = arr;
                                    dtTable.Rows.Add(dr);
                                }
                                viewedUserName = string.Empty;
                            }
                        }
                    }
                }
                oWebsite.Dispose();
            }
            DataTable dt = dtTable;
        }

No comments:

101% shares

101% shares
about me