========================2019-03-12 09:26:55======================== noteurl_start parm_app_code = 039 parm_pc_name = VSZ6TJUFD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDA73D78BCB68932 sCDKey = 452631342040 sName = VSZ6TJUFD ========================2019-03-12 09:26: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 = '452631342040' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-12 09:26:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adtech0202' ========================2019-03-12 09:26:55======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA73D78BCB68932' AND app_code = '039' ========================2019-03-12 09:26:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279714' ========================2019-03-12 09:26:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279714' ========================2019-03-12 09:26:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279714', 'B8AEEDA73D78BCB68932', '039', 'VSZ6TJUFD', '110', '1920', '1080', 'adtech0202', '에이디테크[고남섭]', '452631342040' ) ========================2019-03-12 09:41:46======================== noteurl_start parm_app_code = 039 parm_pc_name = 세광유통-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D0278801948656E8EA70 sCDKey = 891723757957 sName = 세광유통-PC ========================2019-03-12 09:41: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 = '891723757957' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-12 09:41:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sesilj71' ========================2019-03-12 09:41:46======================== SELECT idx FROM macs WHERE mac_addr = 'D0278801948656E8EA70' AND app_code = '039' ========================2019-03-12 09:41:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279632' ========================2019-03-12 09:41:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279632' ========================2019-03-12 09:41:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279632', 'D0278801948656E8EA70', '039', '세광유통-PC', '90', '1280', '1024', 'sesilj71', '세광상회[조덕제]', '891723757957' ) ========================2019-03-12 09:41:57======================== noteurl_start parm_app_code = 039 parm_pc_name = 세광유통-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = D0278801948656E8EA70 sCDKey = 891723757957 sName = 세광유통-PC ========================2019-03-12 09:41: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 = '891723757957' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-12 10:45:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-BFMLV8Q parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74D43528B9449C787701 sCDKey = 460028709655 sName = DESKTOP-BFMLV8Q ========================2019-03-12 10:45:07======================== 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 = '460028709655' AND r.app_code = '046' AND r.app_block = 0 ========================2019-03-12 10:45:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jm7337' ========================2019-03-12 10:45:07======================== SELECT idx FROM macs WHERE mac_addr = '74D43528B9449C787701' AND app_code = '046' ========================2019-03-12 10:45:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279770' ========================2019-03-12 10:45:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279770' ========================2019-03-12 10:45:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279770', '74D43528B9449C787701', '046', 'DESKTOP-BFMLV8Q', '110', '1600', '900', 'jm7337', 'jm[권서연]', '460028709655' ) ========================2019-03-12 10:49:24======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2567160EC404DD4 sCDKey = 014060550749 sName = DESKTOP-CQI8UQP ========================2019-03-12 10:49: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 = '014060550749' AND r.app_code = '045' AND r.app_block = 0 ========================2019-03-12 10:49:55======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2567160EC404DD4 sCDKey = 014060550749 sName = DESKTOP-CQI8UQP ========================2019-03-12 10:49: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 = '014060550749' AND r.app_code = '045' AND r.app_block = 0 ========================2019-03-12 10:49:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jsautos' ========================2019-03-12 10:49:55======================== SELECT idx FROM macs WHERE mac_addr = '7085C2567160EC404DD4' AND app_code = '045' ========================2019-03-12 10:49:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '279760' ========================2019-03-12 10:49:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '279760' ========================2019-03-12 10:49:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '279760', '7085C2567160EC404DD4', '045', 'DESKTOP-CQI8UQP', '110', '1920', '1080', 'jsautos', '(주)제이에스오토스[이재석]', '014060550749' ) ========================2019-03-12 10:55:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D8OVV1J parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 802BF9045A0338B36F7E sCDKey = 916970945314 sName = DESKTOP-D8OVV1J ========================2019-03-12 10:55: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2019-03-12 10:55:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D8OVV1J parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 802BF9045A0338B36F7E sCDKey = 916970945314 sName = DESKTOP-D8OVV1J ========================2019-03-12 10:55: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2019-03-12 10:55:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2019-03-12 10:55:36======================== SELECT idx FROM macs WHERE mac_addr = '802BF9045A0338B36F7E' AND app_code = '046' ========================2019-03-12 10:55:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270762' ========================2019-03-12 10:55:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270762' ========================2019-03-12 10:55:36======================== UPDATE mac_detail SET pc_name = 'DESKTOP-D8OVV1J', os_type = '110', user_id = 'danjinail', user_name = '단지네네일가게[임재완]', screen_w = '1536', screen_h = '864', cdkey = '916970945314' WHERE mac_idx = '270762' ========================2019-03-12 15:55:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PQ7KA6A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CCC6A999E13160D1C10 sCDKey = 287152641357 sName = DESKTOP-PQ7KA6A ========================2019-03-12 15:55: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 = '287152641357' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-12 15:55:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'happy0430' ========================2019-03-12 15:55:41======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A999E13160D1C10' AND app_code = '039' ========================2019-03-12 15:55:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280004' ========================2019-03-12 15:55:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280004' ========================2019-03-12 15:55: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 ( '280004', '4CCC6A999E13160D1C10', '039', 'DESKTOP-PQ7KA6A', '110', '1920', '1080', 'happy0430', '해피아울렛농업회사법인(주)[해피아울렛농업회사법인(주)]', '287152641357' ) ========================2019-03-12 15:55:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PQ7KA6A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CCC6A999E13160D1C10 sCDKey = 287152641357 sName = DESKTOP-PQ7KA6A ========================2019-03-12 15:55: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 = '287152641357' AND r.app_code = '039' AND r.app_block = 0