$Output=”C:\sites_NintexLogs.csv”;
function Cancel-SPWorkflow(){
PARAM
(
[Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.Workflow.SPWorkflow] $SPWorkflow
)
BEGIN {
}
END {
}
PROCESS {
[Microsoft.SharePoint.Workflow.SPWorkflowManager]::CancelWorkflow($SPworkflow)
}
}
function Get-SPWorkflow(){
PARAM
(
[Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.SPListItem] $SPListItem
)
BEGIN {
}
END {
}
PROCESS {
$SPListItem.Workflows
}
}
“WebApplicationName” +”,” + “SiteName” +”,” + “SiteURL” +”,” + “ListURL” +”,”+ “NintexLog”| Out-File -Encoding Default -FilePath $Output;
$farm = Get-SPWebApplication | select DisplayName
$NintexLog;
foreach($app in $farm)
{
$webapp = Get-SPWebApplication | ? {$_.DisplayName -eq $app.DisplayName}
write-host “Webapplication Title:”$webapp.DisplayName
Foreach ($SPSite in $Webapp.Sites)
{
foreach($SPweb in $SPSite.AllWebs)
{
foreach($Subsite in $SPweb)
{
foreach($list in $Subsite.lists)
{
$NintexLog = $list.Items | Get-SPWorkflow | where {[DateTime]$_.Modified -lt “04/16/2015 12:00:00 AM”}
$list.Items | Get-SPWorkflow| where {[DateTime]$_.Modified -lt “04/16/2015 12:00:00 AM”} | Cancel-SPWorkflow
$webapp.DisplayName + “,” + $Subsite.Title + “,” + $Subsite.URL + “,” + $list.Title + “,” +$NintexLog | Out-File -Encoding Default -Append -FilePath $Output;
}
}
}
}
}
$Output=”C:\sites_NintexLogs.csv”;
function Cancel-SPWorkflow(){
PARAM
(
[Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.Workflow.SPWorkflow] $SPWorkflow
)
BEGIN {
}
END {
}
PROCESS {
[Microsoft.SharePoint.Workflow.SPWorkflowManager]::CancelWorkflow($SPworkflow)
}
}
function Get-SPWorkflow(){
PARAM
(
[Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.SPListItem] $SPListItem
)
BEGIN {
}
END {
}
PROCESS {
$SPListItem.Workflows
}
}
“WebApplicationName” +”,” + “SiteName” +”,” + “SiteURL” +”,” + “ListURL” +”,”+ “NintexLog”| Out-File -Encoding Default -FilePath $Output;
$farm = Get-SPWebApplication | select DisplayName
$NintexLog;
foreach($app in $farm)
{
$webapp = Get-SPWebApplication | ? {$_.DisplayName -eq $app.DisplayName}
write-host “Webapplication Title:”$webapp.DisplayName
Foreach ($SPSite in $Webapp.Sites)
{
foreach($SPweb in $SPSite.AllWebs)
{
foreach($Subsite in $SPweb)
{
foreach($list in $Subsite.lists)
{
$NintexLog = $list.Items | Get-SPWorkflow | where {[String]$_.StatusText -match [String]”Error”}
$list.Items | Get-SPWorkflow| where {[String]$_.StatusText -match [String]”Error”} | Cancel-SPWorkflow
$webapp.DisplayName + “,” + $Subsite.Title + “,” + $Subsite.URL + “,” + $list.Title + “,” +$NintexLog | Out-File -Encoding Default -Append -FilePath $Output;
}
}
}
}
}
$Output=”C:\sites_NintexLogs.csv”;
“WebApplicationName” +”,” + “SiteName” +”,” + “SiteURL” +”,” + “NintexLog”| Out-File -Encoding Default -FilePath $Output;
$farm = Get-SPWebApplication | select DisplayName
$NintexLog;
foreach($app in $farm)
{
$webapp = Get-SPWebApplication | ? {$_.DisplayName -eq $app.DisplayName}
write-host “Webapplication Title:”$webapp.DisplayName
Foreach ($SPSite in $Webapp.Sites)
{
foreach($SPweb in $SPSite.AllWebs)
{
foreach($Subsite in $SPweb)
{
$NintexLog = Nwadmin.exe -o syncterminatedworkflows -url $Subsite.URL -terminateDeletedItems
$webapp.DisplayName + “,” + $Subsite.Title + “,” + $Subsite.URL + “,” + $NintexLog | Out-File -Encoding Default -Append -FilePath $Output;
}
}
}
}
$Output=”C:\sites_NintexLogs_180_300.csv”;
function Get-SPWorkflow(){
PARAM
(
[Parameter(ValueFromPipeline=$true)] [Microsoft.SharePoint.SPListItem] $SPListItem
)
BEGIN {
}
END {
}
PROCESS {
$SPListItem.Workflows
}
}
Get_RunningNintexWorkflow180_300_600_1000DaysOld
“WebApplicationName” +”,” + “SiteName” +”,” + “SiteURL” +”,” + “SiteOwner Email” +”,” + “ListURL” +”,” + “180Days” +”,” + “300Days” +”,” + “600Days” +”,” + “1000Days”| Out-File -Encoding Default -FilePath $Output;
$farm = Get-SPWebApplication | select DisplayName
$180Days;
$300Days;
$600Days;
$1000Days;
foreach($app in $farm)
{
$webapp = Get-SPWebApplication | ? {$_.DisplayName -eq $app.DisplayName}
if($webapp -notmatch “mysite”)
{
write-host “Webapplication Title:”$webapp.DisplayName
Foreach ($SPSite in $Webapp.Sites)
{
foreach($SPweb in $SPSite.AllWebs)
{
foreach($Subsite in $SPweb)
{
foreach($list in $Subsite.lists)
{
$180Days = $list.Items | Get-SPWorkflow | where {[DateTime]$_.Modified -lt “05/11/2015 12:00:00 AM”}
$300Days = $list.Items | Get-SPWorkflow | where {[DateTime]$_.Modified -lt “01/24/2015 12:00:00 AM”}
$600Days = $list.Items | Get-SPWorkflow | where {[DateTime]$_.Modified -lt “03/30/2014 12:00:00 AM”}
$1000Days = $list.Items | Get-SPWorkflow | where {[DateTime]$_.Modified -lt “02/23/2013 12:00:00 AM”}
$webapp.DisplayName + “,” + $Subsite.Title + “,” + $Subsite.URL + “,” + $Subsite.RequestAccessEmail + “,” + $list.Title + “,” +$180Days.Count + “,” +$300Days.Count+ “,” +$600Days.Count+ “,” +$1000Days.Count| Out-File -Encoding Default -Append -FilePath $Output;
}
}
}
}
}
}
