========================2021-04-05 11:10:40======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-V19M2HE parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 085BD6F4C3297E424E58 sCDKey = 659067095035 sName = DESKTOP-V19M2HE ========================2021-04-05 11:10: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 = '659067095035' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-05 11:10:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'swh9837' ========================2021-04-05 11:10:40======================== SELECT idx FROM macs WHERE mac_addr = '085BD6F4C3297E424E58' AND app_code = '047' ========================2021-04-05 11:10:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340428' ========================2021-04-05 11:10:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340428' ========================2021-04-05 11:10:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340428', '085BD6F4C3297E424E58', '047', 'DESKTOP-V19M2HE', '�쐢�룄�슦 10', '0', '0', 'swh9837', '애드포인트[서원희]', '659067095035' ) ========================2021-04-05 16:04:44======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-QQ3E0D9I74 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7071BC9E019E26AF6234 sCDKey = 210690492788 sName = USER-QQ3E0D9I74 ========================2021-04-05 16:04: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 = '210690492788' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-05 16:04:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljm1515' ========================2021-04-05 16:04:44======================== SELECT idx FROM macs WHERE mac_addr = '7071BC9E019E26AF6234' AND app_code = '039' ========================2021-04-05 16:04:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289212' ========================2021-04-05 16:04:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289212' ========================2021-04-05 16:04:44======================== UPDATE mac_detail SET pc_name = 'USER-QQ3E0D9I74', os_type = '90', user_id = 'ljm1515', user_name = '개별화물[이정만]', screen_w = '1920', screen_h = '1080', cdkey = '210690492788' WHERE mac_idx = '289212' ========================2021-04-05 16:07:00======================== noteurl_start parm_app_code = 047 parm_pc_name = MIJIN_JUNPYO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3C7C3FB99F0138540FC2 sCDKey = 433586618041 sName = MIJIN_JUNPYO ========================2021-04-05 16:07: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 = '433586618041' AND r.app_code = '047' AND r.app_block = 0 ========================2021-04-05 16:07:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tkekcomtest' ========================2021-04-05 16:07:00======================== SELECT idx FROM macs WHERE mac_addr = '3C7C3FB99F0138540FC2' AND app_code = '047' ========================2021-04-05 16:07:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340459' ========================2021-04-05 16:07:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340459' ========================2021-04-05 16:07: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 ( '340459', '3C7C3FB99F0138540FC2', '047', 'MIJIN_JUNPYO', '�쐢�룄�슦 10', '0', '0', 'tkekcomtest', '엠제이소프트[김준표(mj)]', '433586618041' ) ========================2021-04-05 18:10:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-66US3RB parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = A8A1596F58EF4FAF7290 sCDKey = 001695990547 sName = DESKTOP-66US3RB ========================2021-04-05 18:10: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 = '001695990547' AND r.app_code = '039' AND r.app_block = 0 ========================2021-04-05 18:10:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimeh5084' ========================2021-04-05 18:10:50======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1596F58EF4FAF7290' AND app_code = '039' ========================2021-04-05 18:10:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '340477' ========================2021-04-05 18:10:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '340477' ========================2021-04-05 18:10:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '340477', 'A8A1596F58EF4FAF7290', '039', 'DESKTOP-66US3RB', '110', '1280', '1024', 'kimeh5084', '대신전기조명안전[김은하]', '001695990547' )