I have two Lists. A Calendar Lists and a Custom List
In one List I have multiple records all with an ‘EventID’ field which relates to a Calendar record (The record ID)
I am trying to use PowerShell to recurse through each Custom List record and check to see if the ‘EventID’ has a relating ‘Calendar ID’ in the Calendar record. If not, it means the Calendar entry has been deleted and the ‘Orphaned’ field in the Custom List record should be set to ‘YES’. There may be multiple records in the Custom List per Calendar Entry. I need to update ALL records WITHOUT a valid Calendar Entry to ‘Orphaned’.
Although not finished, so far I have this code, but I’m sure there must be a better way to do this, and a different way so that once a MISSING ‘EventID’ is found (the Calendar entry is deleted) then the loop stops and moves on to the next Calendar entry. My mind has just gone blank.
cls
#Add Snapin
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
Start-Transcript -Path "D:SharePointScriptsEmailTranscript.txt"
#Set Variables
$spWeb = Get-SPWeb -Identity "http://ds.stylus.com"
$PClist = (Get-SPWeb "http://ds.stylus.com").Lists("PreventionCalendar")
$DElist = (Get-SPWeb "http://ds.stylus.com").Lists("DirectEngagement")
$DEvID = "EventID"
$DEvStatus = "Status"
#Get Today's Date - var: $now
$now = Get-Date
Write-Host "Today is:" $now
$PCitems = $PClist.Items
#show the item count for the library
Write-Host "PreventionCalendar - Total Records: $($PCitems.count)"
$DEitems = $DElist.Items
#show the item count for the library
Write-Host "DirectEngagement - Total Records: $($DEitems.count)"
if($PCitems.count -lt 1)
{
foreach($item in $DEitems)
{
$DEID = $item.ID
#Get the DE Status value
$DEvStat = $item($DEvStatus)
#Get the DE EventID value
$DEvIDent = $item($DEvID)
Write-Host "PreventionCalendar is Empty. Orphan Appliance"
$SPListItem = $DElist.GetItemById($DEID)
$SPListItem("Status") = "Appliance Orphaned"
$SPListItem.Update()
}
}
elseif($PCitems.count -ge 1)
{
foreach($item in $DEitems)
{
$DEID = $item.ID
#Get the DE Status value
$DEvStat = $item($DEvStatus)
#Get the DE EventID value
$DEvIDent = $item($DEvID)
Write-Host -Foregroundcolor Green "Checking..... Appliance ID:" $DEID "EventID:" $DEvIDent
foreach($item in $PCitems)
{
$PCID = $item.ID
Write-Host -Foregroundcolor Red "IF 'EventID'" $DEvIDent "EQUALS 'CalendarID'" $PCID "run.."
if($DEvIDent -eq $PCID)
{
Write-Host "Appliance ID:" $DEID "EventID:" $DevIDent "Matched with PreventionCalendar ID:" $PCID
{break}
}
else
{
Write-Host "Appliance ID:" $DEID "EventID:" $DevIDent "PreventionCalendar ID: No Match Found"
}
}
}
}
Write-Host "Orphaned Appliances Updated"
Any help would be appreciated.
Rick