========================2019-06-25 13:16:47======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-IMAFM2Q parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EDE1B8F30027E54 sCDKey = 489922636378 sName = DESKTOP-IMAFM2Q ========================2019-06-25 13:16: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 = '489922636378' AND r.app_code = '045' AND r.app_block = 0 ========================2019-06-25 13:16:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kbiz' ========================2019-06-25 13:16:47======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EDE1B8F30027E54' AND app_code = '045' ========================2019-06-25 13:16:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289175' ========================2019-06-25 13:16:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289175' ========================2019-06-25 13:16: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 ( '289175', 'E0D55EDE1B8F30027E54', '045', 'DESKTOP-IMAFM2Q', '110', '1920', '1080', 'kbiz', '충남서부슈퍼마켓협동조합[김철호]', '489922636378' ) ========================2019-06-25 13:35:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-26ER8FI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A326226484CBBB sCDKey = 337559378886 sName = DESKTOP-26ER8FI ========================2019-06-25 13:35: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 = '337559378886' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-25 13:35:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xin80' ========================2019-06-25 13:35:44======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A326226484CBBB' AND app_code = '039' ========================2019-06-25 13:35:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289178' ========================2019-06-25 13:35:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289178' ========================2019-06-25 13:35: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 ( '289178', '50B7C3A326226484CBBB', '039', 'DESKTOP-26ER8FI', '110', '1920', '1080', 'xin80', '이노메탈[최소현]', '337559378886' ) ========================2019-06-25 17:54:06======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-3QDEEA7PTU parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 7071BC9E019E26AF6234 sCDKey = 210690492788 sName = USER-3QDEEA7PTU ========================2019-06-25 17:54: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 = '210690492788' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-25 17:54:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljm1515' ========================2019-06-25 17:54:06======================== SELECT idx FROM macs WHERE mac_addr = '7071BC9E019E26AF6234' AND app_code = '039' ========================2019-06-25 17:54:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '289212' ========================2019-06-25 17:54:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '289212' ========================2019-06-25 17:54:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '289212', '7071BC9E019E26AF6234', '039', 'USER-3QDEEA7PTU', '90', '1680', '1050', 'ljm1515', '개별화물[이정만]', '210690492788' ) ========================2019-06-25 18:08:35======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMYUNG-DESKTOP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346A663FA5D462B sCDKey = mjsof2019062 sName = KIMYUNG-DESKTOP ========================2019-06-25 18:08: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 = 'MJSOF2019062' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-25 18:11:46======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMYUNG-DESKTOP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346A663FA5D462B sCDKey = 320740016468 sName = KIMYUNG-DESKTOP ========================2019-06-25 18:11:46======================== 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 = '320740016468' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-25 18:11:57======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMYUNG-DESKTOP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346A663FA5D462B sCDKey = 320740016468 sName = KIMYUNG-DESKTOP ========================2019-06-25 18:11: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 = '320740016468' AND r.app_code = '039' AND r.app_block = 0 ========================2019-06-25 18:12:39======================== noteurl_start parm_app_code = 039 parm_pc_name = KIMYUNG-DESKTOP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B346A663FA5D462B sCDKey = 902B346A663F sName = KIMYUNG-DESKTOP ========================2019-06-25 18:12: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 = '902B346A663F' AND r.app_code = '039' AND r.app_block = 0