Software – Page 2 – markwheeler.com

Managing SharePoint User Group Memberships with JQuery and SPServices

December 16, 2015 mmwheeler

Create a simple interface to add/remove a single user to/from multiple groups at once. When you identify/select a user, it will show you two select lists. The right side will list all of the groups the current user is a member of while the left box shows all the groups […]

Query for SharePoint Groups and Members with JQuery and SPServices

December 15, 2015 mmwheeler

The following code returns all SharePoint permissions groups and the respective members. This uses JQuery 1.xx and SPServices. // Add JQuery and SPServices references. // GroupMember

BMC Remedy Assigned Group Incident Transfer(s) Query

January 22, 2015 mmwheeler

Had a request from a customer for a report showing the number of Remedy incidents transferred from his managed group to other groups during a given date range. I figured out a pseudo lead/lag query for SQL Server 2008. This creates an output that aligns the current row with the […]

SSIS: Upload file to Sharepoint Document Library (revisited)

April 24, 2014 mmwheeler

A while ago I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS. Here’s another solution…Simply cut and paste the following into a Script Task in your SSIS package. This is the simple version as the local file, Sharepoint URL and service account credentials […]

Import InfoPath XML to SQL Table with SSIS

March 10, 2014 mmwheeler

Had a request to import InfoPath forms into a SQL table for consolidating reporting purposes. In this scenario the InfoPath form data is stored in the form XML itself. The InfoPath form is for tracking project activities and has 6 fields: Project Leader, Week End Date, Accomplishments, Milestones, Risks, Lessons […]

SSIS package to Send Email based on SP Task List Due Dates

February 26, 2014 mmwheeler

Had a request to send notification emails against a SharePoint Task List when the Due Dates were 90, 60, 30 and 5 days out. Steps: 0. You will need to create the 6 variables show on the left. 1. I am dropping and importing the SP List Data each time […]

Adding StripLines with Report Builder

February 6, 2014 mmwheeler

I have a Forecast/Trending Chart that has past and future dates. I needed to denote Today with a vertical StripLine on the chart. (Click on images for larger version.) You can add a Marker with an expression easily. In your series properties; create an expression for your Marker. In my […]

JQuery Sharepoint Document Library for most Recent File(s).

January 11, 2014 mmwheeler

I have an email-enabled document library where reports in PDF format are delivered daily. I need to display the most recent reports embedded on a Web Part page. The filenames are structured as name_datestamptimestamp.pdf Different reports are sent here so I have to discern a part of the filename (eg. […]

SQL queries for Sharepoint 2010 Site and User Permissions

November 14, 2013 mmwheeler

In some cases you may want to audit who has what permissions to various parts of your SharePoint site or farm. This query will give you a list of all of your groups, the roles / permissions of the groups, the users in those groups, and what they have permissions […]

Manage all SSRS Subscriptions in Sharepoint

October 4, 2013 mmwheeler

I needed a way for me and my teammates to see and edit all report subscriptions across a Sharepoint site with SQL Reporting Services in Integrated mode. There are two parts here; the first is a function that returns text between delimiters. This is important to get the site and […]