Guest User

Untitled

a guest
Apr 19th, 2018
79
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.  
  12. foreach ($item in $listItems)
  13. {
  14. $emailbody = $emailbody + '<br/> <a href ="' + $userfriendlyURL + '/Pages/' + $item["LinkFilename"].toString() + '">' + $item["Title"].toString() + '</a>'
  15. Write-Host "found"
  16. }
  17.  
  18. Connect-PnPOnline -Url "https://your-tenant.sharepoint.com/sites/test" -UseWebLogin
  19.  
  20. $filterDate = Get-Date -Day 05 -Month 03 -Year 2018 -Hour 16 -Minute 00
  21. $formattedDate = $filterDate.ToString("yyyy-MM-ddTHH:mm:ss.fffffffZ")
  22.  
  23. $caml = "<View><Query><Where><Geq><FieldRef Name='Modified'/><Value Type='DateTime'>$formattedDate</Value></Geq></Where></Query></View>"
  24.  
  25. $items = Get-PnPListItem -List "Pages" -Query $caml
  26.  
  27. foreach ($i in $items) {
  28. #do some stuff here
  29. }
Add Comment
Please, Sign In to add comment