Get - Battery Report

Summary

This script runs the agnostic script Get-BatteryReport.ps1 and imports the retrieved data into plugin_proval_batteries.

Sample Run

The intention of this script is to serve as an autofix for an internal monitor named Proval - Production - DailyScript - Get-BatteryReport.

Dependencies

• Get-BatteryReport.ps1
• OverFlowedVariable - SQL Insert - Execute

Variables

Name	Description
TableName	The name of the table to be created if it doesn't exist.
ColumnNamesSQL	The columns in the table in comma-separated format.
JsonFileName	Necessary when using OverFlowedVariable - SQL Insert - Execute
SQLStartStatement	The formatted SQL statement from INSERT INTO to VALUES.
SQLTailString	The tail string for the SQL statement from ON DUPLICATE to the end of the query.
DatapointNames	Needed when using OverFlowedVariable - SQL Insert - Execute

Process

1. Create the custom table if it doesn't exist.
2. Set up variables for OverFlowedVariable - SQL Insert - Execute.
3. Run the agnostic process (Get-BatteryReport.ps1).
4. Run the automate script process (OverFlowedVariable - SQL Insert - Execute).