Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To check STREAMCOUNT validation: 

1.From Eagle Home Go toSystem management Center.

2. Go to Diagnostics from the left panel.Image Removed

...

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
Code Block
languagejsfirstline1
titleStream 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 theRun Query on the top.