How many total history records in your database? Why do you want to know?

select count(*) from conthist

 

Which contacts have the most history?

select company,contact,* from contact1 where accountno in
(
select top 25 accountno from conthist where accountno <> ''
group by accountno
order by count(accountno) desc
)

Obviously, if you'd like to see your top 50 or 100, just edit the "25" accordingly.

 

How many history entries, by user, last 30 days?

select userid,count(accountno) as Count from conthist
where createon > getdate() - 30
group by userid

Find out which salesreps are keeping active (or, at least, which salesreps are using GoldMine according to plan!)