Skip to content

Instantly share code, notes, and snippets.

@christian-korneck
Created March 26, 2023 15:15
Show Gist options
  • Save christian-korneck/ff7d5f55a74274ad3599663cd2337c05 to your computer and use it in GitHub Desktop.
Save christian-korneck/ff7d5f55a74274ad3599663cd2337c05 to your computer and use it in GitHub Desktop.
powershell query with appsmith

quick & dirty powershell query with appsmith

(WARNING - very insecure)

on windows worker (here on docker host):

webify powershell -c "Get-WmiObject -Class win32_processor | Select-Object -Property Caption, DeviceID, Manufacturer, MaxClockSpeed, Name, SocketDesignation | ConvertTo-Json -Compress"
2023/03/26 16:31:11 listening on :8080, proxying to powershell -c Get-WmiObject -Class win32_processor | Select-Object -Property Caption, DeviceID, Manufacturer, MaxClockSpeed, Name, SocketDesignation | ConvertTo-Json -Compress

webify from: https://github.com/beefsack/webify

appsmith query:

REST API GET:

http://host.docker.internal:8080

appsmith table data source:

[{{JSON.parse(webify1.data)}}]

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment