Message Count

Question

Question

Farman Ullah · Mar 4

Looking for a SQL query or any other method to find the Unique/distinct message counts for all productions or at least per production namespace within a given time frame. For e.g TimeCreated = January 2025 (Whole month)

I have used the following, but its not restricting the numbers based on the TimeCreated filter. Every time a new message is processed by system, its added to the total. I am running the query in today's date

Select Sum(MsgCount)

From

(Select DISTINCT TargetConfigName, count(DISTINCT SessionID) as MsgCount

FROM ENS.MessageHeader

Where TimeCreated >='2025-01-01 00:00:00' and TimeCreated<='2025-01-31 23:59:59'

Group By TargetConfigName) as Table

Product version: Caché 2018.1

$ZV: 2018.1.8 Cache for Windows

Discussion (5)2

Log in or sign up to continue

Enrico Parisi · Mar 4

select count(*) from (
select SessionId
from Ens.MessageHeader
where TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'
group by SessionId
)

2 0

score 0 · Answer 1 · 2025-03-04T03:01:45-05:00

Enrico Parisi · Mar 4

Can you please define "Unique/distinct message counts"?

0 0

score 0 · Answer 2 · 2025-03-04T09:34:02-05:00

Farman Ullah · Mar 4

distinct session ids

0 0

score 0 · Answer 3 · 2025-03-05T00:57:43-05:00

Farman Ullah · Mar 5

Thank you @Enrico Parisi
:-)

0 0

score 1 · Answer 4 · 2025-03-05T18:49:43-05:00

Well...if fact, a better query would be:

select count(DISTINCT SessionId)
from Ens.MessageHeader
where TimeCreated between '2025-02-01 00:00:00' and '2025-02-28 23:59:59'

Note: while the query is different, it ends running pretty much the same code as the previous query, but I like this better 😊