Vantagepoint Custom Report: SCG Deep Scan

For the Administrator & Power User

Don't just find the data—understand it.

• Find Anything: Search for a partial name, number, or code, and we scan the entire system to find it.

• Get the Context: Alongside your search results, the report displays the official descriptions for that specific table and column. You don't just see where the data is; you learn what it does.

• Solve Problems Faster: Whether you are tracking down a "ghost" record or auditing strange data, you get the full picture (Location + Definition) in one view.

For the SQL Developer & Technical Lead

A Self-Documenting Global Search Engine.

When performing forensic data analysis, finding the string is only half the battle. You also need to understand the intent of the schema where that string resides. This tool bridges the gap between raw data and system documentation.

Technical Specifications:

• Integrated Data Dictionary: The report cross-references the system’s metadata to pull in the official schema definition for every result. It returns the Table Description and Column Purpose alongside the raw data match.

• Universal String Search: Dynamically iterates through all database tables and columns to locate values, regardless of data type.

• Context-Aware Debugging: ideal for new developers or consultants who are navigating an unfamiliar Vantagepoint environment. It eliminates the need to constantly switch between SSMS and the Help files.

• Execution Expectation: A full deep-dive scan typically takes 5–10 minutes, prioritizing completeness and context over speed.

⚠️ Important Security Notice

Administrator Access Only Recommended This report is extremely powerful and is designed to bypass standard screen-level security filters to ensure a complete search. This means it may return results (and descriptions) from sensitive areas like Payroll or HR. We strongly recommend limiting access to this report to System Administrators or highly trusted Data Managers.

Here is an example out put from a client database: