EPM - Data Collection - Automate - Script Get - Battery Report

Summary

This script runs the agnostic script EPM - Data Collection - Agnostic - 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

• EPM - Data Collection - Agnostic - Get-BatteryReport.ps1
• CWM - Automate - Script - 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 CWM - Automate - Script - OverFlowedVariable - SQL Insert - Execute.
3. Run the agnostic process (EPM - Data Collection - Agnostic - Get-BatteryReport.ps1).
4. Run the automate script process (CWM - Automate - Script - OverFlowedVariable - SQL Insert - Execute).