get-spweb我怎样才能得到今天创建的项目

Question

我正在使用下一个Powershell脚本从Sharepoint列表中获取项目并导出它如何编辑此脚本以仅获取今天创建的数据或今天输入的数据这是代码

$MyWeb = Get-SPWeb "http://ilike-eg.suz.itcgr.net/SM"
$MyList = $MyWeb.Lists["SCGC"] 
$exportlist = @()
$Mylist.Items |  ForEach-Object {
$obj =   New-Object PSObject -property @{ 
        "A"="   "+$_["AACCOUNT_ID"]
        "B"="   "+$_["BTRANSACTION_ID"]
        "C"="          "+$_["CDATE"] 
        "D"="      "+$_["DCUSTOMER_ID"]
        "E"="     "+$_["ECUSTOMER_NAME"]
        "F"=" "+$_["FAMOUNT"]
        "G"=" "+$_["GCLASS"] 
}
#Remove unnecessary sort
$exportlist += $obj   
$DateStamp = get-date -uformat "%Y-%m-%d@%H-%M-%S"
$NameOnly = "CDP" 
#Exporting with sorted properties
$exportlist |
Select-Object A,B,C,D,E,F,G |
Export-Csv -Delimiter "`t"-path "$NameOnly.txt"
}
#Removed duplicate get-content line
$a, ${d:CDP.txt} = Get-Content .CDP.txt
$a, ${d:CDP.txt} = Get-Content .CDP.txt
(Get-Content D:CDP.txt) |
Foreach-Object {$_ -replace $([char]34) -replace "`t" -replace '/', '-'} |
Set-Content D:CDP.txt

谢谢

Answer 1

在插入SPListItems的地方，插入一个查询来获取今天创建的项

改变:

$Mylist.Items |

:

$Mylist.Items | where {$_['Created'] -eq Get-Date -format d}