The Baretta

Had a problem where external users (people outside our organisation who had been provided with an anonymous link to OneDrive/SharePoint Documents) were showing up in SharePoint's People Search Results. This article explains how to fix:  https://englando.wordpress.com/2015/07/24/hiding-users-from-office-365-sharepoint-global-search-results/ Basically you need to add a Query Rule to SharePoint's 'Local People Results' Search Query to block out results that contain the external users. I personally filtered out all results where a persons Username contained ' #EXT#' , which is what gets appended in Office 365 whenever an external user is given access to a document.

If you need to export a list of staff from an Active Directory Group, follow these steps.  Allows you to gather all the names & usernames of staff in a particular group and save the information into Excel. Step By Step How To: Open up Excel > Power Query Tab Click From Other Sources > From Active Directory: (In Excel 2016 this is found under: Data Tab > New Query > From Other Sources > From Active Directory) screenshots from Excel 2016 on left, Excel 2010 w/ Power Query Add-on right A popup will ask you to enter your domain name.  It should already be populated with the correct information but if not, input your companies domain name & Click OK: In the Navigator that opens up, expand your domain tree and double click group: You should now see a list of all groups in Active Directory in the Power Query Editor: In order to find & filter for a specific Group, Click the Down-Arrow for the 'distinguishedName' column > ...

Today we will be learning how to create a excel report connected to a SharePoint library using Power Query.  I will also address all issues found along the way. The reason we are connecting to our library via Power Query instead of via the 'Export to Excel' option is because our library contains InfoPath forms that have repeating table data in the columns that we need to report on. Power Query   Is a free excel add-in available from Microsoft for both Excel 2010 Professional Plus & Excel 2013.  It is used when you need a way to transform data that isn't quite in the format you need. Step 1: Connecting to your SharePoint Library via Power Query. Open up Excel.  Click Power Query Tab > From Other Sources > From SharePoint List > Insert SharePoint Site URL Here's our first issue.  Only Lists are appearing in the Navigator.  Not to worry, Right-Click any of the Lists showing and click Edit to open up the Query Editor.   You should ...

Wow that's a long heading...  Let me explain how this is done, and why this path was chosen out of all the options. THE OPTIONS Still to come... SETTING UP There's quite a few large steps to get this done, so I'll split it into the following sections, ensuring we test along the way to make sure we haven't missed a step: Install & Configure Oracle Client on Web Server Create custom Web Service in Visual Studio Deploy Web Service to IIS Build InfoPath Form Configure InfoPath Services Deploy InfoPath Form to SharePoint Environment Install & Configure Oracle Client on Web Server Ask your Oracle DBA what version of Oracle the database is running on. Navigate here and download the corresponding Client (for this excercise get the 32-bit version if its an option):  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Copy to the IIS Server (Web Front End) Extract and install, here's the settings I used for the i...

Had to look at a few different KB articles for this one so thought I'd throw all the steps together in one quick blog. First you need to create a login, to do this, connect to the master database and run the following query: CREATE LOGIN login1 WITH password='SuperSecretPassword'; Then connect to the Database you wish to give access to, you need to create the user, then supply the access.  Run the following scripts: CREATE USER login1User FROM LOGIN login1; EXEC sp_addrolemember 'db_owner', 'login1User';

If you're like me and needed to have quite a few tiles in your Promoted Links Web Part, this should come in handy. I've seen options to install custom solutions, and i've seen options to add a javascript file to the web part to force it to go to a new line. Custom solutions?  meh. Seperate 76kb javascript file?  meh. Use what you've been given my friends; and make it simple for your siblings to see how it works. It's not entirely a simple solution, but when completed I think it is the most elegant/clean solution.  Create two Promoted Links Web Parts underneath each other and use two separate Tile Views to display everything you need.  The only way I could find to create another Tile view was to use SharePoint Designer. Navigate to list in SharePoint Designer 2013 Create new view Copy CAML Query from original Tile View to new Tile view.  Copy This Bit (Make sure you keep the old view name, display name, url): <XmlDefinition><View Name=...