Fun Technology Blog: Sitecore PowerShell Script

Friday, October 7, 2022

Sitecore PowerShell Script - Get Item Details

We have received request to identify list of Sitecore Items that were modified from certain date, which contains latest numbered versions, which should have all language versions and modified by particular user. After research we came across Out of the Box Sitecore feature which provides some of these information. I have added link below you can go through document for more details.

Link: https://doc.sitecorepowershell.com/modules/integration-points/reports

Above Out of the Box feature does not contains all the information that we required, especially language versions for the items were missing in the reports.

To solve this problem we decided to write custom PowerShell script which will provide the details.

$itemPath = "master:/sitecore/content/home"
$fromDate = (get-date "08/01/2021") # mm/dd/yyyy format

Get-ChildItem -Path $itemPath -Recurse -Language * | 
Where-Object { $_.__Updated -gt $fromDate -and $_."__Updated By" -eq "sitecore\Admin" } |
Select-Object -Property @{Label="Display Name"; Expression={$_."DisplayName"} }, 
						@{Label="ID"; Expression={$_."Id"} }, 
						@{Label="Item Path"; Expression={$_."itemPath"} }, 						
						@{Label="Language Version"; Expression={$_."Language"} }, 												
						@{Label="Numbered Version"; Expression={$_."Version"} }, 																		
						@{Label="Created Date"; Expression={$_."Created"} }, 
						@{Label="Updated Date"; Expression={$_."__Updated"} },  
						@{Label="Template Name"; Expression={$_."TemplateName"} },  
						@{Label="Template ID"; Expression={$_."TemplateID"} },  						
						@{Label="Created By"; Expression={$_."__Created By"} }, 
						@{Label="Updated By"; Expression={$_."__Updated By"} }

Console Output

Above script will provide details of items staring from particular date, which will contain latest numbered version, all created language version and item modified by particular user.

Details displayed for items are as follows:

Display Name
ID
Item Path
Language Version
Numbered Version
Created Date
Updated Date
Template Name
Template ID
Created By
Updated By

Also you can modify above script as per your requirement and reuse the script.

If you want to export the content in text file you can use below script to perform the task.

$itemPath = "master:/sitecore/content/home"
$fromDate = (get-date "08/01/2021") # mm/dd/yyyy format

[String[]] $data = Get-ChildItem -Path $itemPath -Recurse -Language * | 
Where-Object { $_.__Updated -gt $fromDate -and $_."__Updated By" -eq "sitecore\Admin" } |
Select-Object -Property @{Label="Display Name"; Expression={$_."DisplayName"} }, 
						@{Label="ID"; Expression={$_."Id"} }, 
						@{Label="Item Path"; Expression={$_."itemPath"} }, 						
						@{Label="Language Version"; Expression={$_."Language"} }, 												
						@{Label="Numbered Version"; Expression={$_."Version"} }, 																		
						@{Label="Created Date"; Expression={$_."Created"} }, 
						@{Label="Updated Date"; Expression={$_."__Updated"} },  
						@{Label="Template Name"; Expression={$_."TemplateName"} },  
						@{Label="Template ID"; Expression={$_."TemplateID"} },  						
						@{Label="Created By"; Expression={$_."__Created By"} }, 
						@{Label="Updated By"; Expression={$_."__Updated By"} }						
						
Out-Download -Name ItemDetailsReport.txt -InputObject $data