The Baretta

What Nintex Workflow for O365 has an action to create a site automatically in SharePoint, but it's functionality is quite limited.  You can't create groups and you can't add staff to those groups.  This tutorial shows you how to create a Nintex workflow to automate the whole process using SharePoint Web Services. Even better, we are going to create the ability to automate Site Creation across multiple Site Collections. If you're looking for a tutorial on how to do this in Nintex Workflow 2010/2013, I've written an article here:  SharePoint 2010 - Automate Site & Group Creation with Nintex Workflow 2010 Why As most SharePoint administrators are aware, it's ALWAYS a bad idea to give staff the ability to create SharePoint sites.  They will end up creating them for the wrong purposes, will not maintain them, no retention policies will get assigned to them, etc. However, you don't want to restrict your users creative freedom.  You want to govern it...

This article stems from another article explaining how to  Automate Site & Group Creation with Nintex Workflow 2010 What Use Powershell to retrieve detailed data about the permission levels on a particular site Why I was looking for a way to automate Site & Group creation using nintex workflows.  In order to create groups, you need to call a SharePoint Web Service.  That Web Service requires an input value called 'permissionMask (int)'. This powershell script will allow you to find the correct permission Mask related to your particular environment & permission levels. How Jump onto your WFE, open up SharePoint Powershell as admin and paste in the following code (with the site you wish to retrieve data for: ## Get site permissions using SharePoint 2010 web service in powershell $uri=" http://rootsite/subsite /_vti_bin/Permissions.asmx?wsdl"  ## $siteName is a string which contains the site name for which you need to get the permissions [St...

What is this?   A tutorial on how to set up a cool list on SharePoint where staff can manage their favourite links, ideally on the homepage of your intranet. This keeps all their commonly accessed web-stuff 1 click away, and it means you do not have to fill up your SharePoint navigation with 100's of useless links that only 5-10 people use. Woah that sounds sweet, how is that even possible!?   Well I'm going to show you how, in this tutorial we are using SharePoint Online, because then this post will be relevant for more than a year. Step 1:  Create a Custom List called 'Personal Shortcuts' by clicking Settings > Add an app , and selecting 'Custom List'. Step 2: Create a new column in your new list by clicking the List Tab > Create Column .  Call the new column ' Shortcut ', Set the Type as ' Hyperlink or Picture ' & make sure the column requires a value . Step 3: Now we need to remove the Title column from this list...

Recently I was working with a client who's SharePoint 2010 environment had been poorly managed for years.  They had a single site collection on a single, large content database (650GB).  Not uncommon, however this environment also occasionally froze up, never loading any of the pages on any sites until an IISRESET was performed on the Web Front End (WFE). It started off only happening once a month, then moved to once a week, a few times a week, to 5-10 times a day... Begin Troubleshooting: The issue was around too many lists, and items within those lists having their own permissions. Each permission for an item counts as one row in the RoleAssignment table in the database. apparently they say a healthy DB will only have 200,000 rows in that table. Ours had 10,000,000 rows (You can check this by right-clicking the Database in SQL Management Studio and clicking Reports > Disk Usage by Top Tables.  Then look for the RoleAssignment Table).  and every time...

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';

We can do this using jQuery.js and SPServices.js Only issue is that you will most likely be forced to receive a notification every time the page loads: "this page is accessing information that is not under its control" I found that although it's possible the solution was not ideal, but have not yet found an alternative.  However I thought I would provide it in case anyone else has a need for it. The code below will retrieve the list item information from the Page library at http://intranet.  CAML query retrieves the most recent 4 articles from the Page library and the last line appends the HTML statement to the page. The HTML statement that is created grabs the value of the FileRef Field and places it inside a div. ---------------------------------------------- $(document).ready(function() {   $().SPServices({     operation: "GetListItems",     async: false,     webURL: "http://intranet",     listName: "Pages", ...