Free Disk Space Analyzer

I recently had a customer call in about not being able to save email attachments. Upon investigating the issue it turns out they had run out of disk space on the hard drive that they were storing email attachments on. The hard drive itself was about 500 gigs and it...

SQL Query – Duplicate Contacts

The following SQL Query will display a list of contacts with the same contact name.  You can then browse through the list to see if they are any potential duplicates. Select accountno, contact, company, phone1, city, state From contact1 Where contact in (Select contact from contact1 group by contact having...

SQL Query – Additional GoldMine Contacts E-mail Address and Email Merge Code

The following SQL Query shows all Additional GoldMine Contacts with their Email Address and Email Merge Code: SELECT Company, ac.contact AS 'Additional Contact', COALESCE(em.contsupref, '')+COALESCE(em.address1, '') AS 'Email Address',   em.mergecodes FROM contact1 JOIN contsupp ac on contact1.accountno=ac.accountno JOIN contsupp em on ac.recid=em.linkacct WHERE ac.rectype='c' AND em.contact='E-Mail Address' AND (em.linkacct NOT...

SQL Query – GoldMine Primary Contacts with Primary Email, and Email Merge Code

The following SQL Query will display all of the GoldMine Primary Contacts with their associated Primary Email Address, as well as the Email Merge Code.   select contact1.contact, isnull(contsupp.contsupref,'') + isnull(contsupp.address1,'') as Email, contsupp.mergecodes from contact1 left outer join contsupp on contact1.accountno=contsupp.accountno where contsupp.rectype='P' and contsupp.contact='E-Mail Address' and contsupp.zip like...

Is Your PC Running Slow? Maybe it’s time to DEFRAG!!

Defragging is one of those things – like doing the dishes or picking up the clothes off the floor – that you know you should get around to doing, but for some reason it’s so very difficult to find the time to do. There’s no doubt that it’s important. Yet,...

SQL Query – Possible Missed Follow-ups

The following SQL Query shows who you’ve had a call or appointment with in the last 60 days.   The list generated can then be used to determine who you've followed up with and who you haven't. You can update/modify the query below to show more or less days and don't...

GET LATEST NEWS!