Checking STREAMCOUNT

Stream count checking provides a simple check for the user to identify the streams which were installed or modified by the installation package.

Following steps are methods for the validation:

To check STREAMCOUNT validation:

1.From Eagle Home Go to System management Center.

2. Go to Diagnostics from the left panel.

3. Go to the SQL Query on the left panel paste the below query with the current date on the SQL Queries Column:

Stream Count SQL

select sum(streamcount) from (
select stream_category_1, count(*) streamcount
from (select * from msgcenter_dbo.msg_streams MSG
where update_source = 'MCINSTALL'
  AND TRUNC(UPDATE_DATE) = '07-JAN-2019'  -- Current Date
)
group by stream_category_1)

4. Click on the Run Query on the top.