========================2018-05-31 08:22:00======================== 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 = CCB0DA1AD98D12A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-05-31 08:22: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 08:30:26======================== 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 = CCB0DA1AD98D12A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-05-31 08:30: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 09:01:47======================== 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 = CCB0DA1AD98D12A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-05-31 09:01: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 09:01:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ys9270' ========================2018-05-31 09:01:47======================== SELECT idx FROM macs WHERE mac_addr = 'CCB0DA1AD98D12A3E273' AND app_code = '039' ========================2018-05-31 09:01:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '218956' ========================2018-05-31 09:01:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '218956' ========================2018-05-31 09:01:47======================== 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 = '218956' ========================2018-05-31 09:01:55======================== 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 = CCB0DA1AD98D12A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-05-31 09:01: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 = '428662420564' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 09:02:04======================== 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 = CCB0DA1AD98D12A3E273 sCDKey = 428662420564 sName = DESKTOP-FC3O7PH ========================2018-05-31 09:02:04======================== 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-05-31 14:51:38======================== noteurl_start parm_app_code = 039 parm_pc_name = USER150450-PC parm_os_type = 90 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 00241DCD01C0E253CDA7 sCDKey = 507548683004 sName = USER150450-PC ========================2018-05-31 14:51:38======================== 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 = '507548683004' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 14:51:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aaa205' ========================2018-05-31 14:51:38======================== SELECT idx FROM macs WHERE mac_addr = '00241DCD01C0E253CDA7' AND app_code = '039' ========================2018-05-31 14:51:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250989' ========================2018-05-31 14:51:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250989' ========================2018-05-31 14:51:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250989', '00241DCD01C0E253CDA7', '039', 'USER150450-PC', '90', '2560', '1440', 'aaa205', '무주형기스카이[이영호]', '507548683004' ) ========================2018-05-31 15:07:47======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-ROOM parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AAD4C121D42800EF sCDKey = 420380571543 sName = OFFICE-ROOM ========================2018-05-31 15:07: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 = '420380571543' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 15:07:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eoehd2658' ========================2018-05-31 15:07:47======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAD4C121D42800EF' AND app_code = '039' ========================2018-05-31 15:07:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '169995' ========================2018-05-31 15:07:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '169995' ========================2018-05-31 15:07:47======================== UPDATE mac_detail SET pc_name = 'OFFICE-ROOM', os_type = '110', user_id = 'eoehd2658', user_name = '대동강한복[박진철]', screen_w = '1366', screen_h = '768', cdkey = '420380571543' WHERE mac_idx = '169995' ========================2018-05-31 16:01:04======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-05-31 16:01:04======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 16:01:28======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-05-31 16:01: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 16:01:52======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-05-31 16:01: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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 16:02:18======================== noteurl_start parm_app_code = 039 parm_pc_name = JINA parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A104916AE4A07A sCDKey = 049554512864 sName = JINA ========================2018-05-31 16:02:18======================== 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 = '049554512864' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 17:57:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VAJ1817 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B06EBFD15D2BE4E902D3 sCDKey = 681282865677 sName = DESKTOP-VAJ1817 ========================2018-05-31 17:57: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 = '681282865677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-31 17:57:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjd06601' ========================2018-05-31 17:57:00======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBFD15D2BE4E902D3' AND app_code = '039' ========================2018-05-31 17:57:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251019' ========================2018-05-31 17:57:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251019' ========================2018-05-31 17:57:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '251019', 'B06EBFD15D2BE4E902D3', '039', 'DESKTOP-VAJ1817', '110', '1280', '1024', 'kjd06601', '우리상사[김진두]', '681282865677' )