After uploading a building data file, a Teams administrator opens the Missing Subnet Report on the Quality of Experience Reports page in CQD to find managed subnets that were missed. The report returns hundreds of unfamiliar subnets that do not belong to the organization's address space. The organization regularly meets with federated partner organizations. What should the administrator do to make the report actionable?
Correct answer: C. Add a query filter on the Second Tenant ID dimension set to the organization's own tenant ID, because the report otherwise shows federated subnets.
Microsoft Learn's building data guidance is explicit: to filter the Missing Subnet Report to view only your organization's tenant data, you need to add your tenant ID as a query filter for Second Tenant ID; otherwise, the report shows federated subnets. The report presents all subnets with 10 or more audio streams that are not defined in the building data file, and in an environment with heavy federation, partner-tenant subnets flood the list and make it look far worse than it is. Filtering on your own tenant ID narrows results to your unmatched subnets, which are the only ones you can actually add to your building file. Microsoft also recommends adjusting the Month Year filter to the current month.
Why the other options are wrong:
- A. The VPN column triggers full subnet expansion, which degrades query performance and can push the file past the expanded row limit. It flags VPN subnets; it has nothing to do with federated noise in the Missing Subnet Report.
- B. The 10-audio-stream minimum is a deliberate noise filter in the report design. The problem described is too many irrelevant subnets, not too few - lowering the threshold would make the noise worse, and it is not what the documentation prescribes.
- D. Common home subnets are already excluded from the Missing Subnet Report by design. The unfamiliar subnets in this scenario come from federated partner tenants, which the Second Tenant ID filter removes.
Memory hook: Missing Subnet Report shows everyone's subnets by default - filter Second Tenant ID = YOUR tenant, or you're chasing partners' networks.
Microsoft Learn: Cqd upload tenant building data



