========================2018-11-06 08:24:31======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = WINDOWS-OA0LKPT ========================2018-11-06 08:24:31======================== 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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 08:24:54======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = 진아트 ========================2018-11-06 08:24: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 08:25:07======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = 진아트 ========================2018-11-06 08:25: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 08:31:35======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = WINDOWS-OA0LKPT ========================2018-11-06 08:31: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 08:35:09======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = 진아트 ========================2018-11-06 08:35: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 08:35:20======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = 진아트 ========================2018-11-06 08:35: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 09:13:32======================== noteurl_start parm_app_code = 039 parm_pc_name = WINDOWS-OA0LKPT parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = A4BADBFDF8E52C4AA773 sCDKey = 827012175285 sName = WINDOWS-OA0LKPT ========================2018-11-06 09:13: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 = '827012175285' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 09:13:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'optimec12' ========================2018-11-06 09:13:32======================== SELECT idx FROM macs WHERE mac_addr = 'A4BADBFDF8E52C4AA773' AND app_code = '039' ========================2018-11-06 09:13:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '261919' ========================2018-11-06 09:13:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '261919' ========================2018-11-06 09:13:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '261919', 'A4BADBFDF8E52C4AA773', '039', 'WINDOWS-OA0LKPT', '90', '1920', '1200', 'optimec12', '진아트[노진화]', '827012175285' ) ========================2018-11-06 11:36:56======================== noteurl_start parm_app_code = 039 parm_pc_name = CS04 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691342288BC0F5D70 sCDKey = 683187009788 sName = CS04 ========================2018-11-06 11:36: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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 11:36:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2018-11-06 11:36:56======================== SELECT idx FROM macs WHERE mac_addr = '94C691342288BC0F5D70' AND app_code = '039' ========================2018-11-06 11:36:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266737' ========================2018-11-06 11:36:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266737' ========================2018-11-06 11:36:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266737', '94C691342288BC0F5D70', '039', 'CS04', '110', '1920', '1080', 'cs0458', '천수관광[박천수]', '683187009788' ) ========================2018-11-06 11:37:00======================== noteurl_start parm_app_code = 039 parm_pc_name = CS04 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691342288BC0F5D70 sCDKey = 683187009788 sName = CS04 ========================2018-11-06 11:37:00======================== 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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 11:37:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2018-11-06 11:37:00======================== SELECT idx FROM macs WHERE mac_addr = '94C691342288BC0F5D70' AND app_code = '039' ========================2018-11-06 11:37:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266737' ========================2018-11-06 11:37:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266737' ========================2018-11-06 11:37:00======================== UPDATE mac_detail SET pc_name = 'CS04', os_type = '110', user_id = 'cs0458', user_name = '천수관광[박천수]', screen_w = '1920', screen_h = '1080', cdkey = '683187009788' WHERE mac_idx = '266737' ========================2018-11-06 11:45:14======================== noteurl_start parm_app_code = 045 parm_pc_name = 곽영학 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982AF33DAB017AA sCDKey = 805832056590 sName = 곽영학 ========================2018-11-06 11:45: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 = '805832056590' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-06 11:45:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ltweenn' ========================2018-11-06 11:45:14======================== SELECT idx FROM macs WHERE mac_addr = '98838982AF33DAB017AA' AND app_code = '045' ========================2018-11-06 11:45:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266740' ========================2018-11-06 11:45:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266740' ========================2018-11-06 11:45: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 ( '266740', '98838982AF33DAB017AA', '045', '곽영학', '110', '1920', '1080', 'ltweenn', '(주)벨벳[(주)벨벳]', '805832056590' ) ========================2018-11-06 13:01:46======================== noteurl_start parm_app_code = 039 parm_pc_name = CS02 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 94C691342293F1DCA5C7 sCDKey = 683187009788 sName = CS02 ========================2018-11-06 13:01: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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 13:01:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2018-11-06 13:01:46======================== SELECT idx FROM macs WHERE mac_addr = '94C691342293F1DCA5C7' AND app_code = '039' ========================2018-11-06 13:01:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266749' ========================2018-11-06 13:01:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266749' ========================2018-11-06 13:01: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 ( '266749', '94C691342293F1DCA5C7', '039', 'CS02', '110', '1920', '1080', 'cs0458', '천수관광[박천수]', '683187009788' ) ========================2018-11-06 13:39:41======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0S86EDS parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 7085C25E07F540B3482 sCDKey = 009830290223 sName = DESKTOP-0S86EDS ========================2018-11-06 13:39: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 = '009830290223' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 13:39:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyy0424' ========================2018-11-06 13:39:41======================== SELECT idx FROM macs WHERE mac_addr = '7085C25E07F540B3482' AND app_code = '039' ========================2018-11-06 13:39:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266754' ========================2018-11-06 13:39:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266754' ========================2018-11-06 13:39: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 ( '266754', '7085C25E07F540B3482', '039', 'DESKTOP-0S86EDS', '110', '1536', '864', 'kyy0424', '미래특수고무[정경애]', '009830290223' ) ========================2018-11-06 14:06:59======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-ONN4GRT parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898745E7D87CAEF4 sCDKey = 434133617514 sName = DESKTOP-ONN4GRT ========================2018-11-06 14:06: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-06 14:06:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-11-06 14:06:59======================== SELECT idx FROM macs WHERE mac_addr = '9883898745E7D87CAEF4' AND app_code = '048' ========================2018-11-06 14:06:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266763' ========================2018-11-06 14:06:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266763' ========================2018-11-06 14:06:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266763', '9883898745E7D87CAEF4', '048', 'DESKTOP-ONN4GRT', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2018-11-06 14:37:07======================== noteurl_start parm_app_code = 039 parm_pc_name = CS01 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 24F5AAE302F88C77D69D sCDKey = 683187009788 sName = CS01 ========================2018-11-06 14:37: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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-06 14:37:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2018-11-06 14:37:07======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE302F88C77D69D' AND app_code = '039' ========================2018-11-06 14:37:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '177955' ========================2018-11-06 14:37:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '177955' ========================2018-11-06 14:37:07======================== UPDATE mac_detail SET pc_name = 'CS01', os_type = '90', user_id = 'cs0458', user_name = '천수관광[박천수]', screen_w = '1280', screen_h = '1024', cdkey = '683187009788' WHERE mac_idx = '177955' ========================2018-11-06 18:22:30======================== noteurl_start parm_app_code = 047 parm_pc_name = KR parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 080027D9D33514F1F33F sCDKey = 796194338244 sName = KR ========================2018-11-06 18:22:30======================== 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 = '796194338244' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-06 18:22:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2018-11-06 18:22:30======================== SELECT idx FROM macs WHERE mac_addr = '080027D9D33514F1F33F' AND app_code = '047' ========================2018-11-06 18:22:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '266808' ========================2018-11-06 18:22:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '266808' ========================2018-11-06 18:22:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '266808', '080027D9D33514F1F33F', '047', 'KR', '�쐢�룄�슦 XP', '0', '0', 'aej123456', '엠제이소프트[안은준]', '796194338244' )