Guest User

Untitled

a guest
Apr 19th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. $startdate = Get-Date -Day 05 -Month 03 -Year 2018 -Hour 16 -Minute 00
  2. $startDateIsoFormat = [Microsoft.SharePoint.Utilities.SPUtility]::CreateISO8601DateTimeFromSystemDateTime($startdate)
  3. $emailbody =""
  4. $web = Get-SPWeb "http://****/kb/info"
  5. $userfriendlyURL = "http://www.*****.intra/kb/info"
  6. $list = $web.GetList(($web.ServerRelativeUrl.TrimEnd("/") + "/Pages"))
  7. $spQuery = New-Object Microsoft.SharePoint.SPQuery;
  8. $camlQuery = "<Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$startDateIsoFormat</Value></Geq></Where>";
  9. $spQuery.Query = $camlQuery
  10. $listItems = $list.GetItems($spQuery)
  11. foreach ($item in $listItems)
  12. {
  13. $emailbody = $emailbody + '<br/> <a href ="' + $userfriendlyURL + '/Pages/' + $item["LinkFilename"].toString() + '">' + $item["Title"].toString() + '</a>'
  14. Write-Host "found"
  15. }
  16.  
  17. Connect-PnPOnline -Url "https://your-tenant.sharepoint.com/sites/test" -UseWebLogin
  18.  
  19. $filterDate = Get-Date -Day 05 -Month 03 -Year 2018 -Hour 16 -Minute 00
  20. $formattedDate = $filterDate.ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ")
  21.  
  22. $caml = "<View><Query><Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$formattedDate</Value></Geq></Where></Query></View>"
  23.  
  24. $items = Get-PnPListItem -List "Pages" -Query $caml
  25.  
  26. foreach ($i in $items) {
  27. #do some stuff here
  28. }
Add Comment
Please, Sign In to add comment