========================2020-06-29 09:38:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CEVTKBE parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 800 parm_user_mac = D050990547C8B81D0F77 sCDKey = 339466362279 sName = DESKTOP-CEVTKBE ========================2020-06-29 09:38: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 = '339466362279' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-29 09:38:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn3124' ========================2020-06-29 09:38:21======================== SELECT idx FROM macs WHERE mac_addr = 'D050990547C8B81D0F77' AND app_code = '039' ========================2020-06-29 09:38:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320648' ========================2020-06-29 09:38:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320648' ========================2020-06-29 09:38:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320648', 'D050990547C8B81D0F77', '039', 'DESKTOP-CEVTKBE', '110', '1280', '800', 'jn3124', '영진수출포장[엄장영]', '339466362279' ) ========================2020-06-29 09:40:04======================== noteurl_start parm_app_code = 047 parm_pc_name = TI parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E99F68F9DE4088528 sCDKey = 042677545519 sName = TI ========================2020-06-29 09:40:04======================== 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 = '042677545519' AND r.app_code = '047' AND r.app_block = 0 ========================2020-06-29 09:40:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'skp3522' ========================2020-06-29 09:40:04======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99F68F9DE4088528' AND app_code = '047' ========================2020-06-29 09:40:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320622' ========================2020-06-29 09:40:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320622' ========================2020-06-29 09:40:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320622', 'B42E99F68F9DE4088528', '047', 'TI', '�쐢�룄�슦 10', '0', '0', 'skp3522', '서광도장건설[이민숙]', '042677545519' ) ========================2020-06-29 10:06:54======================== noteurl_start parm_app_code = 048 parm_pc_name = AONEPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D26DB59D18FA2D0 sCDKey = 316592127001 sName = AONEPC ========================2020-06-29 10:06:54======================== 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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-29 10:06:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-29 10:06:54======================== SELECT idx FROM macs WHERE mac_addr = '18C04D26DB59D18FA2D0' AND app_code = '048' ========================2020-06-29 10:06:54======================== 값이 없을 경우 ========================2020-06-29 10:07:52======================== noteurl_start parm_app_code = 048 parm_pc_name = AONEPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D26DB59D18FA2D0 sCDKey = 316592127001 sName = AONEPC ========================2020-06-29 10:07: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 = '316592127001' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-29 10:07:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-29 10:07:52======================== SELECT idx FROM macs WHERE mac_addr = '18C04D26DB59D18FA2D0' AND app_code = '048' ========================2020-06-29 10:07:52======================== 값이 없을 경우 ========================2020-06-29 10:08:34======================== noteurl_start parm_app_code = 048 parm_pc_name = AONEPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D26DB59D18FA2D0 sCDKey = 735701544748 sName = AONEPC ========================2020-06-29 10:08:34======================== 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 = '735701544748' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-29 10:08:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-29 10:08:34======================== SELECT idx FROM macs WHERE mac_addr = '18C04D26DB59D18FA2D0' AND app_code = '048' ========================2020-06-29 10:08:34======================== 값이 없을 경우 ========================2020-06-29 10:09:55======================== noteurl_start parm_app_code = 048 parm_pc_name = 송영훈 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9B7BFA6AF825E sCDKey = 735701544748 sName = 송영훈 ========================2020-06-29 10:09:55======================== 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 = '735701544748' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-29 10:09:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-29 10:09:55======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7BFA6AF825E' AND app_code = '048' ========================2020-06-29 10:09:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '226295' ========================2020-06-29 10:09:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '226295' ========================2020-06-29 10:09:55======================== UPDATE mac_detail SET pc_name = '송영훈', os_type = '�쐢�룄�슦 10', user_id = 'robustmd', user_name = '로부스트엠디[오경숙]', screen_w = '0', screen_h = '0', cdkey = '735701544748' WHERE mac_idx = '226295' ========================2020-06-29 10:29:41======================== noteurl_start parm_app_code = 046 parm_pc_name = HJH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AE60D8075059 sCDKey = 737376171670 sName = HJH-PC ========================2020-06-29 10:29:41======================== 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 = '737376171670' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-29 10:29:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wogus36' ========================2020-06-29 10:29:41======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AE60D8075059' AND app_code = '046' ========================2020-06-29 10:29:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244420' ========================2020-06-29 10:29:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244420' ========================2020-06-29 10:29:41======================== UPDATE mac_detail SET pc_name = 'HJH-PC', os_type = '110', user_id = 'wogus36', user_name = '[황재현]', screen_w = '1920', screen_h = '1080', cdkey = '737376171670' WHERE mac_idx = '244420' ========================2020-06-29 10:35:02======================== noteurl_start parm_app_code = 048 parm_pc_name = AONEPC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18C04D26DB59D18FA2D0 sCDKey = 735701544748 sName = AONEPC ========================2020-06-29 10:35:02======================== 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 = '735701544748' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-29 10:35:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'robustmd' ========================2020-06-29 10:35:02======================== SELECT idx FROM macs WHERE mac_addr = '18C04D26DB59D18FA2D0' AND app_code = '048' ========================2020-06-29 10:35:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320695' ========================2020-06-29 10:35:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320695' ========================2020-06-29 10:35:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320695', '18C04D26DB59D18FA2D0', '048', 'AONEPC', '�쐢�룄�슦 10', '0', '0', 'robustmd', '로부스트엠디[오경숙]', '735701544748' ) ========================2020-06-29 15:13:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RVMNOUC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4880E63586A8318 sCDKey = 548559041511 sName = DESKTOP-RVMNOUC ========================2020-06-29 15:13: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 = '548559041511' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-29 15:14:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhyu7' ========================2020-06-29 15:14:00======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4880E63586A8318' AND app_code = '039' ========================2020-06-29 15:14:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320705' ========================2020-06-29 15:14:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320705' ========================2020-06-29 15:14:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320705', 'BC5FF4880E63586A8318', '039', 'DESKTOP-RVMNOUC', '110', '1920', '1080', 'jhyu7', '진흥유직[이태형]', '548559041511' ) ========================2020-06-29 15:47:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JS7VI1F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982CBCC5BC552A62C2D9 sCDKey = 151317336230 sName = DESKTOP-JS7VI1F ========================2020-06-29 15:47:40======================== 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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-29 15:49:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-JS7VI1F parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 982CBCC5BC552A62C2D9 sCDKey = 151317336230 sName = DESKTOP-JS7VI1F ========================2020-06-29 15:49: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 = '151317336230' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-29 15:49:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yessal' ========================2020-06-29 15:49:23======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC5BC552A62C2D9' AND app_code = '039' ========================2020-06-29 15:49:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320740' ========================2020-06-29 15:49:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320740' ========================2020-06-29 15:49:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320740', '982CBCC5BC552A62C2D9', '039', 'DESKTOP-JS7VI1F', '110', '1920', '1080', 'yessal', '제이에스테크[심재섭]', '151317336230' ) ========================2020-06-29 16:47:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QP4H52H parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E8039A6B1DD91061A948 sCDKey = 095884872865 sName = DESKTOP-QP4H52H ========================2020-06-29 16:47:34======================== 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 = '095884872865' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-29 16:47:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jxlovep1' ========================2020-06-29 16:47:34======================== SELECT idx FROM macs WHERE mac_addr = 'E8039A6B1DD91061A948' AND app_code = '039' ========================2020-06-29 16:47:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '320485' ========================2020-06-29 16:47:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '320485' ========================2020-06-29 16:47:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '320485', 'E8039A6B1DD91061A948', '039', 'DESKTOP-QP4H52H', '110', '1600', '900', 'jxlovep1', '동서울중앙교회[박범종]', '095884872865' )