========================2018-03-15 09:14:17======================== 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 = 7085C23B6E1D2180B34 sCDKey = 009656448181 sName = DESKTOP-9G7AP3C ========================2018-03-15 09:14:17======================== 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-03-15 09:14:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mirae3m' ========================2018-03-15 09:14:17======================== SELECT idx FROM macs WHERE mac_addr = '7085C23B6E1D2180B34' AND app_code = '046' ========================2018-03-15 09:14:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '218964' ========================2018-03-15 09:14:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '218964' ========================2018-03-15 09:14:17======================== UPDATE mac_detail SET pc_name = 'DESKTOP-9G7AP3C', os_type = '110', user_id = 'mirae3m', user_name = '미래상사[최도분]', screen_w = '1920', screen_h = '1080', cdkey = '009656448181' WHERE mac_idx = '218964' ========================2018-03-15 09:14:21======================== 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 = 7085C23B6E1D2180B34 sCDKey = 009656448181 sName = DESKTOP-9G7AP3C ========================2018-03-15 09:14:21======================== 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-03-15 10:12:28======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-20180223FO parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 14DAE9200AE154B29CED sCDKey = 109436997008 sName = USER-20180223FO ========================2018-03-15 10:12: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 = '109436997008' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 10:12:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimlee21' ========================2018-03-15 10:12:28======================== SELECT idx FROM macs WHERE mac_addr = '14DAE9200AE154B29CED' AND app_code = '039' ========================2018-03-15 10:12:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244529' ========================2018-03-15 10:12:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244529' ========================2018-03-15 10:12:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244529', '14DAE9200AE154B29CED', '039', 'USER-20180223FO', '90', '1920', '1200', 'kimlee21', '(주)태봉산업개발[김남국]', '109436997008' ) ========================2018-03-15 10:22:58======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A01D48F97BAC7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-03-15 10:22: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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 10:24:19======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 10:24: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 10:24:26======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 10:24: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 10:24:32======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 10:24:32======================== 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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 10:24:59======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 10:24: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 10:25:09======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 10:25: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 10:25:50======================== noteurl_start parm_app_code = 039 parm_pc_name = HP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A01D48F97BAC7A03CF15 sCDKey = 587810805864 sName = HP ========================2018-03-15 10:25:50======================== 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 = '587810805864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 10:25:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'withusptns' ========================2018-03-15 10:25:50======================== SELECT idx FROM macs WHERE mac_addr = 'A01D48F97BAC7A03CF15' AND app_code = '039' ========================2018-03-15 10:25:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '185341' ========================2018-03-15 10:25:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '185341' ========================2018-03-15 10:25:50======================== UPDATE mac_detail SET pc_name = 'HP', os_type = '110', user_id = 'withusptns', user_name = '위더스파트너스주식회사[노현국]', screen_w = '1536', screen_h = '864', cdkey = '587810805864' WHERE mac_idx = '185341' ========================2018-03-15 11:43:21======================== noteurl_start parm_app_code = 039 parm_pc_name = SONG parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACB57D7BEB087A079005 sCDKey = 603417970769 sName = SONG ========================2018-03-15 11:43:21======================== 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 = '603417970769' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 11:43:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'song1110' ========================2018-03-15 11:43:21======================== SELECT idx FROM macs WHERE mac_addr = 'ACB57D7BEB087A079005' AND app_code = '039' ========================2018-03-15 11:43:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244546' ========================2018-03-15 11:43:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244546' ========================2018-03-15 11:43:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244546', 'ACB57D7BEB087A079005', '039', 'SONG', '110', '1366', '768', 'song1110', '주식회사 브이지[송대현]', '603417970769' ) ========================2018-03-15 11:44:35======================== noteurl_start parm_app_code = 051 parm_pc_name = SEO-N16-006 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 847BEB1796BD4233DF15 sCDKey = 887148749309 sName = SEO-N16-006 ========================2018-03-15 11:44: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 = '887148749309' AND r.app_code = '051' AND r.app_block = 0 ========================2018-03-15 13:15:49======================== noteurl_start parm_app_code = 046 parm_pc_name = HYOUN-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 74D4353AD1049213E194 sCDKey = 950239637620 sName = HYOUN-PC ========================2018-03-15 13:15:49======================== 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 = '950239637620' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-15 13:15:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkj8097' ========================2018-03-15 13:15:49======================== SELECT idx FROM macs WHERE mac_addr = '74D4353AD1049213E194' AND app_code = '046' ========================2018-03-15 13:15:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244553' ========================2018-03-15 13:15:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244553' ========================2018-03-15 13:15:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244553', '74D4353AD1049213E194', '046', 'HYOUN-PC', '90', '1280', '1024', 'kkj8097', '한양건재[김기준]', '950239637620' ) ========================2018-03-15 14:11:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-FC3O7PH parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 9883897A4EE812A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-03-15 14: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 14:11:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys9270' ========================2018-03-15 14:11:57======================== SELECT idx FROM macs WHERE mac_addr = '9883897A4EE812A3E273' AND app_code = '039' ========================2018-03-15 14:11:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197355' ========================2018-03-15 14:11:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197355' ========================2018-03-15 14:11:57======================== UPDATE mac_detail SET pc_name = 'DESKTOP-FC3O7PH', os_type = '110', user_id = 'ys9270', user_name = '영상케미칼[김영상]', screen_w = '1920', screen_h = '1080', cdkey = '428662420564' WHERE mac_idx = '197355' ========================2018-03-15 14:26:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG-2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389819606683DDA55 sCDKey = 455850962112 sName = DONG-2 ========================2018-03-15 14:26: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 14:27:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG-2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389819606683DDA55 sCDKey = 455850962112 sName = DONG-2 ========================2018-03-15 14:27: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 14:28:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG-2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389819606683DDA55 sCDKey = 455850962112 sName = DONG-2 ========================2018-03-15 14:28: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 14:28:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dh3162693' ========================2018-03-15 14:28:54======================== SELECT idx FROM macs WHERE mac_addr = '988389819606683DDA55' AND app_code = '039' ========================2018-03-15 14:28:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '242096' ========================2018-03-15 14:28:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '242096' ========================2018-03-15 14:28:54======================== UPDATE mac_detail SET pc_name = 'DONG-2', os_type = '110', user_id = 'dh3162693', user_name = '동한상사[이광호]', screen_w = '1920', screen_h = '1080', cdkey = '455850962112' WHERE mac_idx = '242096' ========================2018-03-15 14:29:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DONG-2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389819606683DDA55 sCDKey = 455850962112 sName = DONG-2 ========================2018-03-15 14:29: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 = '455850962112' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-15 16:27:39======================== noteurl_start parm_app_code = 046 parm_pc_name = YOUNG-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = BC5FF4D9B0BF1873953B sCDKey = 950239637620 sName = YOUNG-PC ========================2018-03-15 16:27: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 = '950239637620' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-15 16:27:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkj8097' ========================2018-03-15 16:27:39======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4D9B0BF1873953B' AND app_code = '046' ========================2018-03-15 16:27:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '244580' ========================2018-03-15 16:27:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '244580' ========================2018-03-15 16:27:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '244580', 'BC5FF4D9B0BF1873953B', '046', 'YOUNG-PC', '90', '1280', '1024', 'kkj8097', '한양건재[김기준]', '950239637620' )