========================2018-03-12 07:52:55======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-MGE6 ========================2018-03-12 07:52: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 09:26:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3A63495D0464AB1 sCDKey = 455850962112 sName = DONG ========================2018-03-12 09:26:41======================== 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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 09:27:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3A63495D0464AB1 sCDKey = 455850962112 sName = DONG ========================2018-03-12 09:27: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 09:27:40======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3A63495D0464AB1 sCDKey = 455850962112 sName = DONG ========================2018-03-12 09:27: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 09:27:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dh3162693' ========================2018-03-12 09:27:40======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A63495D0464AB1' AND app_code = '039' ========================2018-03-12 09:27:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '89831' ========================2018-03-12 09:27:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '89831' ========================2018-03-12 09:27:40======================== UPDATE mac_detail SET pc_name = 'DONG', os_type = '110', user_id = 'dh3162693', user_name = '동한상사[이광호]', screen_w = '1600', screen_h = '900', cdkey = '455850962112' WHERE mac_idx = '89831' ========================2018-03-12 09:32:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4NCF2QV parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 14C913FBA59F42925D91 sCDKey = 171697094476 sName = DESKTOP-4NCF2QV ========================2018-03-12 09:32: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 = '171697094476' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 09:32:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tjrgma57' ========================2018-03-12 09:32:45======================== SELECT idx FROM macs WHERE mac_addr = '14C913FBA59F42925D91' AND app_code = '039' ========================2018-03-12 09:32:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244091' ========================2018-03-12 09:32:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244091' ========================2018-03-12 09:32:45======================== UPDATE mac_detail SET pc_name = 'DESKTOP-4NCF2QV', os_type = '110', user_id = 'tjrgma57', user_name = '보성정밀[나석흠]', screen_w = '1536', screen_h = '864', cdkey = '171697094476' WHERE mac_idx = '244091' ========================2018-03-12 10:07:15======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:07: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:14:08======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:14:08======================== 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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:15:16======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:15: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:17:35======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:17: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:19:52======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:19: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:19:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mreakeu' ========================2018-03-12 10:19:52======================== SELECT idx FROM macs WHERE mac_addr = '70C94E51045340C9553D' AND app_code = '039' ========================2018-03-12 10:19:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244093' ========================2018-03-12 10:19:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244093' ========================2018-03-12 10:19:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244093', '70C94E51045340C9553D', '039', 'LAPTOP-CTITV6S3', '110', '1920', '1080', 'mreakeu', '용접박사[조만기]', '755853048887' ) ========================2018-03-12 10:19:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:19:58======================== 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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:20:15======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-CTITV6S3 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 70C94E51045340C9553D sCDKey = 755853048887 sName = LAPTOP-CTITV6S3 ========================2018-03-12 10:20: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 = '755853048887' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:22:29======================== noteurl_start parm_app_code = 046 parm_pc_name = HOMESPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BFF3A4AF7DFD sCDKey = 921252470168 sName = HOMESPOS ========================2018-03-12 10:22:29======================== 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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-12 10:22:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-03-12 10:22:29======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' ========================2018-03-12 10:22:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' ========================2018-03-12 10:22:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' ========================2018-03-12 10:22:29======================== UPDATE mac_detail SET pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1024', screen_h = '768', cdkey = '921252470168' WHERE mac_idx = '236522' ========================2018-03-12 10:23:33======================== noteurl_start parm_app_code = 039 parm_pc_name = SYU-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 000FFEDB94E0C2DDC7CB sCDKey = 292139709317 sName = SYU-PC ========================2018-03-12 10:23: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 = '292139709317' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:23:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'namsy36' ========================2018-03-12 10:23:33======================== SELECT idx FROM macs WHERE mac_addr = '000FFEDB94E0C2DDC7CB' AND app_code = '039' ========================2018-03-12 10:23:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244166' ========================2018-03-12 10:23:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244166' ========================2018-03-12 10:23: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 ( '244166', '000FFEDB94E0C2DDC7CB', '039', 'SYU-PC', '90', '1680', '1050', 'namsy36', 'RGB[남상용]', '292139709317' ) ========================2018-03-12 10:23:53======================== noteurl_start parm_app_code = 039 parm_pc_name = SYU-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 000FFEDB94E0C2DDC7CB sCDKey = 292139709317 sName = SYU-PC ========================2018-03-12 10:23: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 = '292139709317' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:35:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MOSHU3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 107B447CE9A542AD3A78 sCDKey = 551114429977 sName = DESKTOP-MOSHU3J ========================2018-03-12 10:35: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:35:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'selim7914' ========================2018-03-12 10:35:19======================== SELECT idx FROM macs WHERE mac_addr = '107B447CE9A542AD3A78' AND app_code = '039' ========================2018-03-12 10:35:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238575' ========================2018-03-12 10:35:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238575' ========================2018-03-12 10:35:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238575', '107B447CE9A542AD3A78', '039', 'DESKTOP-MOSHU3J', '110', '1920', '1080', 'selim7914', '세림정밀[박주덕]', '551114429977' ) ========================2018-03-12 10:35:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MOSHU3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 107B447CE9A542AD3A78 sCDKey = 551114429977 sName = DESKTOP-MOSHU3J ========================2018-03-12 10:35: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:35:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MOSHU3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 107B447CE9A542AD3A78 sCDKey = 551114429977 sName = DESKTOP-MOSHU3J ========================2018-03-12 10: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 10:35:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-MOSHU3J parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 107B447CE9A542AD3A78 sCDKey = 551114429977 sName = DESKTOP-MOSHU3J ========================2018-03-12 10:35: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 = '551114429977' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 11:02:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SG168FQ parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B06EBFD15D2BA081C8A6 sCDKey = 681282865677 sName = DESKTOP-SG168FQ ========================2018-03-12 11:02:38======================== 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 = '681282865677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 11:02:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjd06601' ========================2018-03-12 11:02:38======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBFD15D2BA081C8A6' AND app_code = '039' ========================2018-03-12 11:02:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244178' ========================2018-03-12 11:02:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244178' ========================2018-03-12 11:02:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244178', 'B06EBFD15D2BA081C8A6', '039', 'DESKTOP-SG168FQ', '110', '1280', '1024', 'kjd06601', '우리상사[김진두]', '681282865677' ) ========================2018-03-12 11:26:54======================== 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 = D43D7EBB039CEAB0D191 sCDKey = 111665473740 sName = MSDN-SPECIAL ========================2018-03-12 11:26: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 = '111665473740' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 11:26:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dsc503' ========================2018-03-12 11:26:54======================== SELECT idx FROM macs WHERE mac_addr = 'D43D7EBB039CEAB0D191' AND app_code = '039' ========================2018-03-12 11:26:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244190' ========================2018-03-12 11:26:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244190' ========================2018-03-12 11:26:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244190', 'D43D7EBB039CEAB0D191', '039', 'MSDN-SPECIAL', '90', '1920', '1080', 'dsc503', '삼성지게차물류주식회사[안대현]', '111665473740' ) ========================2018-03-12 16:43:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BF7KM3L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8C89A5E8263C9C936CFE sCDKey = 867810080946 sName = DESKTOP-BF7KM3L ========================2018-03-12 16:43:03======================== 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 = '867810080946' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-12 16:43:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dm2663' ========================2018-03-12 16:43:03======================== SELECT idx FROM macs WHERE mac_addr = '8C89A5E8263C9C936CFE' AND app_code = '039' ========================2018-03-12 16:43:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244258' ========================2018-03-12 16:43:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244258' ========================2018-03-12 16:43:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244258', '8C89A5E8263C9C936CFE', '039', 'DESKTOP-BF7KM3L', '110', '1920', '1080', 'dm2663', '동문자동화[류규식]', '867810080946' )