OK. Thank you all.
I'm trying to use the query:
select nimid, min (time) as init_time, max(time) as end_time, source, message FROM [uim].[dbo].[NAS_TRANSACTION_LOG] where
time >= dateadd(d, datediff(d, 0, getdate())-2, 0) and source like 'http%' group by nimid, source, message
order by init_time
It seems the NAS_TRANSACTION_LOG has multiple rows for each alarm ID, so I had to use min and max time. In this case I'm getting the alarms for the past 2 days (plus today).
Does this make sense?
I can't get the probe name (prid) on this table...