========================2018-02-20 13:12:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J45M42Q parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C8751E39EFB0415 sCDKey = 068285109570 sName = DESKTOP-J45M42Q ========================2018-02-20 13:12:14======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '068285109570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-20 13:12:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aseman01' ========================2018-02-20 13:12:14======================== SELECT idx FROM macs WHERE mac_addr = '408D5C8751E39EFB0415' AND app_code = '039' ========================2018-02-20 13:12:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242415' ========================2018-02-20 13:12:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242415' ========================2018-02-20 13:12:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242415', '408D5C8751E39EFB0415', '039', 'DESKTOP-J45M42Q', '110', '1920', '1080', 'aseman01', '(주)아세만[성종관]', '068285109570' ) ========================2018-02-20 14:19:23======================== noteurl_start parm_app_code = 050 parm_pc_name = A410U7DZZM9KM89 parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 4437E678CCC75E70EA9E sCDKey = 930299701676 sName = A410U7DZZM9KM89 ========================2018-02-20 14:19:23======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '930299701676' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:19:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pasaba' ========================2018-02-20 14:19:23======================== SELECT idx FROM macs WHERE mac_addr = '4437E678CCC75E70EA9E' AND app_code = '050' ========================2018-02-20 14:19:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '63082' ========================2018-02-20 14:19:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '63082' ========================2018-02-20 14:19:23======================== UPDATE mac_detail SET pc_name = 'A410U7DZZM9KM89', os_type = '90', user_id = 'pasaba', user_name = 'HSBC은행[박상배]', screen_w = '1680', screen_h = '1050', cdkey = '930299701676' WHERE mac_idx = '63082' ========================2018-02-20 14:23:57======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7EOP3PP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AFAEACEB7ECB2D0 sCDKey = 167939624681 sName = DESKTOP-7EOP3PP ========================2018-02-20 14:23:57======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '167939624681' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:23:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'phmaster' ========================2018-02-20 14:23:57======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8AFAEACEB7ECB2D0' AND app_code = '050' ========================2018-02-20 14:23:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242407' ========================2018-02-20 14:23:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242407' ========================2018-02-20 14:23:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242407', 'D8CB8AFAEACEB7ECB2D0', '050', 'DESKTOP-7EOP3PP', '109', '1920', '1080', 'phmaster', '(주)마스터시스템[김진학]', '167939624681' ) ========================2018-02-20 14:24:20======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7EOP3PP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AFAEACEB7ECB2D0 sCDKey = 167939624681 sName = DESKTOP-7EOP3PP ========================2018-02-20 14:24:20======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '167939624681' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:24:50======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7EOP3PP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AFAEACEB7ECB2D0 sCDKey = 167939624681 sName = DESKTOP-7EOP3PP ========================2018-02-20 14:24:50======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '167939624681' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:25:59======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7EOP3PP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AFAEACEB7ECB2D0 sCDKey = 167939624681 sName = DESKTOP-7EOP3PP ========================2018-02-20 14:25:59======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '167939624681' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:26:20======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7EOP3PP parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8AFAEACEB7ECB2D0 sCDKey = 167939624681 sName = DESKTOP-7EOP3PP ========================2018-02-20 14:26:20======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '167939624681' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:26:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'phmaster' ========================2018-02-20 14:26:20======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8AFAEACEB7ECB2D0' AND app_code = '050' ========================2018-02-20 14:26:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242407' ========================2018-02-20 14:26:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242407' ========================2018-02-20 14:26:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-7EOP3PP', os_type = '109', user_id = 'phmaster', user_name = '(주)마스터시스템[김진학]', screen_w = '1920', screen_h = '1080', cdkey = '167939624681' WHERE mac_idx = '242407' ========================2018-02-20 14:46:42======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00E09154B577F86E8EDD sCDKey = 452775506015 sName = ========================2018-02-20 14:46:42======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:46:52======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00E09154B577F86E8EDD sCDKey = 452775506015 sName = ECS ========================2018-02-20 14:46:52======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:46:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ecstel' ========================2018-02-20 14:46:52======================== SELECT idx FROM macs WHERE mac_addr = '00E09154B577F86E8EDD' AND app_code = '050' ========================2018-02-20 14:46:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242082' ========================2018-02-20 14:46:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242082' ========================2018-02-20 14:46:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '242082', '00E09154B577F86E8EDD', '050', 'ECS', '109', '1600', '900', 'ecstel', '(주)이씨에스텔레콤[유지해]', '452775506015' ) ========================2018-02-20 14:46:59======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00E09154B577F86E8EDD sCDKey = 452775506015 sName = ECS ========================2018-02-20 14:46:59======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '452775506015' AND r.app_code = '050' AND r.app_block = 0 ========================2018-02-20 14:47:05======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 109 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00E09154B577F86E8EDD sCDKey = 452775506015 sName = ECS ========================2018-02-20 14:47:05======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '452775506015' AND r.app_code = '050' AND r.app_block = 0