Require a report to show when a Primary Mailing Address is missing in the system

Summary

It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing address is not there

Content

Hi All,

I hope this is an easy request. I have built a report that shows an employee's mailing address but I haven't figured out how to determine if the address is a primary address (or how to tell if one is missing)

My query uses per_addresses_f and per_person_addr_ussages_f but I haven't figured out how to retrieve those employees that don't have a primary record (see attached image)