========================2020-12-07 08:09:50======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2020-12-07 08:09: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 08:10:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = E0D55E36D988 sName = DESKTOP-IHIELAL ========================2020-12-07 08:10: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 = 'E0D55E36D988' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 08:10:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2020-12-07 08:10:37======================== 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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 08:10:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2020-12-07 08:10: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 08:11:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2020-12-07 08:11: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 09:07:24======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IHIELAL parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 88366CF09F90F85E5384 sCDKey = 055057943414 sName = DESKTOP-IHIELAL ========================2020-12-07 09:07: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 = '055057943414' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 09:07:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'shinds02' ========================2020-12-07 09:07:24======================== SELECT idx FROM macs WHERE mac_addr = '88366CF09F90F85E5384' AND app_code = '039' ========================2020-12-07 09:07:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269938' ========================2020-12-07 09:07:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269938' ========================2020-12-07 09:07:24======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IHIELAL', os_type = '110', user_id = 'shinds02', user_name = '케이디양행[신동석]', screen_w = '1680', screen_h = '1050', cdkey = '055057943414' WHERE mac_idx = '269938' ========================2020-12-07 09:08:45======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA416CC8934627EBF sCDKey = 017337601557 sName = POS-PC ========================2020-12-07 09:08: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 = '017337601557' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-07 09:08:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k114' ========================2020-12-07 09:08:45======================== SELECT idx FROM macs WHERE mac_addr = '68EDA416CC8934627EBF' AND app_code = '046' ========================2020-12-07 09:08:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249523' ========================2020-12-07 09:08:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249523' ========================2020-12-07 09:08:45======================== UPDATE mac_detail SET pc_name = 'POS-PC', os_type = '90', user_id = 'k114', user_name = '강원산업안전(주)[김상옥]', screen_w = '1024', screen_h = '768', cdkey = '017337601557' WHERE mac_idx = '249523' ========================2020-12-07 09:14:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-UJ6AJ30 parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 244BFE8E1A9C5ED714A4 sCDKey = 128474958493 sName = DESKTOP-UJ6AJ30 ========================2020-12-07 09:14: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 = '128474958493' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 09:14:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hdlaser10' ========================2020-12-07 09:14:42======================== SELECT idx FROM macs WHERE mac_addr = '244BFE8E1A9C5ED714A4' AND app_code = '039' ========================2020-12-07 09:14:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331730' ========================2020-12-07 09:14:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331730' ========================2020-12-07 09:14:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331730', '244BFE8E1A9C5ED714A4', '039', 'DESKTOP-UJ6AJ30', '110', '1440', '900', 'hdlaser10', '현대레이저[신난영]', '128474958493' ) ========================2020-12-07 09:15:53======================== noteurl_start parm_app_code = 039 parm_pc_name = PC04-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = ECA86B26F9D63A8B1247 sCDKey = 128474958493 sName = PC04-PC ========================2020-12-07 09:15: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 = '128474958493' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 09:15:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hdlaser10' ========================2020-12-07 09:15:54======================== SELECT idx FROM macs WHERE mac_addr = 'ECA86B26F9D63A8B1247' AND app_code = '039' ========================2020-12-07 09:15:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '175683' ========================2020-12-07 09:15:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '175683' ========================2020-12-07 09:15:54======================== UPDATE mac_detail SET pc_name = 'PC04-PC', os_type = '90', user_id = 'hdlaser10', user_name = '현대레이저[신난영]', screen_w = '1280', screen_h = '1024', cdkey = '128474958493' WHERE mac_idx = '175683' ========================2020-12-07 09:17:07======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = A8A159548B8DB6C11B1D sCDKey = 756447342040 sName = 카운터 ========================2020-12-07 09:17: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 = '756447342040' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-07 09:17:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori3451777' ========================2020-12-07 09:17:07======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159548B8DB6C11B1D' AND app_code = '046' ========================2020-12-07 09:17:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331717' ========================2020-12-07 09:17:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331717' ========================2020-12-07 09:17: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 ( '331717', 'A8A159548B8DB6C11B1D', '046', '카운터', '110', '1280', '1024', 'woori3451777', '우리농산식자재도매센타[최현숙]', '756447342040' ) ========================2020-12-07 09:20:42======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = A8A159548B8D5E43 sCDKey = 756447342040 sName = 카운터 ========================2020-12-07 09:20: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 = '756447342040' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-07 09:20:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori3451777' ========================2020-12-07 09:20:42======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159548B8D5E43' AND app_code = '046' ========================2020-12-07 09:20:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331665' ========================2020-12-07 09:20:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331665' ========================2020-12-07 09:20:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331665', 'A8A159548B8D5E43', '046', '카운터', '110', '1280', '1024', 'woori3451777', '우리농산식자재도매센타[최현숙]', '756447342040' ) ========================2020-12-07 09:23:44======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = A8A159548B8DB6C11B1D sCDKey = 756447342040 sName = 카운터 ========================2020-12-07 09:23: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 = '756447342040' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-07 09:23:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woori3451777' ========================2020-12-07 09:23:44======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159548B8DB6C11B1D' AND app_code = '046' ========================2020-12-07 09:23:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331717' ========================2020-12-07 09:23:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331717' ========================2020-12-07 09:23:44======================== UPDATE mac_detail SET pc_name = '카운터', os_type = '110', user_id = 'woori3451777', user_name = '우리농산식자재도매센타[최현숙]', screen_w = '1280', screen_h = '1024', cdkey = '756447342040' WHERE mac_idx = '331717' ========================2020-12-07 10:25:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UAEJFK1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E0633622F39A7BFC0A sCDKey = 959984696638 sName = DESKTOP-UAEJFK1 ========================2020-12-07 10: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 = '959984696638' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-07 10:25:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys8230884' ========================2020-12-07 10:25:07======================== SELECT idx FROM macs WHERE mac_addr = '00E0633622F39A7BFC0A' AND app_code = '046' ========================2020-12-07 10:25:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331739' ========================2020-12-07 10:25:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331739' ========================2020-12-07 10:25: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 ( '331739', '00E0633622F39A7BFC0A', '046', 'DESKTOP-UAEJFK1', '110', '1920', '1080', 'ys8230884', '(주)유성건재철물[정연순]', '959984696638' ) ========================2020-12-07 14:17:17======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 702C1F3ABC2188122463 sCDKey = 132056757826 sName = USER-PC ========================2020-12-07 14:17: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 = '132056757826' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 14:17:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'uniongas' ========================2020-12-07 14:17:18======================== SELECT idx FROM macs WHERE mac_addr = '702C1F3ABC2188122463' AND app_code = '039' ========================2020-12-07 14:17:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330796' ========================2020-12-07 14:17:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330796' ========================2020-12-07 14:17:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '330796', '702C1F3ABC2188122463', '039', 'USER-PC', '90', '1366', '768', 'uniongas', '유니온가스상사[김관덕]', '132056757826' ) ========================2020-12-07 15:29:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QNHDLOD parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D6B5D2BA682BA7D sCDKey = 868093844893 sName = DESKTOP-QNHDLOD ========================2020-12-07 15:29: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 = '868093844893' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-07 15:29:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nk5326' ========================2020-12-07 15:29:30======================== SELECT idx FROM macs WHERE mac_addr = '18C04D6B5D2BA682BA7D' AND app_code = '039' ========================2020-12-07 15:29:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331790' ========================2020-12-07 15:29:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331790' ========================2020-12-07 15:29: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 ( '331790', '18C04D6B5D2BA682BA7D', '039', 'DESKTOP-QNHDLOD', '110', '1920', '1080', 'nk5326', '남광레이져[정병하]', '868093844893' )