We are in the process of cleaning up our sites, groups, and schedules and have noticed that some IPs (single or in ranges) have been duplicated over the years. One example may be that there is a region or country specific site, and then later there were sites created by state or physical site location. We want to identify where these overlaps are. I am usually pretty good with SQL, but the logic behind “is this single IP inside of a range of IPs” is beyond my skills.