Log into SCCM and click on query and create this query to find broken SMS clients

(
System Resource.Client is equal to 0
or
System Resource.Client is Null
or
System Resource.Agent site is not equal to “D80”
)
and
System Resource.Operating System Name and Version is like “microsoft%”
and
System Resources.SMS Assigned Sites is not Null