We only want to display data for domains whose IP is directly attributable to a user provided CIDR. We only want this functionality for non-FCEB organizations.
Add new column to Domains table called "fromCyhyCidr", which will be a boolean for if the domains ip links to a cidr provided to VS
Create a helper function that accepts an organization_id and an ip and returns true if the ip is found inside a cidr block owned by the given org, it will check this against the cidr table in the mini datalake that is updated daily from the VS data in the AE
We will make a crossfeed scan that loops through all domains and runs the ips through the newly created helper function and correctly checks the "fromCyhyCidr" column
Update the api calls that pull domains to filter out domains where "fromCyhyCidr" is false
๐ญ Motivation and context
This is to avoid reporting issues with IPs that belong to cloud providers and incorrectly attributed domains
๐งช Testing
I have tested locally with both in-cidr and out-cidr ips as well as on fceb and non fceb organizations
โ Pre-approval checklist
[X] This PR has an informative and human-readable title.
[X] Changes are limited to a single goal - eschew scope creep!
[X] All future TODOs are captured in issues, which are referenced
in code comments.
[X] All relevant type-of-change labels have been added.
๐ฃ Description
We only want to display data for domains whose IP is directly attributable to a user provided CIDR. We only want this functionality for non-FCEB organizations.
๐ญ Motivation and context
This is to avoid reporting issues with IPs that belong to cloud providers and incorrectly attributed domains
๐งช Testing
I have tested locally with both in-cidr and out-cidr ips as well as on fceb and non fceb organizations
โ Pre-approval checklist
โ Pre-merge checklist
โ Post-merge checklist