How to find non distinct/duplicate messages in Azure Application Insights?

In my traces table, I've got messages like so:

Incoming transaction: 0504250624105104 validated
Incoming transaction: 0504250624105604 validated
Incoming transaction: 0504250624105604 validated
Incoming transaction: 0504250624105304 validated

How can I find all non distinct/duplicate messages i.e. so the above returns only the below value?

Incoming transaction: 0504250624105604 validated

Solution

Posting the answer as I mentioned in the comment with details.

How to find non distinct/duplicate messages in Azure Application Insights?

Assuming the messages are stored in the traces table and the column for the message text is named message.

Groups the results by the message column and counts the occurrences of each message. This filters the results to include only those messages where the count is greater than 1, indicating duplicates.

Query:

traces
| summarize count() by message
| where count_ > 1

Sample data:

enter image description here

Result:

enter image description here