Workstations running Open Dental

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
SMathew
Posts: 6
Joined: Mon Jul 09, 2012 10:36 am

Workstations running Open Dental

Post by SMathew » Wed Oct 12, 2016 4:00 pm

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?

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Workstations running Open Dental

Post by jsalmon » Wed Oct 12, 2016 4:09 pm

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
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply