========================2024-12-24 11:45:44======================== noteurl_start parm_app_code = 045 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E60CB92E87FB70 sCDKey = 126610447400 sName = LSH-PC ========================2024-12-24 11:45: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 = '126610447400' AND r.app_code = '045' AND r.app_block = 0 ========================2024-12-24 11:45:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2024-12-24 11:45:44======================== SELECT idx FROM macs WHERE mac_addr = '309C23E60CB92E87FB70' AND app_code = '045' ========================2024-12-24 11:45:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '388032' ========================2024-12-24 11:45:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '388032' ========================2024-12-24 11:45: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 ( '388032', '309C23E60CB92E87FB70', '045', 'LSH-PC', '110', '1920', '1080', 'yoonmin1121', '데이데이마트[이수현]', '126610447400' ) ========================2024-12-24 14:07:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GR5R5KB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 10FFE0711588168CB205 sCDKey = 375473433742 sName = DESKTOP-GR5R5KB ========================2024-12-24 14:07: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 = '375473433742' AND r.app_code = '039' AND r.app_block = 0 ========================2024-12-24 14:07:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mycou' ========================2024-12-24 14:07:53======================== SELECT idx FROM macs WHERE mac_addr = '10FFE0711588168CB205' AND app_code = '039' ========================2024-12-24 14:07:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '415101' ========================2024-12-24 14:07:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '415101' ========================2024-12-24 14:07: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 ( '415101', '10FFE0711588168CB205', '039', 'DESKTOP-GR5R5KB', '110', '1920', '1080', 'mycou', '인제공업사[허영무]', '375473433742' ) ========================2024-12-24 14:23:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-DBM3O53 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4551C75B89C252F sCDKey = 396429017219 sName = DESKTOP-DBM3O53 ========================2024-12-24 14:23: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 = '396429017219' AND r.app_code = '039' AND r.app_block = 0 ========================2024-12-24 14:23:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ympcb' ========================2024-12-24 14:23:39======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4551C75B89C252F' AND app_code = '039' ========================2024-12-24 14:23:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '415100' ========================2024-12-24 14:23:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '415100' ========================2024-12-24 14:23: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 ( '415100', 'BC5FF4551C75B89C252F', '039', 'DESKTOP-DBM3O53', '110', '1920', '1080', 'ympcb', '유명테크[김진호]', '396429017219' ) ========================2024-12-24 15:15:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1F94PL0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E01EDB5FCD sCDKey = 905487135700 sName = DESKTOP-1F94PL0 ========================2024-12-24 15:15: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-24 15:15:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2024-12-24 15:15:26======================== SELECT idx FROM macs WHERE mac_addr = '7085C23113E01EDB5FCD' AND app_code = '047' ========================2024-12-24 15:15:26======================== 값이 없을 경우 ========================2024-12-24 15:48:30======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1F94PL0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E01EDB5FCD sCDKey = 905487135700 sName = DESKTOP-1F94PL0 ========================2024-12-24 15:48:30======================== 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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-24 15:48:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2024-12-24 15:48:30======================== SELECT idx FROM macs WHERE mac_addr = '7085C23113E01EDB5FCD' AND app_code = '047' ========================2024-12-24 15:48:30======================== 값이 없을 경우 ========================2024-12-24 16:12:36======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1F94PL0 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C23113E01EDB5FCD sCDKey = 905487135700 sName = DESKTOP-1F94PL0 ========================2024-12-24 16:12: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 = '905487135700' AND r.app_code = '047' AND r.app_block = 0 ========================2024-12-24 16:12:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modpam' ========================2024-12-24 16:12:36======================== SELECT idx FROM macs WHERE mac_addr = '7085C23113E01EDB5FCD' AND app_code = '047' ========================2024-12-24 16:12:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '415107' ========================2024-12-24 16:12:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '415107' ========================2024-12-24 16:12: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 ( '415107', '7085C23113E01EDB5FCD', '047', 'DESKTOP-1F94PL0', '�쐢�룄�슦 10', '0', '0', 'modpam', '(주)더편한세상[이래완]', '905487135700' )