...
To check STREAMCOUNT validation:
1.From Eagle Home Go toSystem 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
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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.