Home Gitesh Portfolio Blog About Me Gallery Contact

Sitecore

PowerShell: Find Sitecore Personalization Rules on items in Sitetree

Discover how to use a simple PowerShell script to identify Sitecore renderings with personalization rules. This script helps streamline the process of finding items that use personalization to enhance user experiences.

Posted: 23/01/2024 2:57:12 p.m. by Gitesh Shah | with 0 comments


XM Cloud: Failing Invoke-RestMethod localhost:8079

While working locally on XM Cloud you might see an error Invoke-RestMethod "http://localhost:8079/api/http/routers when spinning up containers.

Posted: 26/11/2023 8:34:30 p.m. by Gitesh Shah | with 0 comments


Optimizing Sitecore XConnect: Identifying and Addressing High Interactions Per Contact

SQL query to find amount of interactions per contact. More the number (1000+ of interactions per contact can degrade the performance.

Posted: 18/11/2023 6:28:20 p.m. by Gitesh Shah | with 0 comments


Temporarily disabling New Relic inside Sitecore Container for debugging

Temporarily disabling New Relic inside Sitecore Container for debugging

Posted: 10/10/2023 8:14:09 p.m. by Gitesh Shah | with 0 comments


Installing New Relic inside Sitecore docker container

Explore the step-by-step guide on integrating New Relic into your Sitecore Docker container, unlocking powerful performance monitoring and analytics capabilities for your Sitecore environment.

Posted: 6/10/2023 9:54:52 p.m. by Gitesh Shah | with 0 comments


XM Cloud: The request queue limit of the session is exceeded.

While working locally you might see a 500 error message in XM Cloud development for  The request queue limit of the session is exceeded.

Posted: 25/09/2023 8:34:08 p.m. by Gitesh Shah | with 0 comments


Enhancing Sitecore Performance: Resolving SQL Index Fragmentation

Discover how we tackled sluggish performance in our CMS and CD pods, reducing Sitecore warmup times and addressing SQL index fragmentation for a faster and more efficient system.

Posted: 6/09/2023 6:36:18 p.m. by Gitesh Shah | with 0 comments


Sitecore: XDB - Find all the interaction URLs in collection table

XDB - Find all the interaction URLs in collection table. This is very good way to find that what type of interactions your users are doing on your site.

Posted: 19/08/2023 4:06:13 p.m. by Gitesh Shah | with 0 comments


Find Sitecore's performance degraded pages from Azure logs

Query to get response times for specific period and excluding response times with <250ms

Posted: 15/08/2023 2:48:41 p.m. by Gitesh Shah | with 0 comments


Sitecore: How to Find the Size of All Database Tables?

In this blog post, we will explore a SQL query to help you find the size of all the database tables in your Sitecore database. Understanding the size of individual tables can be essential for database maintenance and optimizing performance.

Posted: 25/07/2023 8:38:53 p.m. by Gitesh Shah | with 0 comments


Sitecore: Add showconfig.aspx file in CD server

Showconfig.aspx file exists in the CM server only by doing this you will be able to add this file in the CD server as well.

Posted: 21/06/2023 8:57:21 p.m. by Gitesh Shah | with 0 comments


Sitecore X-Connect abandon page

By creating the abandon page you can end the session of a X-connect user immediately and don't have to wait for 20 mins for the session to end.

Posted: 22/05/2023 2:23:14 p.m. by Gitesh Shah | with 0 comments


Connecting Your Next.js App with Sitecore GraphQL

Dive deep into the technical intricacies of integrating Next.js, the React framework powerhouse, with Sitecore's GraphQL endpoint. Explore practical examples and learn how to optimize data retrieval for high-performance web applications.

Posted: 25/04/2023 9:19:24 p.m. by Gitesh Shah | with 0 comments


Sitecore Kubectl commands

In this blog you will find some useful Kubectl commands for Sitecore.

Posted: 23/04/2023 8:56:18 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to count the number of child items in the sitetree.

With this powershell command you will be to count the number of child items in the sitetree.

Posted: 22/04/2023 8:56:55 p.m. by Gitesh Shah | with 0 comments


Mastering GraphQL in Sitecore 10.3: A Technical Developer's Guide

Unlock the full potential of Sitecore 10.3 by diving into the technical intricacies of working with GraphQL. This blog equips developers with the knowledge and tools needed to harness the capabilities of GraphQL for efficient data querying and manipulation.

Posted: 10/04/2023 9:16:17 p.m. by Gitesh Shah | with 0 comments


Install JSS module in Sitecore

Delve into the technical intricacies of installing the Sitecore JavaScript Services (JSS) headless module to empower your web development projects. This guide for developers explores the step-by-step process of integrating JSS for a seamless headless CMS experience.

Posted: 28/03/2023 9:57:34 p.m. by Gitesh Shah | with 0 comments


Sitecore Serialization: Filesystem integrity validation found errors in serialized files! Use the validate command to fix these.

In Sitecore serialization if you change the path of the files manually you can get an error for Filesystem integrity validation found errors in serialized files! Use the validate command to fix these.

Posted: 28/03/2023 8:27:18 p.m. by Gitesh Shah | with 0 comments


Sitecore Helm commands

In this blog you will find some useful Helm commands for Sitecore.

Posted: 20/03/2023 8:55:10 p.m. by Gitesh Shah | with 0 comments


Lens: Missing KubeLogin client-go-credential-plugins

If you are using containers for Sitecore you would have used Lens for connecting to AKS (Azure kubernetes Service). With the latest version of Lens & latest version of AKS (1.24+), it will break and show you and error "It looks like you are trying to use a client-go credential plugin that is not installled."

Posted: 16/03/2023 5:19:26 p.m. by Gitesh Shah | with 0 comments


Sitecore: Docker - Find CPU usage of each pods in AKS

In this blog , you will find a Azure logs query that can help you to find CPU usage of each pods in Azure Kubernetes Service (AKS).

Posted: 14/03/2023 8:54:50 p.m. by Gitesh Shah | with 0 comments


Sitecore: Generate Sitemap and export to excel

With this powershell command you will be to generate a sitemap for your sitecore content tree.

Posted: 24/02/2023 8:44:48 p.m. by Gitesh Shah | with 0 comments


XM Cloud - The Operation has timed out

While working locally you might see a 500 error message in XM Cloud development for  "The Operation has timed out".

Posted: 19/02/2023 1:16:20 p.m. by Gitesh Shah | with 0 comments


Sitecore: Find items with uppercase URLs

Sitecore: Find items with uppercase URLs.

Posted: 12/02/2023 8:45:58 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to create a Sitemap from Sitetree

With this powershell command you will be to create a Sitemap from Sitetree

Posted: 12/12/2022 1:38:22 a.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find all components / renderings added on an item in Sitetree

With this powershell command you will be to find all components / renderings added on an item in Sitetree.

Posted: 10/12/2022 1:54:41 a.m. by Gitesh Shah | with 0 comments


Sitecore Symposium Recap 2022

Coming Soon...

Posted: 19/11/2022 4:26:32 p.m. by Gitesh Shah | with 0 comments


Sitecore: Delete XDB/XConnect collection data from Shard tables

Delete XDB/XConnect collection data from Shard tables based on last modified dates.

Posted: 19/11/2022 3:58:13 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to get a unique list of components used on pages.

With this powershell command you will be to get a unique list of components used on pages.

Posted: 20/10/2022 5:25:47 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find a link in content tree

With this powershell command you will be to  find a link in content tree.

Posted: 16/10/2022 5:06:25 p.m. by Gitesh Shah | with 0 comments


Sitecore User group Auckland Meet up - September 2022

Few people from Auckland have travelled to Melbourne for SUGCON ANZ 2022. This usergroup session was to share the learnings from SUGCON ANZ 2022.

Posted: 30/09/2022 4:14:10 p.m. by Gitesh Shah | with 0 comments


XDB : experience profile not getting data

Our experience profile will not show any data. 

Posted: 23/09/2022 1:49:19 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to rebuild SXA optimized min files

With this powershell command you will be to rebuild SXA optimized min files.

Posted: 6/09/2022 3:01:58 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find circular references of items in your content tree.

With this powershell command you will be to find circular references of items in your content tree.

Posted: 30/08/2022 8:39:42 p.m. by Gitesh Shah | with 0 comments


SUGCON ANZ 2022: Go live with Sitecore, Docker & Kubernetes

Go live with Sitecore, Docker & Kubernetes.

Posted: 29/08/2022 1:01:30 a.m. by Gitesh Shah | with 0 comments


Disable Commerce Server in Sitecore

Issue:

Sitecore Commerce server doesn't work in local environment even after applying the hotfix patch for windows.



Posted: 13/08/2022 1:57:53 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to get all items from sitetree

With this powershell command you will be to get all items from sitetree and export it into Excel.

Posted: 3/08/2022 1:57:58 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to replace the layout of items in site tree

With this powershell command you will be to replace layout of items in site tree.

Posted: 19/07/2022 5:45:23 p.m. by Gitesh Shah | with 0 comments


Sitecore: Worklfow State Update

With this powershell command you will be to update the workflow state of an item in Sitecore content tree.

Posted: 13/07/2022 5:36:20 p.m. by Gitesh Shah | with 0 comments


Commerce server not getting data in reporting

Commerce reports in Experience Analytics is missing.

Posted: 10/07/2022 1:49:29 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find the size of the media library item

With this powershell command you will be to find the size of the media library item.

Posted: 3/07/2022 3:35:08 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to copy items within Site tree

With this powershell command you will be able to copy any site tree items to another path.

Posted: 24/06/2022 6:46:04 p.m. by Gitesh Shah | with 0 comments


Sitecore: Find special characters through all rendering components

With this powershell command you will be to find special characters through all rendering components.

Posted: 22/06/2022 5:35:04 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to get all items with specific rendering component

With this powershell command you will be to get all items with specific rendering component.

Posted: 17/06/2022 1:53:18 p.m. by Gitesh Shah | with 0 comments


Commerce Server Microsoft.CommerceServer.Internal.ContentListHelper.dll Issue

Issue:

Siteore commerce server reference the 32 bit dll file instead of 64 bit dll, the following exceptions occur when opening Bunnings website.



Posted: 15/06/2022 1:51:43 p.m. by Gitesh Shah | with 0 comments


Filtering XDB traffic

Filter out some of the urls so they don't get recorded in XDB

Posted: 8/06/2022 1:50:04 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to remove a rendering from sitecore item.

With this powershell command you will be to remove a rendering from sitecore item.

Posted: 1/06/2022 5:31:30 p.m. by Gitesh Shah | with 0 comments


Sitecore: Get values from the Search database

Get values from the SOLR/Lucene Search database.

Posted: 27/05/2022 2:56:29 p.m. by Gitesh Shah | with 0 comments


Sitecore: Get visits, views and contacts from SQL

By running this SQL query you will be able to get the vistis, page views and contacts from XDB database.

Posted: 17/05/2022 2:40:37 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to create a new item in sitetree

With this powershell command you will be to create a new item in sitetree.

Posted: 17/05/2022 1:30:32 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find a user in sitecore

With this powershell command you will be to find a user in sitecore.

Posted: 12/05/2022 3:28:21 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query toget all the components with missing datasources in WEB DB

With this powershell command you will be to get all the components with missing datasources in WEB DB.

Posted: 10/05/2022 3:47:56 p.m. by Gitesh Shah | with 0 comments


Sitecore: MongoDB queries for interactions table

In this blog , you will find all the MongoDb queries I have used to get data from the interactions table.

Posted: 8/05/2022 4:35:07 p.m. by Gitesh Shah | with 0 comments


XDB lagging to get reporting data

Our production website was getting more than 2 million hits per day. This started to cause delays in getting data into our Reporting DB. 

Posted: 6/05/2022 1:05:46 a.m. by Gitesh Shah | with 0 comments


Sitecore: SQL query to get item with workflow history with comments

Sitecore: SQL query to get item with workflow history with comments

Posted: 5/05/2022 9:20:58 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to create a report of large media files

With this powershell command you will be to find large media sizes

Posted: 27/04/2022 5:28:19 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find item list field which has non guid value in link

With this powershell command you will be to find item list field which has non guid value in link.

Posted: 23/04/2022 5:25:37 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find all cached vs non-cached rendering components

In this blog you will find all cached vs non-cached rendering components with the help of powershell query

Posted: 14/04/2022 5:13:39 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to find the cache settings for all cached components/renderings

With this powershell query you will be able to find the cache settings for all cached components/renderings.

Posted: 7/04/2022 5:19:21 p.m. by Gitesh Shah | with 0 comments


Sitecore: Powershell query to Add a new user in CMS

With this powershell command you will be to Add a new user in CMS.

Posted: 1/04/2022 5:22:15 p.m. by Gitesh Shah | with 0 comments


SUGCON ANZ 2019 - Accelerate your development team with Docker

SUGCON ANZ 2019 - Accelerate your development team with Docker

Posted: 9/03/2022 12:02:18 a.m. by Gitesh Shah | with 0 comments


Sitecore: Breakthrough the Personalisation barrier

Wellington Sitecore user group: Breakthrough the Personalisation Barrier – 5 Things You can Do Tomorrow to JumpStart Personalisation

Posted: 15/02/2022 11:37:52 p.m. by Gitesh Shah | with 0 comments