This article from InSource includes example query for the entity count in the Wonderware MES database.
- Author: Joseph Hefner
- Published: 07/17/2019
- Applies to: MES 2014 and above
The queries below will display how many licenses are currently in use. This will help when trying to determine the number of licenses needed for the system.
- Open SQL Server Management Studio and execute the query below to retrieve the Operations count:
Select count(*) from ent where can_run_jobs = 'true' or can_sched_jobs = 'true'
- The query below will return the performance count:
Select count(*) from ent where can_capture_util = 'true'