========================2023-11-10 09:01:18======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC03 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C20DA17616D84972 sCDKey = 368335700167 sName = USER-PC03 ========================2023-11-10 09:01: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 = '368335700167' AND r.app_code = '046' AND r.app_block = 0 ========================2023-11-10 09:01:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kim71882' ========================2023-11-10 09:01:18======================== SELECT idx FROM macs WHERE mac_addr = '7085C20DA17616D84972' AND app_code = '046' ========================2023-11-10 09:01:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '208497' ========================2023-11-10 09:01:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '208497' ========================2023-11-10 09:01:18======================== UPDATE mac_detail SET pc_name = 'USER-PC03', os_type = '90', user_id = 'kim71882', user_name = 'TK종합상사[이종훈]', screen_w = '1920', screen_h = '1080', cdkey = '368335700167' WHERE mac_idx = '208497' ========================2023-11-10 13:59:47======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UGONLN7 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 74563C987BACFE45040C sCDKey = 001695990547 sName = DESKTOP-UGONLN7 ========================2023-11-10 13:59: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 = '001695990547' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-10 13:59:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimeh5084' ========================2023-11-10 13:59:47======================== SELECT idx FROM macs WHERE mac_addr = '74563C987BACFE45040C' AND app_code = '039' ========================2023-11-10 13:59:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396018' ========================2023-11-10 13:59:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396018' ========================2023-11-10 13:59:47======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396018', '74563C987BACFE45040C', '039', 'DESKTOP-UGONLN7', '110', '1360', '768', 'kimeh5084', '대신전기조명안전[김은하]', '001695990547' ) ========================2023-11-10 14:41:57======================== noteurl_start parm_app_code = 039 parm_pc_name = POS1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B06EBFD3B8F4D2F30B8B sCDKey = 007922815942 sName = POS1 ========================2023-11-10 14:41: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 = '007922815942' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-10 14:41:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori00834' ========================2023-11-10 14:41:57======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBFD3B8F4D2F30B8B' AND app_code = '039' ========================2023-11-10 14:41:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '256990' ========================2023-11-10 14:41:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '256990' ========================2023-11-10 14:41:57======================== UPDATE mac_detail SET pc_name = 'POS1', os_type = '90', user_id = 'woori00834', user_name = '(주)우리미트앤에이징[박진국]', screen_w = '1920', screen_h = '1080', cdkey = '007922815942' WHERE mac_idx = '256990' ========================2023-11-10 14:50:10======================== noteurl_start parm_app_code = 047 parm_pc_name = MYOUNGJINJU4A9D parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001C422FAC67124D50B2 sCDKey = 679110813017 sName = MYOUNGJINJU4A9D ========================2023-11-10 14:50:10======================== 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 = '679110813017' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-10 14:50:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jung382' ========================2023-11-10 14:50:10======================== SELECT idx FROM macs WHERE mac_addr = '001C422FAC67124D50B2' AND app_code = '047' ========================2023-11-10 14:50:10======================== 값이 없을 경우 ========================2023-11-10 14:51:22======================== noteurl_start parm_app_code = 047 parm_pc_name = MYOUNGJINJU4A9D parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001C422FAC67124D50B2 sCDKey = 679110813017 sName = MYOUNGJINJU4A9D ========================2023-11-10 14:51:22======================== 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 = '679110813017' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-10 14:51:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jung382' ========================2023-11-10 14:51:22======================== SELECT idx FROM macs WHERE mac_addr = '001C422FAC67124D50B2' AND app_code = '047' ========================2023-11-10 14:51:22======================== 값이 없을 경우 ========================2023-11-10 14:52:12======================== noteurl_start parm_app_code = 039 parm_pc_name = HP-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 685D4300A3CA20F2983B sCDKey = 007922815942 sName = HP-PC ========================2023-11-10 14:52:12======================== 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 = '007922815942' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-10 14:52:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori00834' ========================2023-11-10 14:52:12======================== SELECT idx FROM macs WHERE mac_addr = '685D4300A3CA20F2983B' AND app_code = '039' ========================2023-11-10 14:52:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '282357' ========================2023-11-10 14:52:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '282357' ========================2023-11-10 14:52:12======================== UPDATE mac_detail SET pc_name = 'HP-PC', os_type = '90', user_id = 'woori00834', user_name = '(주)우리미트앤에이징[박진국]', screen_w = '1920', screen_h = '1080', cdkey = '007922815942' WHERE mac_idx = '282357' ========================2023-11-10 14:58:43======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 2C4D549B6C63D2F30B8B sCDKey = 007922815942 sName = MSDN-SPECIAL ========================2023-11-10 14:58:43======================== 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 = '007922815942' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-10 14:58:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori00834' ========================2023-11-10 14:58:43======================== SELECT idx FROM macs WHERE mac_addr = '2C4D549B6C63D2F30B8B' AND app_code = '039' ========================2023-11-10 14:58:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396025' ========================2023-11-10 14:58:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396025' ========================2023-11-10 14:58:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396025', '2C4D549B6C63D2F30B8B', '039', 'MSDN-SPECIAL', '90', '1920', '1080', 'woori00834', '(주)우리미트앤에이징[박진국]', '007922815942' ) ========================2023-11-10 15:01:11======================== noteurl_start parm_app_code = 047 parm_pc_name = JIN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 001C422FAC67124D50B2 sCDKey = 679110813017 sName = JIN ========================2023-11-10 15:01: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 = '679110813017' AND r.app_code = '047' AND r.app_block = 0 ========================2023-11-10 15:01:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jung382' ========================2023-11-10 15:01:11======================== SELECT idx FROM macs WHERE mac_addr = '001C422FAC67124D50B2' AND app_code = '047' ========================2023-11-10 15:01:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396026' ========================2023-11-10 15:01:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396026' ========================2023-11-10 15:01:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396026', '001C422FAC67124D50B2', '047', 'JIN', '�쐢�룄�슦 10', '0', '0', 'jung382', '한길사[정명진]', '679110813017' ) ========================2023-11-10 15:31:33======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-CAF29UJ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CF9DC6D6163CA3A sCDKey = 381943393149 sName = DESKTOP-CAF29UJ ========================2023-11-10 15:31: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 = '381943393149' AND r.app_code = '045' AND r.app_block = 0 ========================2023-11-10 15:31:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guyoung1030' ========================2023-11-10 15:31:33======================== SELECT idx FROM macs WHERE mac_addr = '408D5CF9DC6D6163CA3A' AND app_code = '045' ========================2023-11-10 15:31:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396029' ========================2023-11-10 15:31:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396029' ========================2023-11-10 15:31:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396029', '408D5CF9DC6D6163CA3A', '045', 'DESKTOP-CAF29UJ', '110', '1920', '1080', 'guyoung1030', '(주)봉농[정구영]', '381943393149' ) ========================2023-11-10 16:39:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S0PIQ8K parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 1867B0C8766EDE03579C sCDKey = 320756433571 sName = DESKTOP-S0PIQ8K ========================2023-11-10 16:39: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 = '320756433571' AND r.app_code = '039' AND r.app_block = 0 ========================2023-11-10 16:39:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dy2273' ========================2023-11-10 16:39:32======================== SELECT idx FROM macs WHERE mac_addr = '1867B0C8766EDE03579C' AND app_code = '039' ========================2023-11-10 16:39:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '396037' ========================2023-11-10 16:39:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '396037' ========================2023-11-10 16:39:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '396037', '1867B0C8766EDE03579C', '039', 'DESKTOP-S0PIQ8K', '110', '1366', '768', 'dy2273', '동양전기상사[임승완]', '320756433571' )