Automated Report Mailer for Industrial Production Monitoring Using Genesis Workbench and Microsoft SQL Server
International Journal of Advanced Research in Science Communication and Technology · 29.07.2026 · 662
DOI: 10.48175/ijarsct-37873 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Advanced Research in Science Communication and Technology, online erschienen am 29.07.2026. Verfasst von Dr. Arvind A. R und 3 weiteren Autor:innen. Die Arbeit nennt 52 Literaturangaben.
Abstract (Originalsprache)
Data in discrete manufacturing environments are constantly generated and stored in centralised database servers, but the reports derived from this data are typically created manually. The manual process of extracting, formatting and sending production reports via e-mails is time-consuming, error-prone and makes data available to supervisors later than necessary. In this paper, we present an automated report mailing application that integrates a Microsoft SQL Server production database, Genesis Workbench reporting engine and SMTP services to deliver asset status reports automatically without manual work required. The two stored procedures Storedprocedure A and Stored procedure B encapsulate the query and filtering functionality for the related assets, plants and lines; Genesis Workbench converts the results into a pre-designed report and sends it as an e-mail attachment to designated recipients. The system has been tested using actual plant data at an automotive manufacturing facility and successfully demonstrated connectivity and accuracy of data extraction as well as reliability of delivery of e-mails. It allowed to decrease the report processing cycle time from about 28 minutes to less than 3 minutes and completely eliminate manual entry errors
Zitieren
APA
R, D. A. A., Egalapati, R., R, V., & R, R. (2026). Automated Report Mailer for Industrial Production Monitoring Using Genesis Workbench and Microsoft SQL Server. International Journal of Advanced Research in Science Communication and Technology, 662. https://doi.org/10.48175/ijarsct-37873
Vancouver
R DAA, Egalapati R, R V, R R. Automated Report Mailer for Industrial Production Monitoring Using Genesis Workbench and Microsoft SQL Server. International Journal of Advanced Research in Science Communication and Technology. 2026:662. doi:10.48175/ijarsct-37873
BibTeX
@article{R2026,
author = {R, Dr. Arvind A. and Egalapati, Raviteja and R, Vignesh and R, Ramkumar},
title = {Automated Report Mailer for Industrial Production Monitoring Using Genesis Workbench and Microsoft SQL Server},
journal = {International Journal of Advanced Research in Science Communication and Technology},
year = {2026},
pages = {662},
doi = {10.48175/ijarsct-37873}
}
EUVIMED