How do you identify junk vendor records in the core_company table?

[Deebika]

Hi Team,

We are reviewing vendor records in the core_company table and have identified several suspicious entries such as:

• Person names
• Hardware model numbers (e.g., KBG40ZNS128G)
• HTML/CSS/JavaScript text
• Copyright strings (e.g., "2023 ABBYY Development, Inc. All rights reserved")
• Generic values like "empty", "(none)", "-1"

We would like to understand the best practice for identifying and cleaning up junk vendor records.

Could you please share:

1. How do you distinguish between valid and junk vendor records in core_company?
2. Are there any OOTB reports, scripts, or articles available for vendor data quality cleanup?
3. How do you trace the source creating these records (Discovery, integrations, imports, MID Server, custom scripts, etc.)?
4. Before deleting records, what reference checks do you typically perform?

Any recommendations or experiences with vendor cleanup in core_company would be greatly appreciated.

Thank you.