• Our Office
  • 12 Alpine Close Lakefield Benoni 1501

SPContext.Current.Web.CurrentUser.LoginName

We had an issue where the SPContext.Current.Web.CurrentUser.LoginName displayed the incorrect (old) login for a user i.e. user loginname was changed. In most cases it works to run the migrateuser command to link the old and new account. But in some cases this does not pull through correctly. The following solution worked [...]

Read More

Search Crawl error: Value does not fall within the expected range

Been facing an issue where the Search Service is not crawling a simple site collection in our SharePoint farm. Had a scratch through the crawl logs and found the following error: sts4://myintranetsite/siteurl=sites/finance/siteid={42461088-3f26-4c2d-937e-c630c7033307} The SharePoint item being crawled returned an error when requesting data from the web service. (The item was [...]

Read More

SharePoint SQL Queries

Some useful SQL queries to get web, site and list data: 1) Query to get all the top level site collections SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated FROM dbo.Webs WHERE (ParentWebId IS NULL) 2) Query to get all the child sites in a [...]

Read More