This get the Created By (author) and the Modified By (editor) firleds from a sharePoint List
$webUrl = "https://xxxxx/cmdtools/tools/RDR"
$listName = "Deficiency Reports"
# Open web and library
$web = Get-SPWeb $webUrl
$list = $web.Lists[$listName]
$items = $list.items
'RDR' | out-file f:\temp\wintzer.txt -append
foreach ($item in $items)
{
if($Item["Author"].ToString() -like '*wintzer*'){
'Author' | out-file f:\temp\wintzer.txt -append
$Item["ID"] | out-file f:\temp\wintzer.txt -append
$Item["Author"] | out-file f:\temp\wintzer.txt -append}
if($Item["Editor"].ToString() -like '*wintzer*'){
'Editor' | out-file f:\temp\wintzer.txt -append
$Item["ID"] | out-file f:\temp\wintzer.txt -append
$Item["Editor"] | out-file f:\temp\wintzer.txt -append}
}
function testField($field)
{
if($Item[$field] -ne $null -and $Item[$field].ToString() -like '*wintzer*'){
$field | out-file f:\temp\wintzer.txt -append
$Item["ID"] | out-file f:\temp\wintzer.txt -append
$Item[$field] | out-file f:\temp\wintzer.txt -append}
}
<#
$webUrl = "https://homeportnw.psns.navy.mil/cmdtools/tools/RDR"
$listName = "Deficiency Reports"
# Open web and library
$web = Get-SPWeb $webUrl
$list = $web.Lists[$listName]
$items = $list.items
'RDR' | out-file f:\temp\wintzer.txt -append
foreach ($item in $items)
{
testField('Author')
testField('Editor')
testField('Issuer')
testField('AssignedTo')
testField('Routing1')
testField('Routing2')
testField('Routing3')
testField('Routing4')
testField('Routing5')
testField('Routing6')
testField('Reviewer')
testField('Closing%5Fx0020%5FOfficial')
testField('Author')
testField('Author')
}
#>
$webUrl = "https://homeportnw.psns.navy.mil/tools/cats"
$listName = "CATS Items"
# Open web and library
$web = Get-SPWeb $webUrl
$list = $web.Lists[$listName]
$items = $list.items
'RDR' | out-file f:\temp\wintzer.txt -append
foreach ($item in $items)
{
testField('Author')
testField('Editor')
testField('Approver')
testField('AssignedTo')
testField('Concurrence')
testField('Concurrence2')
testField('Concurrence3')
testField('Concurrence4')
testField('Concurrence5')
testField('Concurrence6')
testField('WorkLead')
}
<#
$webUrl = "https://homeportnw.psns.navy.mil/tools/cats"
$listName = "CATS Items"
# Open web and library
$web = Get-SPWeb $webUrl
$list = $web.Lists[$listName]
$items = $list.items
'Cats' | out-file f:\temp\wintzer.txt -append
foreach ($item in $items)
{
if($Item["Author"].ToString() -like '*wintzer*'){
'Author' | out-file f:\temp\wintzer.txt -append
$Item["ID"] | out-file f:\temp\wintzer.txt -append
$Item["Author"] | out-file f:\temp\wintzer.txt -append
}
if($Item["Editor"].ToString() -like '*wintzer*'){
'Editor' | out-file f:\temp\wintzer.txt -append
$Item["ID"] | out-file f:\temp\wintzer.txt -append
$Item["Editor"] | out-file f:\temp\wintzer.txt -append}
}
#>