AgilePoint step by step: Bulk Process Migration

Real World Scenario: AgilePoint BPMS 5.0 SP4

So you have a couple of workflows already deployed to Production, and have hundreds of active processes running. One day your Business User comes to you and says: "Can we do X and Y and then also R,S,T, U while you're making the changes.."

Fine, you think. OK, a couple of days later you deployed the new workflow, and THEN your Business User says: "Look there's a system bug and the issue is not fixed. How come my process is still doing A and B? I thought you have already made changes???"

err.... didn't I already mention that the change would only apply on NEW processes? LOL.

Now here's what you need to do to remedy it!

How to upload InfoPath 2010 attachments to a SharePoint document library without code

It was extremely, insanely hard to get a proper reference to a way to upload InfoPath attachments to a SharePoint document library WITHOUT CODE. I hope this will help you or at least point you in the right direction.

This is for SharePoint 2010.

Firstly in the InfoPath form, create a Query web service Data Connection.
Make the web service call to /_vti_bin/Copy.asmx.wsdl.

Next, select the CopyIntoItems method. Leave all fields blank and proceed to assign the data connection a proper name.

Find processes making outgoing HTTP requests using the NETSTAT command

A set of simple commands to trace Internet traffic:

First you want to list out all connections by launching Command Prompt. If not sure which flag to use, type netstat --help to list all available commands.

If you type netstat without any additional flags, only active connections will be listed.
Typing netstat with the flag will list out the process ID as well. e.g. netstat -p

I will usually follow up with running the tasklist command to locate which executable the process belongs to.

SharePoint & PowerShell: List all alerts (on document libraries, lists) in a site

As a site collection administrator, I find it extremely tedious to go to Site Actions - Site Settings, click on User Alers, and display alerts one by one. Here's a PowerShell script to get the information needed~!

Let's say you have a subsite with the URL http://sharepoint/subsite1

Launch SharePoint 2010 Management Shell and run this script (copy and paste the following, and save it as .ps1).

## Load the website

     $web = Get-SPWeb "http://sharepoint/subsite1/" 

     $resultSet = @() 

         foreach ($alert in $web.Alerts){ 

             $URL = $web.URL + "/" + $alert.ListUrl 

             $result = New-Object PSObject 

             $result | Add-Member -type NoteProperty -name "Title" -value $alert.Title 

             $result | Add-Member -type NoteProperty -name "URL" -value $URL 

             $result | Add-Member -type NoteProperty -name "Alert Type" -value $alert.AlertType 

             $result | Add-Member -type NoteProperty -name "User" -value $alert.User 

             $resultSet += $result 

        } 

## Best practice: dispose when done

    $web.Dispose() 

## Display the result

    $resultsSet 

## To export the result

    $resultSet | Export-Csv "Output.csv"

PowerShell script to Monitor and Auto-expand SharePoint site collection quota

Get-SPSite -Limit ALL | 

    Where { $_.Url -like "*/teamsite/*" -and [int]($_.Usage.Storage/1MB) -gt [int](($_.Quota).StorageWarningLevel/1MB) } |
    ForEach-Object {
 $maxSize = ($_.Quota).StorageMaximumLevel + (5000*1MB)
 $maxWarning = $maxSize - (200*1MB)
        Set-SPSite -Identity $_.Url -MaxSize $maxSize -WarningSize $maxWarning
    }

This script will retrieve all Sharepoint site objects where there is a "/teamsite/" found in the URL, and where the current usage has exceeded the user warning level.

It will automatically increment 5 GB of storage quota and update the warning level as well.

However, there are situations where some sites have unlimited quota. In this case, you will have to modify the script slightly to include an additional condition:

Where { $_.Url -like "*/teamsite/*" -and [int](($_.Quota).StorageWarningLevel/1MB) -gt 0 -and [int]($_.Usage.Storage/1MB) -gt [int](($_.Quota).StorageWarningLevel/1MB) }