========================2021-11-01 10:19:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VB795TP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05DE0B5C05AFF570D sCDKey = 513019903755 sName = DESKTOP-VB795TP ========================2021-11-01 10:19:15======================== 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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 10:19:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ghddang292' ========================2021-11-01 10:19:15======================== SELECT idx FROM macs WHERE mac_addr = '2CF05DE0B5C05AFF570D' AND app_code = '039' ========================2021-11-01 10:19:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349228' ========================2021-11-01 10:19:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VB795TP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2CF05DE0B5C05AFF570D sCDKey = 513019903755 sName = DESKTOP-VB795TP ========================2021-11-01 10:19:19======================== 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 = '513019903755' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 10:19:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ghddang292' ========================2021-11-01 10:19:19======================== SELECT idx FROM macs WHERE mac_addr = '2CF05DE0B5C05AFF570D' AND app_code = '039' ========================2021-11-01 10:19:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '349228' ========================2021-11-01 10:19:20======================== ========================2021-11-01 10:19:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '349228' SELECT mac_idx FROM mac_detail WHERE mac_idx = '349228' ========================2021-11-01 10:19:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '349228', '2CF05DE0B5C05AFF570D', '039', 'DESKTOP-VB795TP', '110', '1920', '1080', 'ghddang292', '구커피[이규희]', '513019903755' ) ========================2021-11-01 10:19:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '349228', '2CF05DE0B5C05AFF570D', '039', 'DESKTOP-VB795TP', '110', '1920', '1080', 'ghddang292', '구커피[이규희]', '513019903755' ) ========================2021-11-01 10:24:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GJSVC6V parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A15985CC3112039C8E sCDKey = 243363946844 sName = DESKTOP-GJSVC6V ========================2021-11-01 10:24:00======================== 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 = '243363946844' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 10:24:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjhwan704' ========================2021-11-01 10:24:00======================== SELECT idx FROM macs WHERE mac_addr = 'A8A15985CC3112039C8E' AND app_code = '039' ========================2021-11-01 10:24:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352170' ========================2021-11-01 10:24:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352170' ========================2021-11-01 10:24: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 ( '352170', 'A8A15985CC3112039C8E', '039', 'DESKTOP-GJSVC6V', '110', '1920', '1080', 'pjhwan704', '대성상사[박종환]', '243363946844' ) ========================2021-11-01 13:12:57======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J67DM34 parm_os_type = 110 parm_screen_w = 1418 parm_screen_h = 798 parm_user_mac = CAFF221B5E95FE2ADF7E sCDKey = 747413241531 sName = DESKTOP-J67DM34 ========================2021-11-01 13:12: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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-01 13:12:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'damurak' ========================2021-11-01 13:12:57======================== SELECT idx FROM macs WHERE mac_addr = 'CAFF221B5E95FE2ADF7E' AND app_code = '046' ========================2021-11-01 13:12:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353442' ========================2021-11-01 13:12:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353442' ========================2021-11-01 13:12:57======================== UPDATE mac_detail SET pc_name = 'DESKTOP-J67DM34', os_type = '110', user_id = 'damurak', user_name = '섬지친환경원예사[서종태]', screen_w = '1418', screen_h = '798', cdkey = '747413241531' WHERE mac_idx = '353442' ========================2021-11-01 13:13:01======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-J67DM34 parm_os_type = 110 parm_screen_w = 1418 parm_screen_h = 798 parm_user_mac = CAFF221B5E95FE2ADF7E sCDKey = 747413241531 sName = DESKTOP-J67DM34 ========================2021-11-01 13:13:01======================== 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 = '747413241531' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-01 13:28:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6MQDG3N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99655ED2D18FA2D0 sCDKey = 731718530153 sName = DESKTOP-6MQDG3N ========================2021-11-01 13:28: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 = '731718530153' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 13:28:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yy1202' ========================2021-11-01 13:28:05======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99655ED2D18FA2D0' AND app_code = '039' ========================2021-11-01 13:28:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '352248' ========================2021-11-01 13:28:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '352248' ========================2021-11-01 13:28:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '352248', 'B42E99655ED2D18FA2D0', '039', 'DESKTOP-6MQDG3N', '110', '1920', '1080', 'yy1202', '용원정공[배영민]', '731718530153' ) ========================2021-11-01 13:28:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6MQDG3N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99655ED2D18FA2D0 sCDKey = 731718530153 sName = DESKTOP-6MQDG3N ========================2021-11-01 13:28:21======================== 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 = '731718530153' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 13:28:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-6MQDG3N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99655ED2D18FA2D0 sCDKey = 731718530153 sName = DESKTOP-6MQDG3N ========================2021-11-01 13:28:47======================== 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 = '731718530153' AND r.app_code = '039' AND r.app_block = 0 ========================2021-11-01 14:16:19======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:16:19======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:16:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:16:20======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:16:20======================== 값이 없을 경우 ========================2021-11-01 14:17:54======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:17: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:17:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:17:54======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:17:54======================== 값이 없을 경우 ========================2021-11-01 14:23:53======================== noteurl_start parm_app_code = 050 parm_pc_name = HN2021072901S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00051B904D3966423623 sCDKey = 639449125243 sName = admin ========================2021-11-01 14:23: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 = '639449125243' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:23:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sfasemicon' ========================2021-11-01 14:23:53======================== SELECT idx FROM macs WHERE mac_addr = '00051B904D3966423623' AND app_code = '050' ========================2021-11-01 14:23:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '351812' ========================2021-11-01 14:23:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '351812' ========================2021-11-01 14:23:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '351812', '00051B904D3966423623', '050', 'admin', '109', '1920', '1080', 'sfasemicon', '(주)에스에프에이반도체[김성민]', '639449125243' ) ========================2021-11-01 14:24:05======================== noteurl_start parm_app_code = 050 parm_pc_name = HN2021072901S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00051B904D3966423623 sCDKey = 639449125243 sName = admin ========================2021-11-01 14:24: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 = '639449125243' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:26:11======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA4456E1AEE2B1141 sCDKey = 035866350493 sName = 아펙사G포스장비 ========================2021-11-01 14:26:11======================== 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 = '035866350493' AND r.app_code = '046' AND r.app_block = 0 ========================2021-11-01 14:26:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'joygarden' ========================2021-11-01 14:26:12======================== SELECT idx FROM macs WHERE mac_addr = '68EDA4456E1AEE2B1141' AND app_code = '046' ========================2021-11-01 14:26:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353733' ========================2021-11-01 14:26:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353733' ========================2021-11-01 14:26:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353733', '68EDA4456E1AEE2B1141', '046', '아펙사G포스장비', '110', '1024', '768', 'joygarden', '조이가든센터[김성호]', '035866350493' ) ========================2021-11-01 14:26:29======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:26:29======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:26:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:26:29======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:26:29======================== 값이 없을 경우 ========================2021-11-01 14:26:32======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:26:32======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:26:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:26:32======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:26:32======================== 값이 없을 경우 ========================2021-11-01 14:27:23======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:27: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:27:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:27:23======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:27:23======================== 값이 없을 경우 ========================2021-11-01 14:32:58======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:32:58======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:32:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:32:58======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:32:58======================== 값이 없을 경우 ========================2021-11-01 14:33:01======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:33:01======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:33:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:33:01======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:33:01======================== 값이 없을 경우 ========================2021-11-01 14:33:03======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:33:03======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:33:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:33:03======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:33:03======================== 값이 없을 경우 ========================2021-11-01 14:33:13======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:33:13======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:33:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:33:13======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:33:13======================== 값이 없을 경우 ========================2021-11-01 14:33:25======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:33:25======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:33:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:33:25======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:33:25======================== 값이 없을 경우 ========================2021-11-01 14:34:34======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:34: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:34:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:34:34======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:34:34======================== 값이 없을 경우 ========================2021-11-01 14:34:45======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:34:45======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:34:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:34:45======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:34:45======================== 값이 없을 경우 ========================2021-11-01 14:37:57======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:37: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:37:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:37:57======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:37:57======================== 값이 없을 경우 ========================2021-11-01 14:52:06======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 950428290210 sName = DESKTOP-803Q190 ========================2021-11-01 14:52:06======================== 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 = '950428290210' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:52:55======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:52: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:52:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:52:56======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:52:56======================== 값이 없을 경우 ========================2021-11-01 14:53:31======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53:31======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:31======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:31======================== 값이 없을 경우 ========================2021-11-01 14:53:33======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53:33======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:33======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:33======================== 값이 없을 경우 ========================2021-11-01 14:53:35======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53:35======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:35======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:35======================== 값이 없을 경우 ========================2021-11-01 14:53:36======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53:36======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:36======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:36======================== 값이 없을 경우 ========================2021-11-01 14:53:37======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53:37======================== 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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:37======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:37======================== 값이 없을 경우 ========================2021-11-01 14:53:49======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:53: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:53:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:53:50======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:53:50======================== 값이 없을 경우 ========================2021-11-01 14:55:05======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-803Q190 parm_os_type = 109 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 8CB0E92094384487424A sCDKey = 708128512512 sName = DESKTOP-803Q190 ========================2021-11-01 14:55: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 = '708128512512' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 14:55:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jinsung2' ========================2021-11-01 14:55:05======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E92094384487424A' AND app_code = '050' ========================2021-11-01 14:55:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353734' ========================2021-11-01 14:55:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353734' ========================2021-11-01 14:55:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353734', '8CB0E92094384487424A', '050', 'DESKTOP-803Q190', '109', '1536', '864', 'jinsung2', '(주)진성이엔지[나인석]', '708128512512' ) ========================2021-11-01 16:21:31======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-0R5F8KU parm_os_type = 109 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 086266C577DA80667310 sCDKey = 640014736042 sName = DESKTOP-0R5F8KU ========================2021-11-01 16:21:31======================== 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 = '640014736042' AND r.app_code = '050' AND r.app_block = 0 ========================2021-11-01 16:21:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2011' ========================2021-11-01 16:21:31======================== SELECT idx FROM macs WHERE mac_addr = '086266C577DA80667310' AND app_code = '050' ========================2021-11-01 16:21:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '353748' ========================2021-11-01 16:21:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '353748' ========================2021-11-01 16:21:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '353748', '086266C577DA80667310', '050', 'DESKTOP-0R5F8KU', '109', '2560', '1440', 'blc2011', '함미르[함미르]', '640014736042' )