Skip to content

Instantly share code, notes, and snippets.

@blakedrumm

blakedrumm/Identify-BrokenAgent.sql

Created June 15, 2023 16:18
Show Gist options
  • Save blakedrumm/361b35c1bd215ee599e9c7e63d824f45 to your computer and use it in GitHub Desktop.
Save blakedrumm/361b35c1bd215ee599e9c7e63d824f45 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Identify-BrokenAgent.sql
select *
from BaseManagedEntity BME
LEFT JOIN TypedManagedEntity TME
ON BME.BaseManagedEntityId = TME.TypedManagedEntityId
where TME.BaseManagedEntityId IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment