SharePoint 2016: How to Provision Project Web App

  Well its been almost a month when SharePoint 2016 preview was released. The content of the blog may or may NOT be relevant when RTM is released. I installed it on a HyperV VM with all in one servers. Project Server has been a separate installer prior to this version. As a surprise and…

2

SharePoint 2013: Get all Access app instances with DB Name

  SharePoint 2013 Access Services are not new to anyone. However, once we enable the Access Services, there is no way to govern the Service. At the least, I wanted to see a report of all the Access app instances in a Web Application and what database is associated with the app. I tried to…

0

SharePoint 2013 Hybrid Search: Create result Source & Query Rule – Automation

  I know the topic starts with Hybrid Search for SharePoint 2013. But this blog is not about configuring end-to-end Hybrid Search. The Parent blog is http://blogs.msdn.com/b/spses/archive/2013/10/22/office-365-configure-hybrid-search-with-directory-synchronization.aspx   I was in process of automating the whole Hybrid process (most of the steps atleast from SharePoint using PowerShell). The blog by Manas has most of the…

1

PowerShell ISE: Make ISE ready for SharePoint cmdlets

  As SharePoint administrators and developers we do use Windows PowerShell cmdlets for creating SharePoint scripts. PowerShell ISE is very powerful tool for scripting. However, we need to load the SharePoint snap-in everytime we load ISE to work with SharePoint cmdlets. I know it’s not a big deal for most people, but for folks like…

0

Fix: Document Sets Shared Column not inheriting metadata

  I am writing this blog to address the issue with the Document Set items not inheriting the metadata value defined for the Document Set. Problem: You have created a Document Set in a library, you have set the metadata for the Document Set and you add new files to the Document Set. You expect…

3

How to: Use ListData.svc as a External Content Type through BCS

I came up with this nice scenario where a user wanted to import the ListData.svc from SharePoint as an External Content Type in SharePoint. The requirement was to use a List as an External List in a different site collection. The first thought that will cross the mind is that you can use SharePoint Designer…

1

SharePoint Online: Pass Credentials to Web Service passively

  SharePoint Online or Office 365 relies on Claims authentication. This makes things a little challenging when you are trying to work with the Web Services exposed by SPO. When I was trying to consume web Services with Default Credentials passed, it started throwing me Access Denied (401). After little research I was able to…

8

SharePoint 2010 PowerShell or PowerShell ISE throwing – “The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.” when loading SharePoint PowerShell module

  Recently I started facing this issue. Whenever, I load the PowerShell ISE and Type the command to load the SharePoint PowerShell module, it starts throwing error “The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.” The same error comes up in the SharePoint Management Shell. The reason could be you installed…

5

Getting Data from Large External Lists

    Recently I was working on a requirement on how to find items using an identifier in External Lists which are very large. It’s similar to selecting a record in a table with a where clause. If you want to know how to create an External List you can follow http://msdn.microsoft.com/en-us/library/ee557243(v=office.14).aspx Once the list…

10

SharePoint–How To: Delete Versions of documents in a Document Library, keeping Top N Versions

  I have this requirement coming to me multiple times where people enable versioning on the Document Library, but never keep an upper limit of number of versions to be retained. This results in an unmanageable number of versions created for the document in the SharePoint library. If the number is too high, deleting all…

1