The GoldMine Blog - Tips, Tricks & More

Ever wonder how many primary contacts, secondary contacts, or history items you have in your GoldMine database?

Here are three simple SQL Queries to give you an answer!

First, go to Lookup | SQL Queries or Go To | Filters & Groups | SQL Queries Tab in GoldMine Premium Edition.  Copy and paste the queries into the top half of the screen then click the Query button.

 
For a count of primary contacts:

Select count(*) from contact1  

For a count of secondary contacts:

Select count(*) from contsupp where rectype = 'C'

For a count of history records:

Select count(*) from conthist