ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Origin of the timestamp for _eventTime column in multiple SMP database tables
book
Article ID: 150120
calendar_today
Updated On:
Products
IT Management SuiteClient Management Suite
Issue/Introduction
Question: There is an “_eventTime” column scattered amongst SMP Core and solution tables. Where is this timestamp populated from?
Environment
ITMS 7.x, 8.x
Resolution
Answer: This column is populated "when the data loader on the NS processes the message (usually NSEs)", which means, the time on the SMP server.