========================2018-09-03 09:12:20======================== noteurl_start parm_app_code = 039 parm_pc_name = LG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A08869BF839EF4A41E29 sCDKey = 205663637872 sName = LG ========================2018-09-03 09:12: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 = '205663637872' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-03 09:12:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ltg1020' ========================2018-09-03 09:12:20======================== SELECT idx FROM macs WHERE mac_addr = 'A08869BF839EF4A41E29' AND app_code = '039' ========================2018-09-03 09:12:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '200344' ========================2018-09-03 09:12:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '200344' ========================2018-09-03 09:12: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 ( '200344', 'A08869BF839EF4A41E29', '039', 'LG', '110', '1920', '1080', 'ltg1020', '유강산업사[이태곤]', '205663637872' ) ========================2018-09-03 09:57:38======================== noteurl_start parm_app_code = 039 parm_pc_name = 삼성COPY1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050994AD2894228D0EA sCDKey = 293768519265 sName = 삼성COPY1 ========================2018-09-03 09:57: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 = '293768519265' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-03 09:57:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samcoppy' ========================2018-09-03 09:57:38======================== SELECT idx FROM macs WHERE mac_addr = 'D050994AD2894228D0EA' AND app_code = '039' ========================2018-09-03 09:57:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258980' ========================2018-09-03 09:57:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258980' ========================2018-09-03 09:57: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 ( '258980', 'D050994AD2894228D0EA', '039', '삼성COPY1', '90', '1920', '1080', 'samcoppy', '삼성인쇄사[이은숙]', '293768519265' ) ========================2018-09-03 09:57:42======================== noteurl_start parm_app_code = 039 parm_pc_name = 삼성COPY1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D050994AD2894228D0EA sCDKey = 293768519265 sName = 삼성COPY1 ========================2018-09-03 09:57: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 = '293768519265' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-03 11:30:14======================== noteurl_start parm_app_code = 039 parm_pc_name = 울랄라-PC parm_os_type = 90 parm_screen_w = 1080 parm_screen_h = 1080 parm_user_mac = E0D55EC09322ACE01D42 sCDKey = 708322585128 sName = 울랄라-PC ========================2018-09-03 11:30:14======================== 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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-03 11:30:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2018-09-03 11:30:14======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EC09322ACE01D42' AND app_code = '039' ========================2018-09-03 11:30:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258986' ========================2018-09-03 11:30:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258986' ========================2018-09-03 11:30:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258986', 'E0D55EC09322ACE01D42', '039', '울랄라-PC', '90', '1080', '1080', 'ramades77', '(주)비엠아이[이동훈]', '708322585128' ) ========================2018-09-03 11:30:41======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D02788D030EDD6543C1C sCDKey = 356827008284 sName = 인아 ========================2018-09-03 11:30: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 = '356827008284' AND r.app_code = '039' AND r.app_block = 0 ========================2018-09-03 11:30:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'inaartwall11' ========================2018-09-03 11:30:41======================== SELECT idx FROM macs WHERE mac_addr = 'D02788D030EDD6543C1C' AND app_code = '039' ========================2018-09-03 11:30:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '258988' ========================2018-09-03 11:30:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '258988' ========================2018-09-03 11:30:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '258988', 'D02788D030EDD6543C1C', '039', '인아', '90', '1920', '1080', 'inaartwall11', '인아[박미희]', '356827008284' ) ========================2018-09-03 13:22:16======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9G7AP3C parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E965D5D2180B34 sCDKey = 009656448181 sName = DESKTOP-9G7AP3C ========================2018-09-03 13:22: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 = '009656448181' AND r.app_code = '046' AND r.app_block = 0 ========================2018-09-03 13:22:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mirae3m' ========================2018-09-03 13:22:16======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E965D5D2180B34' AND app_code = '046' ========================2018-09-03 13:22:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259006' ========================2018-09-03 13:22:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259006' ========================2018-09-03 13:22:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '259006', 'E0D55E965D5D2180B34', '046', 'DESKTOP-9G7AP3C', '110', '1920', '1080', 'mirae3m', '미래상사[최도분]', '009656448181' ) ========================2018-09-03 13:32:44======================== noteurl_start parm_app_code = 045 parm_pc_name = 1-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50E54933E71E12007A65 sCDKey = 381943393149 sName = 1-PC ========================2018-09-03 13:32: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 = '381943393149' AND r.app_code = '045' AND r.app_block = 0 ========================2018-09-03 13:32:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'guyoung1030' ========================2018-09-03 13:32:45======================== SELECT idx FROM macs WHERE mac_addr = '50E54933E71E12007A65' AND app_code = '045' ========================2018-09-03 13:32:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259008' ========================2018-09-03 13:32:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259008' ========================2018-09-03 13:32:45======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '259008', '50E54933E71E12007A65', '045', '1-PC', '90', '1920', '1080', 'guyoung1030', '(주)봉농[정구영]', '381943393149' ) ========================2018-09-03 14:02:23======================== noteurl_start parm_app_code = 045 parm_pc_name = LSH-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00245433345AC80F3AF1 sCDKey = 126610447400 sName = LSH-PC ========================2018-09-03 14:02: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 = '126610447400' AND r.app_code = '045' AND r.app_block = 0 ========================2018-09-03 14:02:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yoonmin1121' ========================2018-09-03 14:02:23======================== SELECT idx FROM macs WHERE mac_addr = '00245433345AC80F3AF1' AND app_code = '045' ========================2018-09-03 14:02:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259018' ========================2018-09-03 14:02:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259018' ========================2018-09-03 14:02: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 ( '259018', '00245433345AC80F3AF1', '045', 'LSH-PC', '110', '1920', '1080', 'yoonmin1121', '[이수현]', '126610447400' )