========================2018-11-07 07:54:19======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 07:54:19======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:04:15======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:04:15======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:05:35======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 0030677828E8 sName = NEWCOM-PC ========================2018-11-07 08:05: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 = '0030677828E8' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:05:55======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = MSDN-SPECIAL sName = NEWCOM-PC ========================2018-11-07 08:05: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 = 'MSDNSPECIAL' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:06:16======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:06: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:06:56======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:06:56======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:07:23======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:07: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:07:42======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:07:42======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:11:27======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:11:27======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 08:48:26======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = NEWCOM-PC ========================2018-11-07 08:48: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 09:55:57======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035832696 sName = NEWCOM-PC ========================2018-11-07 09:55: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 = '476035832696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 09:56:54======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035832696 sName = 대동포장 ========================2018-11-07 09:56:54======================== 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 = '476035832696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 09:57:20======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = 대동포장 ========================2018-11-07 09:57:20======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 09:57:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjh5384' ========================2018-11-07 09:57:20======================== SELECT idx FROM macs WHERE mac_addr = '7085C2770A3C96AFC3F8' AND app_code = '039' ========================2018-11-07 09:57:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266799' ========================2018-11-07 09:57:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266799' ========================2018-11-07 09:57:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266799', '7085C2770A3C96AFC3F8', '039', '대동포장', '90', '1920', '1080', 'jjh5384', '대동포장[장두원]', '476035831696' ) ========================2018-11-07 09:57:25======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = 대동포장 ========================2018-11-07 09:57:25======================== 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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 09:57:46======================== noteurl_start parm_app_code = 039 parm_pc_name = NEWCOM-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2770A3C96AFC3F8 sCDKey = 476035831696 sName = 대동포장 ========================2018-11-07 09:57: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 = '476035831696' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 10:01:11======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = XPPRO ========================2018-11-07 10: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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:01:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:01:11======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-07 10:01:11======================== 값이 없을 경우 ========================2018-11-07 10:03:40======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = 이윤구 ========================2018-11-07 10:03: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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:03:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:03:40======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-07 10:03:40======================== 값이 없을 경우 ========================2018-11-07 10:07:36======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-WF20AH0B21 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E840F2574C24D8A9E61C sCDKey = 795055069033 sName = PC-WF20AH0B21 ========================2018-11-07 10:07: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 = '795055069033' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-07 10:07:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimjw0215' ========================2018-11-07 10:07:36======================== SELECT idx FROM macs WHERE mac_addr = 'E840F2574C24D8A9E61C' AND app_code = '039' ========================2018-11-07 10:07:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '264760' ========================2018-11-07 10:07:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '264760' ========================2018-11-07 10:07: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 ( '264760', 'E840F2574C24D8A9E61C', '039', 'PC-WF20AH0B21', '90', '1920', '1080', 'kimjw0215', '울돌목물산[조용희]', '795055069033' ) ========================2018-11-07 10:11:40======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = XPPRO ========================2018-11-07 10:11: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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:11:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:11:40======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-07 10:11:40======================== 값이 없을 경우 ========================2018-11-07 10:23:04======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = XPPRO ========================2018-11-07 10:23:04======================== 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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:23:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:23:04======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-07 10:23:04======================== 값이 없을 경우 ========================2018-11-07 10:23:52======================== noteurl_start parm_app_code = 046 parm_pc_name = XPPRO parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 1024 parm_user_mac = 001CC49DB9527C1CE267 sCDKey = 794659223172 sName = XPPRO ========================2018-11-07 10:23:52======================== 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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:23:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:23:52======================== SELECT idx FROM macs WHERE mac_addr = '001CC49DB9527C1CE267' AND app_code = '046' ========================2018-11-07 10:23:52======================== 값이 없을 경우 ========================2018-11-07 10:30:09======================== noteurl_start parm_app_code = 047 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 174873429017 sName = IMHG ========================2018-11-07 10:30:09======================== 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 = '174873429017' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-07 10:30:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhg88' ========================2018-11-07 10:30:09======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '047' ========================2018-11-07 10:30:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '220981' ========================2018-11-07 10:30:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '220981' ========================2018-11-07 10:30:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '220981', 'F44D30B9AF0E96D60F97', '047', 'IMHG', '�쐢�룄�슦 10', '0', '0', 'lhg88', '엠제이소프트[임현규]', '174873429017' ) ========================2018-11-07 10:41:02======================== noteurl_start parm_app_code = 046 parm_pc_name = IMHG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 794659223172 sName = IMHG ========================2018-11-07 10:41:02======================== 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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 10:41:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 10:41:02======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '046' ========================2018-11-07 10:41:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250690' ========================2018-11-07 10:41:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250690' ========================2018-11-07 10:41:02======================== UPDATE mac_detail SET pc_name = 'IMHG', os_type = '110', user_id = 'dnjstjrdbxhd', user_name = '롯데칠성음료만안점[김영미]', screen_w = '1920', screen_h = '1080', cdkey = '794659223172' WHERE mac_idx = '250690' ========================2018-11-07 11:48:28======================== noteurl_start parm_app_code = 046 parm_pc_name = POS002 parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001CC4D31C9C144093CB sCDKey = 794659223172 sName = POS002 ========================2018-11-07 11:48:28======================== 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 = '794659223172' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 11:48:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dnjstjrdbxhd' ========================2018-11-07 11:48:28======================== SELECT idx FROM macs WHERE mac_addr = '001CC4D31C9C144093CB' AND app_code = '046' ========================2018-11-07 11:48:28======================== 값이 없을 경우 ========================2018-11-07 14:50:48======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-B8O2U1U parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2A8B53D50CC429F sCDKey = 185317015328 sName = DESKTOP-B8O2U1U ========================2018-11-07 14:50:48======================== 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 = '185317015328' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-07 14:50:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lkj608' ========================2018-11-07 14:50:48======================== SELECT idx FROM macs WHERE mac_addr = '7085C2A8B53D50CC429F' AND app_code = '046' ========================2018-11-07 14:50:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266916' ========================2018-11-07 14:50:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266916' ========================2018-11-07 14:50:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266916', '7085C2A8B53D50CC429F', '046', 'DESKTOP-B8O2U1U', '110', '1920', '1080', 'lkj608', '레버스인터네셔널[이건재]', '185317015328' )