We are on Sitecore 8.2 rev. 170614 (8.2 Update-4) using MongoDB On-Premise mode with custom SSL Setup.
Need to submit a custom report to business based on various logins (and related data) categorized by GeoIP Location.
Since in xDB the IPs are stored in Mongo only not in SQL Reporting Database, how we can consolidate both data and create a report.
Though we are working on creating MongoDB script for the same but in the Phase-2 we need to fetch data from Client's Legacy Database which is again on SQL.