========================2023-07-20 09:38:59======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1UR4BOH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988A90E142E9380 sCDKey = 853846793831 sName = DESKTOP-1UR4BOH ========================2023-07-20 09:38:59======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 09:38:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 09:38:59======================== SELECT idx FROM macs WHERE mac_addr = '98838988A90E142E9380' AND app_code = '039' ========================2023-07-20 09:38:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390913' ========================2023-07-20 09:38:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390913' ========================2023-07-20 09:38:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390913', '98838988A90E142E9380', '039', 'DESKTOP-1UR4BOH', '110', '1920', '1080', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2023-07-20 10:24:10======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-U5RC0EG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E991589CF44095C2 sCDKey = 853846793831 sName = DESKTOP-U5RC0EG ========================2023-07-20 10:24: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:24:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:24:10======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E991589CF44095C2' AND app_code = '039' ========================2023-07-20 10:24:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '345495' ========================2023-07-20 10:24:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '345495' ========================2023-07-20 10:24:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-U5RC0EG', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '345495' ========================2023-07-20 10:24:16======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TNB12T1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982C3214C5F6673 sCDKey = 853846793831 sName = DESKTOP-TNB12T1 ========================2023-07-20 10:24:16======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:24:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:24:16======================== SELECT idx FROM macs WHERE mac_addr = '98838982C3214C5F6673' AND app_code = '039' ========================2023-07-20 10:24:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330475' ========================2023-07-20 10:24:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330475' ========================2023-07-20 10:24:16======================== UPDATE mac_detail SET pc_name = 'DESKTOP-TNB12T1', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '330475' ========================2023-07-20 10:24:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1UR4BOH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988A90E142E9380 sCDKey = 853846793831 sName = DESKTOP-1UR4BOH ========================2023-07-20 10:24:24======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:24:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:24:24======================== SELECT idx FROM macs WHERE mac_addr = '98838988A90E142E9380' AND app_code = '039' ========================2023-07-20 10:24:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390913' ========================2023-07-20 10:24:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390913' ========================2023-07-20 10:24:24======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1UR4BOH', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '390913' ========================2023-07-20 10:24:35======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-1UR4BOH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838988A90E142E9380 sCDKey = 853846793831 sName = DESKTOP-1UR4BOH ========================2023-07-20 10:24: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:24:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:24:35======================== SELECT idx FROM macs WHERE mac_addr = '98838988A90E142E9380' AND app_code = '039' ========================2023-07-20 10:24:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390913' ========================2023-07-20 10:24:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390913' ========================2023-07-20 10:24:35======================== UPDATE mac_detail SET pc_name = 'DESKTOP-1UR4BOH', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '390913' ========================2023-07-20 10:24:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-8TI1HQQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAAE3A1F54FCC8F4 sCDKey = 853846793831 sName = DESKTOP-8TI1HQQ ========================2023-07-20 10:24:55======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:24:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:24:55======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAE3A1F54FCC8F4' AND app_code = '039' ========================2023-07-20 10:24:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252126' ========================2023-07-20 10:24:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252126' ========================2023-07-20 10:24:55======================== UPDATE mac_detail SET pc_name = 'DESKTOP-8TI1HQQ', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '252126' ========================2023-07-20 10:25:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 181DEA06A1443EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2023-07-20 10:25: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 10:25:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2023-07-20 10:25:45======================== SELECT idx FROM macs WHERE mac_addr = '181DEA06A1443EFC0AEC' AND app_code = '039' ========================2023-07-20 10:25:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294411' ========================2023-07-20 10:25:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294411' ========================2023-07-20 10:25:45======================== UPDATE mac_detail SET pc_name = 'DESKTOP-L7V4AF4', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '294411' ========================2023-07-20 11:30:47======================== noteurl_start parm_app_code = 045 parm_pc_name = MYPC-20160901CY parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D275B61D6D6A813 sCDKey = 427962383004 sName = MYPC-20160901CY ========================2023-07-20 11:30: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 = '427962383004' AND r.app_code = '045' AND r.app_block = 0 ========================2023-07-20 11:30:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kookboad' ========================2023-07-20 11:30:47======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D275B61D6D6A813' AND app_code = '045' ========================2023-07-20 11:30:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390924' ========================2023-07-20 11:30:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390924' ========================2023-07-20 11:30: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 ( '390924', '1C1B0D275B61D6D6A813', '045', 'MYPC-20160901CY', '90', '1920', '1080', 'kookboad', '국보애드산업[ZHENG LINGMEI]', '427962383004' ) ========================2023-07-20 11:34:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SB1O26G parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563C3E29839ABEE3DE sCDKey = 748043494494 sName = DESKTOP-SB1O26G ========================2023-07-20 11:34:23======================== 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 = '748043494494' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 11:34:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ktech10041' ========================2023-07-20 11:34:23======================== SELECT idx FROM macs WHERE mac_addr = '74563C3E29839ABEE3DE' AND app_code = '039' ========================2023-07-20 11:34:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390925' ========================2023-07-20 11:34:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390925' ========================2023-07-20 11:34:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390925', '74563C3E29839ABEE3DE', '039', 'DESKTOP-SB1O26G', '110', '1920', '1080', 'ktech10041', '케이테크[이지유]', '748043494494' ) ========================2023-07-20 11:37:57======================== noteurl_start parm_app_code = 039 parm_pc_name = 3610G parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 982CBCC2623AA443614C sCDKey = 683156263623 sName = GRAM-3610G ========================2023-07-20 11:37: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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2023-07-20 11:37:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2023-07-20 11:37:57======================== SELECT idx FROM macs WHERE mac_addr = '982CBCC2623AA443614C' AND app_code = '039' ========================2023-07-20 11:37:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '390926' ========================2023-07-20 11:37:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '390926' ========================2023-07-20 11:37:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '390926', '982CBCC2623AA443614C', '039', 'GRAM-3610G', '110', '1536', '864', 'bangchun', '한반도[이진석]', '683156263623' )