Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities:
Currently, data security is very crucial in a company. Data hacking is increasingly common. Tokopedia experienced a data hack estimated at 91 million user accounts and 7 million merchant accounts. This data is then sold via the dark web, which seriously endangers user privacy and safety. Protection...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
LPPM Universitas Mohammad Husni Thamrin
2025-03-01
|
| Series: | Jurnal Teknologi Informatika & Komputer |
| Online Access: | https://journal.thamrin.ac.id/index.php/jtik/article/view/2242 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1850116938198417408 |
|---|---|
| author | Jong Jek Siang Rio Rian Rivanka Argo Wibowo |
| author_facet | Jong Jek Siang Rio Rian Rivanka Argo Wibowo |
| author_sort | Jong Jek Siang |
| collection | DOAJ |
| description | Currently, data security is very crucial in a company. Data hacking is increasingly common. Tokopedia experienced a data hack estimated at 91 million user accounts and 7 million merchant accounts. This data is then sold via the dark web, which seriously endangers user privacy and safety. Protection of personal data against hackers from outside is increasingly needed. Management of data recaps and monitoring employee data access in the largest retail company in Indonesia is carried out by the Human Resources division. Due to the large number of employees, daily access to employee data such as attendance is prone to misuse because detection of illegal activities on data is still done manually. In this research, a system based on Google Spreadsheet and Apps Script was created. which is able to detect illegal activities against employee databases. The system is able to accurately categorize logs based on account and IP address, distinguishing between normal and suspicious logs. The system is able to convert a spreadsheet containing data access recaps into an Excel file and send it to the specified email. System testing was carried out on Human Resources division employees through 6 tests on all system features. The results show that all system outputs are exactly as expected. The system helps Human Resources division employees observe data changes without having to access the database, making it easier to detect illegal data access. |
| format | Article |
| id | doaj-art-56ff4e00551647288e19c1fb4cdf4cd6 |
| institution | OA Journals |
| issn | 2656-9957 2622-8475 |
| language | English |
| publishDate | 2025-03-01 |
| publisher | LPPM Universitas Mohammad Husni Thamrin |
| record_format | Article |
| series | Jurnal Teknologi Informatika & Komputer |
| spelling | doaj-art-56ff4e00551647288e19c1fb4cdf4cd62025-08-20T02:36:12ZengLPPM Universitas Mohammad Husni ThamrinJurnal Teknologi Informatika & Komputer2656-99572622-84752025-03-0111111510.37012/jtik.v11i1.22422125Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities:Jong Jek Siang0Rio Rian Rivanka1Argo Wibowo2Universitas Kristen Duta WacanaUniversitas Kristen Duta WacanaUniversitas Kristen Duta WacanaCurrently, data security is very crucial in a company. Data hacking is increasingly common. Tokopedia experienced a data hack estimated at 91 million user accounts and 7 million merchant accounts. This data is then sold via the dark web, which seriously endangers user privacy and safety. Protection of personal data against hackers from outside is increasingly needed. Management of data recaps and monitoring employee data access in the largest retail company in Indonesia is carried out by the Human Resources division. Due to the large number of employees, daily access to employee data such as attendance is prone to misuse because detection of illegal activities on data is still done manually. In this research, a system based on Google Spreadsheet and Apps Script was created. which is able to detect illegal activities against employee databases. The system is able to accurately categorize logs based on account and IP address, distinguishing between normal and suspicious logs. The system is able to convert a spreadsheet containing data access recaps into an Excel file and send it to the specified email. System testing was carried out on Human Resources division employees through 6 tests on all system features. The results show that all system outputs are exactly as expected. The system helps Human Resources division employees observe data changes without having to access the database, making it easier to detect illegal data access.https://journal.thamrin.ac.id/index.php/jtik/article/view/2242 |
| spellingShingle | Jong Jek Siang Rio Rian Rivanka Argo Wibowo Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: Jurnal Teknologi Informatika & Komputer |
| title | Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: |
| title_full | Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: |
| title_fullStr | Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: |
| title_full_unstemmed | Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: |
| title_short | Automation of Daily Access Data Recap of Employee Data Tables Using Apps Script to Detect Illegal Activities: |
| title_sort | automation of daily access data recap of employee data tables using apps script to detect illegal activities |
| url | https://journal.thamrin.ac.id/index.php/jtik/article/view/2242 |
| work_keys_str_mv | AT jongjeksiang automationofdailyaccessdatarecapofemployeedatatablesusingappsscripttodetectillegalactivities AT riorianrivanka automationofdailyaccessdatarecapofemployeedatatablesusingappsscripttodetectillegalactivities AT argowibowo automationofdailyaccessdatarecapofemployeedatatablesusingappsscripttodetectillegalactivities |