GoldMine Administrators who have to manage remote GoldMine users and support their GoldSync database synchronization may like this handy SQL query. The following SQL query will list all of your undocked users and sync sites, along with the date of their most recent sync:
select sname as Site, convert(varchar(20), cast(left(lastsync,8) as datetime),101) as LastSyncDate
from gssites
where rectype = ‘S’
and synctype <> ‘OG’
order by sname
If you need assistance with implementing, supporting, or troubleshooting GoldSync First Direct Corp. can be reached at 845-221-3800.
