Skip to content

Instantly share code, notes, and snippets.

@harshbaid

harshbaid/Sitecore.Geolocation.SQLQuery.sql

Created February 17, 2023 16:24
Show Gist options
  • Save harshbaid/d30d1e9068d14c59a457c187b94ab5c5 to your computer and use it in GitHub Desktop.
Save harshbaid/d30d1e9068d14c59a457c187b94ab5c5 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query to see processed locations data in Sitecore analytics
Raw
Sitecore.Geolocation.SQLQuery.sql
select count(*) from [xdb_processing_pools].[InteractionLiveProcessingPool]
select * from [xdb_processing_pools].[InteractionLiveProcessingPool]
select top 10 * from [cad_prod_Xdb.Collection.Shard0].[xdb_collection].InteractionFacets order by LastModified desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment