LINUX script data output in Microsoft SQL server

[yasirvohra]

Hi,

SCENARIO :
I have created script on Rhel 7 which is giving output for CPU,RAM,HDD (root) usage and saving output values in (.csv) file /mnt/report.csv for now.

---

#!/bin/bash
#--------Print Operating System Details--------#
HOSTNAME=$(hostname)
#--------Check for HDD--------#
DISK_USAGE=df -h / | awk '{ print $5}' | tail -1
#--------Check for CPU Utilization--------#
CPU_IDLE=top -b -n 1 | grep Cpu | awk '{print $8}'|cut -f 1 -d "."
CPU_USED=expr 100 - $CPU_IDLE
#--------Check for MEMORY Utilization--------#
MEM_USGAE=free | grep Mem | awk '{print $3/$2 * 100.0}' | cut -f1 -d'.'
TIME=date +%H:%M
DATE=date +%d/%m/%Y

echo "$HOSTNAME,$DATE,$TIME,${CPU_USED}%,${MEM_USGAE}%,${DISK_USAGE}" >> /mnt/report.csv

---

Secondly I have schedule cron job to run this script every after 10 minutes --> so in file (/mnt/report.csv) I am getting data every after 10 minutes.

Requirement :
I have Microsoft SQL Server running on windows server 2019 already. I need to send output from this script (CPU,RAM,HDD - usage) directly to (Microsoft SQL Server database - table) rather then file (/mnt/report.csv) every after 10 minutes.

Any advice or help please what needs to be done ??

 

[dos2unix]

Install the Microsoft ODBC driver for SQL Server (Linux) - ODBC Driver for SQL Server

Learn how to install the Microsoft ODBC Driver for SQL Server on Linux clients to enable database connectivity.

docs.microsoft.com

 

[yasirvohra]

Hi, Thanks for the document. With this i can install driver for SQL server but how can i create connectivity and send values coming from script to SQL SERVER database table. Thanks in advance.