In Salesforce Marketing Cloud, this query finds records within the All Subscriber List. The records it finds are those agents designated as "2", as well as a portion of the company name.

FindToExclude.sql

SELECT pde.SubKey AS SubscriberKey, pde.Email AS EmailAddress
FROM AgentDataExtension ade
INNER JOIN PrimaryDataExtension pde ON pde.Agent_Number = ade.AgentNumber
WHERE ade.AgentSettingsID = 2 OR pde.Email LIKE '%company name%'
UNION
SELECT SubscriberKey, EmailAddress
FROM _ListSubscribers
WHERE ListID = 000 AND EmailAddress LIKE ‘%company name%’