This might better explain what I'm seeing or not understanding:

SELECT DATEADD(hh, -1, GETDATE()) as OnlyAfterThisDate, MIN(TimeCreated) as FirstDate, MAX(TimeCreated) as LastDate FROM ens.messageheader WHERE TimeCreated > DATEADD(hh, -1, GETDATE());

SELECT DATEADD(hh, -1, GETUTCDATE()) as OnlyAfterThisDate, MIN(TimeCreated) as FirstDate, MAX(TimeCreated) as LastDate FROM ens.messageheader WHERE TimeCreated > DATEADD(hh, -1, GETUTCDATE());

Changing my queries to GETUTCDATE() did seem to fix the issue but I still don't understand why.   ¯\_(ツ)_/¯

I don't see this option in DBVisualizer.

I'm not exactly sure what you're asking, but this is the definition in the ens.messageheaderbase class:

Property TimeCreated As Ens.DataType.UTC

I was referring to our local documentation.  I can't find the reference document.  Perhaps it's a version difference.

Is the "Newest" sorting issue the same cause?  Or are you at least aware of it too?

I'll try to restrain myself :)

I'm simply fumbling around in my never ending quest to find holistic queries that answer basic questions.  Right now I'm querying the registry.  I don't have SQL access to the buses or hsaccess and we have dozens of edges so that isn't convenient  Since the ATNA log is 600+ million rows and takes hours and hours to query (and decypher), HSREG is really my only option.

Looks like it's something to do with our custom consent.  I don't completely understand it, but if I limit the SourceConfigName to HS.Hub.MPIManager it obviously eliminates the duplicates.

Very good info, thanks!  However,

"Missing or Invalid Document"

also

"No matches were found for HEOV_architecture (.000429s)"

Good to hear ;)

I think that is the literal meaning but I'm wondering what it means functionally, what triggers this "mode".

edit: obviously the answer is "Pix or PDQ events", I guess I'm just trying to understand this table better.  I'm not really sure what answer I'm looking for.

It looks  like "ExportRecords" coincides with an external request and "ViewRecords" is a clinical viewer request.

We are an HIE so I cannot simulate a search from within an EHR system.

Can you think of anything I could query on the Registry to do this?  Something endpoint-agnostic?  For instance, I've discovered this seems to work pretty well for searches without having to worry about ATNA event types and the performance issues related to the size:

SELECT TimeProcessed, LastName, FirstName, DOB, AssigningAuthority, MPIID, MRN, SearchMode, RequestingUser, SAMLData_Organization, SessionId
FROM Ens.MessageHeader h LEFT JOIN HS_Message.PatientSearchRequest m
ON h.MessageBodyId = m.id
WHERE h.Invocation = 1
AND h.MessageBodyClassName = 'HS.Message.PatientSearchRequest'
ORDER BY SessionId DESC

I appreciate your input so far.

"The combined results are about to be loaded into the clinical viewer."

What about searches from directly within participant EHR systems?   Users that are not using the clinical viewer? ie "on demand" customers.  Or other protocols, XDSb, XCA, etc.  Also would this exclude patient searches like a PIX query before a document registration?

Ahhh, thanks.

What about the date format? Can you confirm that it's only looking for YYYYMMDD?