========================2019-02-21 09:49:47======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41FAC2A942362F3 sCDKey = 983017299189 sName = ADMINISTRATOR ========================2019-02-21 09:49:47======================== 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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 09:49:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2019-02-21 09:49:47======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41FAC2A942362F3' AND app_code = '046' ========================2019-02-21 09:49:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272041' ========================2019-02-21 09:49:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272041' ========================2019-02-21 09:49:47======================== UPDATE mac_detail SET pc_name = 'ADMINISTRATOR', os_type = '90', user_id = 'bbongga33', user_name = '지장산막국수[정학본]', screen_w = '1024', screen_h = '768', cdkey = '983017299189' WHERE mac_idx = '272041' ========================2019-02-21 09:49:51======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41FAC2A942362F3 sCDKey = 983017299189 sName = ADMINISTRATOR ========================2019-02-21 09:49:51======================== 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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 10:21:15======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-JC752TD parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 988389815D78F6964316 sCDKey = 678061938278 sName = DESKTOP-JC752TD ========================2019-02-21 10:21:15======================== 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 = '678061938278' AND r.app_code = '050' AND r.app_block = 0 ========================2019-02-21 10:21:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gpmc31101151' ========================2019-02-21 10:21:15======================== SELECT idx FROM macs WHERE mac_addr = '988389815D78F6964316' AND app_code = '050' ========================2019-02-21 10:21:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277809' ========================2019-02-21 10:21:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277809' ========================2019-02-21 10:21:15======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '277809', '988389815D78F6964316', '050', 'DESKTOP-JC752TD', '109', '1920', '1080', 'gpmc31101151', '경기도의료원 이천병원[이희천]', '678061938278' ) ========================2019-02-21 10:54:21======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 60029243A2B8C0A59A4B sCDKey = 539780742967 sName = POS ========================2019-02-21 10:54: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 = '539780742967' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 10:54:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nfcf077' ========================2019-02-21 10:54:21======================== SELECT idx FROM macs WHERE mac_addr = '60029243A2B8C0A59A4B' AND app_code = '046' ========================2019-02-21 10:54:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '128129' ========================2019-02-21 10:54:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '128129' ========================2019-02-21 10:54:21======================== UPDATE mac_detail SET pc_name = 'POS', os_type = '64', user_id = 'nfcf077', user_name = '공주시산림조합[김생연]', screen_w = '1024', screen_h = '768', cdkey = '539780742967' WHERE mac_idx = '128129' ========================2019-02-21 12:26:08======================== noteurl_start parm_app_code = 046 parm_pc_name = OHMYPOS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732D97815A0E160A sCDKey = 322315247343 sName = OHMYPOS ========================2019-02-21 12:26:08======================== 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 = '322315247343' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 12:26:17======================== noteurl_start parm_app_code = 046 parm_pc_name = OHMYPOS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732D97815A0E160A sCDKey = 322315247343 sName = OHMYPOS ========================2019-02-21 12:26: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 = '322315247343' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 13:05:45======================== noteurl_start parm_app_code = 046 parm_pc_name = OHMYPOS parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732D97815A0E160A sCDKey = 322315247343 sName = OHMYPOS ========================2019-02-21 13:05: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 = '322315247343' AND r.app_code = '046' AND r.app_block = 0 ========================2019-02-21 13:05:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ohmyshoes' ========================2019-02-21 13:05:45======================== SELECT idx FROM macs WHERE mac_addr = '50AF732D97815A0E160A' AND app_code = '046' ========================2019-02-21 13:05:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277833' ========================2019-02-21 13:05:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277833' ========================2019-02-21 13:05: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 ( '277833', '50AF732D97815A0E160A', '046', 'OHMYPOS', '90', '1024', '768', 'ohmyshoes', '[김현찬]', '322315247343' ) ========================2019-02-21 13:31:46======================== noteurl_start parm_app_code = 050 parm_pc_name = KR parm_os_type = 60 parm_screen_w = 1920 parm_screen_h = 976 parm_user_mac = 080027D1681714F1F33F sCDKey = 637698524487 sName = KR ========================2019-02-21 13:31: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 = '637698524487' AND r.app_code = '050' AND r.app_block = 0 ========================2019-02-21 13:31:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aej123456' ========================2019-02-21 13:31:46======================== SELECT idx FROM macs WHERE mac_addr = '080027D1681714F1F33F' AND app_code = '050' ========================2019-02-21 13:31:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '232267' ========================2019-02-21 13:31:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '232267' ========================2019-02-21 13:31: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 ( '232267', '080027D1681714F1F33F', '050', 'KR', '60', '1920', '976', 'aej123456', '엠제이소프트[안은준]', '637698524487' ) ========================2019-02-21 16:21:19======================== noteurl_start parm_app_code = 047 parm_pc_name = WIN7-20190220BG parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50B7C3ABE2520477A6F4 sCDKey = 782441303740 sName = WIN7-20190220BG ========================2019-02-21 16:21: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 = '782441303740' AND r.app_code = '047' AND r.app_block = 0 ========================2019-02-21 16:21:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'namseoul' ========================2019-02-21 16:21:19======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3ABE2520477A6F4' AND app_code = '047' ========================2019-02-21 16:21:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '277884' ========================2019-02-21 16:21:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '277884' ========================2019-02-21 16:21:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '277884', '50B7C3ABE2520477A6F4', '047', 'WIN7-20190220BG', '�쐢�룄�슦 7', '0', '0', 'namseoul', 'topgolf[정영균]', '782441303740' )