carl-parrish

Checking prerequisites...
	Checking mgmt port [8089]: open
	Checking conf files for problems...
	Done
All preliminary checks passed.

Starting splunk server daemon (splunkd)...  
Declared role=universal_forwarder.
Done

carl-parrish

[cparrish@sftp ~]$ sudo yum update
Loaded plugins: amazon-id, rhui-lb, security
Zend                                                                                                                                                               |  951 B     00:00     
Zend/primary                                                                                                                                                       |  26 kB     00:00     
Zend                                                                                                                                                                              145/145
Zend_noarch                                                                                                                                                        |  951 B     00:00     
Zend_noarch/primary                                                                                                                                                | 2.9 kB     00:00     
Zend_noarc

carl-parrish

MERGE INTO mp_users_plans Data
      USING bckup_mp_usr_plan Source
         ON Data.id = Source.id
               AND Source.date < ‘<today>’ AND thm_order_id != ‘0'
 WHEN MATCHED THEN
      UPDATE
           SET thm_order_id = Source.thm_order_id;