Following the Sitecore documentation, if Sitecore.Analytics.Lookups.IpHashProvider is set then the IP addresses will be in hashed. My configuration file contains value as below:

<add name="default" salt="f54RYb4RT4ylVC" type="Sitecore.Analytics.Lookups.IpHashProvider, Sitecore.Analytics" />

But if I query my database using the following query:

SELECT InteractionId, LastModified, IpAddress, Country, City, Latitude, Longitude
  FROM [Prod_Xdb.Collection.Shard0].[xdb_collection].[InteractionFacets]

    with (
      IpAddress nvarchar(max) N'$.IpAddress', 
      Country nvarchar(max) N'$.Country', 
      City nvarchar(max) N'$.City', 
      Latitude nvarchar(max) N'$.Latitude', 
      Longitude nvarchar(max) N'$.Longitude'                     

  WHERE FacetKey = 'IpInfo'

Then I can see the ip addresses stored in clear text, data such as which is not hashed.

Is there a different configuration that needs to be set?

  • are you getting all the data like this or some data like this? Sep 17 '19 at 7:09
  • External PII Ip will be hashed. This looks like internal communication inside your solution.
    – Mark Cassidy
    Sep 17 '19 at 7:48
  • Yes all the IP are shown in clear text.
    – tpkphani
    Sep 20 '19 at 10:44

I have asked Sitecore the same question and their answer as below:

In the InteractionFacets table of collection database, the real IPs are stored when Analytics.RedactIpAddress setting is set to false and the IPs are stored when the setting is set to true.
The hashed IPs are stored in the ReferenceData database. In the ReferenceData database, they are always hashed. Unfortunately, the article that you refer is not mentioned that. I've made a request to correct it. Thank you for reporting that. Actually, In Sitecore 8 there was the same logic but - https://doc.sitecore.net/sitecore_experience_platform/82/setting_up_and_maintaining/xdb/contacts/ip_address_hashing*

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.