========================2020-04-09 11:13:50======================== noteurl_start parm_app_code = 039 parm_pc_name = SEC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E9B818760DB186A sCDKey = 492587944938 sName = SEC ========================2020-04-09 11:13: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 = '492587944938' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-09 11:13:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cartelo88' ========================2020-04-09 11:13:51======================== SELECT idx FROM macs WHERE mac_addr = '54880E9B818760DB186A' AND app_code = '039' ========================2020-04-09 11:13:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315006' ========================2020-04-09 11:13:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315006' ========================2020-04-09 11:13:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315006', '54880E9B818760DB186A', '039', 'SEC', '110', '1366', '768', 'cartelo88', '자연뜰애 영농조합법인[양동민]', '492587944938' ) ========================2020-04-09 12:05:49======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-AGSAMG6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D02788755388521F61B1 sCDKey = 901683225720 sName = DESKTOP-AGSAMG6 ========================2020-04-09 12:05:49======================== 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 = '901683225720' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-09 12:05:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjretail' ========================2020-04-09 12:05:49======================== SELECT idx FROM macs WHERE mac_addr = 'D02788755388521F61B1' AND app_code = '046' ========================2020-04-09 12:05:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315015' ========================2020-04-09 12:05:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315015' ========================2020-04-09 12:05:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315015', 'D02788755388521F61B1', '046', 'DESKTOP-AGSAMG6', '110', '1920', '1080', 'sjretail', '(주)에스제이리테일[김선재]', '901683225720' ) ========================2020-04-09 13:29:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QDRN3M4 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 768 parm_user_mac = 00270E122582929A67BF sCDKey = 341505658679 sName = DESKTOP-QDRN3M4 ========================2020-04-09 13:29:53======================== 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 = '341505658679' AND r.app_code = '039' AND r.app_block = 0 ========================2020-04-09 13:29:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aa8132532' ========================2020-04-09 13:29:53======================== SELECT idx FROM macs WHERE mac_addr = '00270E122582929A67BF' AND app_code = '039' ========================2020-04-09 13:29:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315022' ========================2020-04-09 13:29:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315022' ========================2020-04-09 13:29:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315022', '00270E122582929A67BF', '039', 'DESKTOP-QDRN3M4', '110', '1280', '768', 'aa8132532', '연수식자재[박창문]', '341505658679' ) ========================2020-04-09 14:38:24======================== noteurl_start parm_app_code = 046 parm_pc_name = 김영민-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F08E72D815922C sCDKey = 714618525075 sName = 김영민-PC ========================2020-04-09 14:38:24======================== 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 = '714618525075' AND r.app_code = '046' AND r.app_block = 0 ========================2020-04-09 14:38:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lfk0011' ========================2020-04-09 14:38:24======================== SELECT idx FROM macs WHERE mac_addr = '00190F08E72D815922C' AND app_code = '046' ========================2020-04-09 14:38:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '315032' ========================2020-04-09 14:38:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '315032' ========================2020-04-09 14:38:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '315032', '00190F08E72D815922C', '046', '김영민-PC', '90', '1024', '768', 'lfk0011', '(주)라이프코리아[김상운]', '714618525075' ) ========================2020-04-09 14:38:38======================== noteurl_start parm_app_code = 046 parm_pc_name = 김영민-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F08E72D815922C sCDKey = 714618525075 sName = 김영민-PC ========================2020-04-09 14:38:38======================== 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 = '714618525075' AND r.app_code = '046' AND r.app_block = 0