Skip to main content
InSource Solutions

TN MES120 How to query for the current entity count in the MES database

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

Description

 

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

Details

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.

  1. Open SQL Server Management Studio and execute the query below to retrieve the Operations count:

    Operations count
    Select count(*) from ent where can_run_jobs = 'true' or can_sched_jobs = 'true'
    Cap1.JPG

 

  1. The query below will return the performance count:

    Performance count
    Select count(*) from ent where can_capture_util = 'true'