identify records created or updated by particular user

Hi,

Given that there's no field found on devices and many other OOTB records about which user created or last updated the records, but this information is captured in the History. 

What's the way to query records updated by a particular user?

We have several integrations running to sync data in SMAX and it seems nearly impossible to find out which records are updated by a particular integration user unless a customisation is introduced in all the tables to start recording the created by and updated by user.

Can we query the History table in relation to the record to get to the intended result or any other design thoughts put in place in SMAX to get to the intended outcome via different way of working?

I am speaking for myself and not for OpenText

Tags: