Sitecore Modules

Sitecore PowerShell Extension(SPE)

Compatibility Table

https://doc.sitecorepowershell.com/appendix

Downloads

https://github.com/SitecorePowerShell/Console/releases/

Tutorials

https://doc.sitecorepowershell.com/

https://www.youtube.com/playlist?list=PLph7ZchYd_nCypVZSNkudGwPFRqf1na0b

Sitecore with MVC Areas as pluggable Module

https://cprakash.com/2014/10/27/sitecore-and-mvc-areas-as-pluggable-module/

Comments

Docker Desktop service is not running, would you like to start it?

Bellow message appear while restarting Windows laptop having Docker Desktop installed. Docker Desktop service is not running, would you like to start it? Windows will ask you for elevated access. During online search, we found below solution on stackOverflow which worked for us. Docker: Service is not running. Windows will ask you for elevated access Please follow this solution. Hope this helps.

SQL Server

Check Fragmentation stats SELECT dbschemas . [name] as 'Schema' , dbtables . [name] as 'Table' , dbindexes . [name] as 'Index' , indexstats . alloc_unit_type_desc , indexstats . avg_fragmentation_in_percent , indexstats . page_count FROM sys . dm_db_index_physical_stats ( DB_ID (), NULL, NULL, NULL, NULL) AS indexstats INNER JOIN sys . tables dbtables on dbtables . [object_id] = indexstats . [object_id] INNER JOIN sys . schemas dbschemas on dbtables . [schema_id] = dbschemas . [schema_id] INNER JOIN sys . indexes AS dbindexes ON dbindexes . [object_id] = indexstats . [object_id] AND indexstats . index_id = dbindexes . index_id WHERE indexstats . database_id = DB_ID () ORDER BY indexstats . avg_fragmentation_in_percent desc Rebuild Indexes DECLARE @tsql NVARCHAR ( MAX ) DECLARE @fillfactor INT SET @fillfactor = 90 SELECT @tsql = STUFF...

Export Pdf list via Sitecore PowerShell Extension

This Sitecore PowerShell utility export a list of Pdfs for specified location $FilePath = "master:" + (Get-Item .).Paths.Path Import-Function -Name ConvertTo-Xlsx $DownloadReport = 1 $resultObj = @() $PdfList = Get-childItem -Path $FilePath -Recurse | Where-Object { $_.TemplateName -eq "Pdf"} $ItemReferrerList = "" if( $PdfList ){ $PdfList | ForEach-Object { ######Get-ItemReferrer Start $ItemArray = @() $ItemReferrer = Get-ItemReferrer -ID $_.ID | Where-Object { $_.Name -ne "Admin" -and $_.ItemPath -like "/sitecore/content/*" } | Select-Object -Property ID,Version If( $ItemReferrer ){ $ItemReferrer | ForEach-Object { $item = Get-Item -Path master: -ID $_.ID $latestVersion = $item.Versions.Count ...

techSitecore

Search This Blog