Managing Configuration Items › Manage Staged Transactions › Populating the TWA › How to Use SQL to Update Data into the TWA › How to Share Tables with CA SDM

How to Share Tables with CA SDM

SQL Server Only

When using SQL to update the ci_twa_ci and ci_twa_relation tables, set the last_mod_dt column manually, as follows:

       SET last_mod_dt = DATEDIFF(s,'19700101', GETUTCDATE())

Example: Set last_mod_dt

The following example sets the last_mod_dt:

UPDATE ci_twa_ci
	SET tran_status=1,
		last_mod_dt = DATEDIFF(s,'19700101', GETUTCDATE())
	WHERE tran_status=1

Note: TWA table updates can take several minutes to appear in the web interface or GRLoader. For more information about update timing, see the NX_DBMONITOR_TIMER_MINUTES option.