========================2020-01-20 09:06:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-T5RJVK0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99C9CCB9A6D29607 sCDKey = 701511316149 sName = DESKTOP-T5RJVK0 ========================2020-01-20 09:06: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 = '701511316149' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:06:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sgfeel' ========================2020-01-20 09:06:00======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99C9CCB9A6D29607' AND app_code = '039' ========================2020-01-20 09:06:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308608' ========================2020-01-20 09:06:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308608' ========================2020-01-20 09:06: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 ( '308608', 'B42E99C9CCB9A6D29607', '039', 'DESKTOP-T5RJVK0', '110', '1920', '1080', 'sgfeel', '은성케이앤이[김성규]', '701511316149' ) ========================2020-01-20 09:45:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DIRE-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F079595D6704BE6D1C6E sCDKey = 338270963977 sName = DIRE-PC ========================2020-01-20 09:45:09======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:45:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DIRE-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F079595D6704BE6D1C6E sCDKey = 338270963977 sName = DIRE-PC ========================2020-01-20 09:45:26======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:45:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2020-01-20 09:45:26======================== SELECT idx FROM macs WHERE mac_addr = 'F079595D6704BE6D1C6E' AND app_code = '039' ========================2020-01-20 09:45:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308615' ========================2020-01-20 09:45:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308615' ========================2020-01-20 09:45:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308615', 'F079595D6704BE6D1C6E', '039', 'DIRE-PC', '110', '1920', '1080', 'daall2004', '(주)다올정밀[(주)다올정밀]', '338270963977' ) ========================2020-01-20 09:45:54======================== noteurl_start parm_app_code = 039 parm_pc_name = 3S-W10 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9C5C8E960F42342D1975 sCDKey = 206997131873 sName = 3Spack ========================2020-01-20 09:45: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 = '206997131873' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:45:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'threespack' ========================2020-01-20 09:45:54======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E960F42342D1975' AND app_code = '039' ========================2020-01-20 09:45:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308580' ========================2020-01-20 09:45:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308580' ========================2020-01-20 09:45:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308580', '9C5C8E960F42342D1975', '039', '3Spack', '110', '1920', '1080', 'threespack', '3spack(쓰리에스팩)[최민호]', '206997131873' ) ========================2020-01-20 09:52:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DHSL3HL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E2BF69F90F5C9B8 sCDKey = 338270963977 sName = DESKTOP-DHSL3HL ========================2020-01-20 09:52:39======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:52:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2020-01-20 09:52:39======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E2BF69F90F5C9B8' AND app_code = '039' ========================2020-01-20 09:52:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308617' ========================2020-01-20 09:52:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308617' ========================2020-01-20 09:52:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308617', 'E0D55E2BF69F90F5C9B8', '039', 'DESKTOP-DHSL3HL', '110', '1920', '1080', 'daall2004', '(주)다올정밀[(주)다올정밀]', '338270963977' ) ========================2020-01-20 09:52:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DHSL3HL parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E2BF69F90F5C9B8 sCDKey = 338270963977 sName = DESKTOP-DHSL3HL ========================2020-01-20 09:52: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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:56:08======================== noteurl_start parm_app_code = 039 parm_pc_name = PC0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0492264E8CF286C801C9 sCDKey = 658835474912 sName = PC0 ========================2020-01-20 09:56:08======================== 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 = '658835474912' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 09:56:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ssusung52' ========================2020-01-20 09:56:08======================== SELECT idx FROM macs WHERE mac_addr = '0492264E8CF286C801C9' AND app_code = '039' ========================2020-01-20 09:56:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307026' ========================2020-01-20 09:56:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307026' ========================2020-01-20 09:56:08======================== UPDATE mac_detail SET pc_name = 'PC0', os_type = '110', user_id = 'ssusung52', user_name = '수성명판사[이수열]', screen_w = '1920', screen_h = '1080', cdkey = '658835474912' WHERE mac_idx = '307026' ========================2020-01-20 11:31:36======================== noteurl_start parm_app_code = 039 parm_pc_name = PC0 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 305A3A58F24586C801C9 sCDKey = 009449452592 sName = PC0 ========================2020-01-20 11:31: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 = '009449452592' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 11:31:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lll2824' ========================2020-01-20 11:31:36======================== SELECT idx FROM macs WHERE mac_addr = '305A3A58F24586C801C9' AND app_code = '039' ========================2020-01-20 11:31:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308636' ========================2020-01-20 11:31:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308636' ========================2020-01-20 11:31:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308636', '305A3A58F24586C801C9', '039', 'PC0', '110', '1024', '768', 'lll2824', '가흥공업사[이재관]', '009449452592' ) ========================2020-01-20 11:47:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-R8HHLDH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8851FB53FAA3AE8F3731 sCDKey = 675675661867 sName = DESKTOP-R8HHLDH ========================2020-01-20 11:47:44======================== 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 = '675675661867' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 11:47:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tnc461' ========================2020-01-20 11:47:44======================== SELECT idx FROM macs WHERE mac_addr = '8851FB53FAA3AE8F3731' AND app_code = '039' ========================2020-01-20 11:47:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308585' ========================2020-01-20 11:47:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308585' ========================2020-01-20 11:47:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308585', '8851FB53FAA3AE8F3731', '039', 'DESKTOP-R8HHLDH', '110', '1920', '1080', 'tnc461', '티엔씨탑[유광의]', '675675661867' ) ========================2020-01-20 13:02:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4HE42FQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D8CB8A3FE1FFC2432E5E sCDKey = 228284682513 sName = DESKTOP-4HE42FQ ========================2020-01-20 13:02: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 = '228284682513' AND r.app_code = '039' AND r.app_block = 0 ========================2020-01-20 13:02:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wf0080' ========================2020-01-20 13:02:35======================== SELECT idx FROM macs WHERE mac_addr = 'D8CB8A3FE1FFC2432E5E' AND app_code = '039' ========================2020-01-20 13:02:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308515' ========================2020-01-20 13:02:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308515' ========================2020-01-20 13:02:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308515', 'D8CB8A3FE1FFC2432E5E', '039', 'DESKTOP-4HE42FQ', '110', '1920', '1080', 'wf0080', '디직스코리아[윤일한]', '228284682513' ) ========================2020-01-20 17:55:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TSIO1U3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A4C3F0759B94C43CB1DC sCDKey = 230362306828 sName = DESKTOP-TSIO1U3 ========================2020-01-20 17:55:18======================== 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 = '230362306828' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-20 17:55:45======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-TSIO1U3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A4C3F0759B94C43CB1DC sCDKey = 230362309828 sName = DESKTOP-TSIO1U3 ========================2020-01-20 17:55: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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2020-01-20 17:55:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2020-01-20 17:55:45======================== SELECT idx FROM macs WHERE mac_addr = 'A4C3F0759B94C43CB1DC' AND app_code = '047' ========================2020-01-20 17:55:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '307171' ========================2020-01-20 17:55:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '307171' ========================2020-01-20 17:55:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '307171', 'A4C3F0759B94C43CB1DC', '047', 'DESKTOP-TSIO1U3', '�쐢�룄�슦 10', '0', '0', 'jclocal', '제천로컬푸드협동조합[김현주]', '230362309828' )