Page 1 of 1
Workstations running Open Dental
Posted: Wed Oct 12, 2016 4:00 pm
by SMathew
Is there a query available to find out which workstations on the network still have OD running? "Tools, Misc Tools, Shutdown All work Stations" options will not work since it requires higher security. It is really important that I gracefully close all OD before the back up is done. Is there a solution available for this?
Re: Workstations running Open Dental
Posted: Wed Oct 12, 2016 4:09 pm
by jsalmon
Getting someone to run the "Shutdown All Workstations" tool is the correct way to do this.
However, each active workstation will have a "heartbeat" which the following query will show you the computer names along with their last heartbeat to Open Dental.
Code: Select all
SELECT CompName,LastHeartBeat FROM computer ORDER BY LastHeartBeat DESC
http://www.opendental.com/manual/queryrun.html