Run a CMD command in Inputs.Exec

[raider111111]

Relevant telegraf.conf:

[[inputs.exec]]
name_prefix = "prod.compute_services.machine_metrics."
  ## Commands array
  commands = ["PowerShell -Command "(((C:\test\telegraf.exe --version) -split '\s+')[1] | ForEach-Object{$M = $_});$M.Remove($M.LastIndexOf('.'),1)| Write-Output | ForEach-Object{[float]$end = $_};$end""]
  interval = "30s"

  ## Timeout for each command to complete.
  timeout = "5s"

  ## measurement name suffix (for separating different commands)
  #name_suffix = "_mycollector"
  name_override = "TelegrafVersion"

  ## Data format to consume.
  ## Each data format has its own unique set of configuration options, read
  ## more about them here:
  ## https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md
  data_format = "value"
  data_type = "float"

System info:

Telegraf 1.11.0 Windows 10

Steps to reproduce:

1. Use inputs.exec to run a CMD command that calls PowerShell.

Expected behavior:

Runs the command and accepts the output, then sends the data to the monitoring appliance. This command works normally in CMD or when Telegraf calls it from a .bat file.

Actual behavior:

The Telegraf service doesn't start.

Additional info:

For security reasons we don't want to deploy out a .bat file for inputs.exec. Instead we would like to just place the CMD command inside the command block of inputs.exec.

[danielnelson]

Try using triple quotes for your string, so that you can use the " inside to quote the powershell command:

commands = ['''PowerShell -Command "(((C:\test\telegraf.exe --version) -split '\s+')[1] | ForEach-Object{$M = $_});$M.Remove($M.LastIndexOf('.'),1)| Write-Output | ForEach-Object{[float]$end = $_};$end"''']

You might be interested in #5958 too.

[raider111111]

That worked!

You're a busy guy, I see you all over the place!

Here's the output for anyone who's interested:

metrics.TelegrafVersion,host=COMPUTERNAME value=1.82 1560974282000000000

Thanks!