psinfluxdb 0.3.0
dotnet add package psinfluxdb --version 0.3.0
NuGet\Install-Package psinfluxdb -Version 0.3.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="psinfluxdb" Version="0.3.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add psinfluxdb --version 0.3.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: psinfluxdb, 0.3.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install psinfluxdb as a Cake Addin #addin nuget:?package=psinfluxdb&version=0.3.0 // Install psinfluxdb as a Cake Tool #tool nuget:?package=psinfluxdb&version=0.3.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
psinfluxdb
PowerShell module for interaction to InfluxDB 1.x via API.
By default GET requests give line-by output. This module is used to automate the query form and output in object format.
Only GET requests.
🚀 Install
Install module from NuGet repository:
Install-Module psinfluxdb -Repository NuGet
Import module:
PS C:\Users\Lifailon> Import-Module psinfluxdb
PS C:\Users\lifailon> Get-Command -Module psinfluxdb
CommandType Name Version Source
----------- ---- ------- ------
Function Get-InfluxChart 0.3 psinfluxdb
Function Get-InfluxData 0.3 psinfluxdb
Function Get-InfluxDatabases 0.3 psinfluxdb
Function Get-InfluxPolicy 0.3 psinfluxdb
Function Get-InfluxTables 0.3 psinfluxdb
Function Get-InfluxUsers 0.3 psinfluxdb
📚 Examples
Get user list:
PS C:\Users\Lifailon> Get-InfluxUsers -server 192.168.3.102
user admin
---- -----
admin True
root True
read False
Get database list:
PS C:\Users\Lifailon> Get-InfluxDatabases -server 192.168.3.102
_internal
PowerShell
Creat and delete database:
PS C:\Users\lifailon> Get-InfluxDatabases -server 192.168.3.102 -creat -database test
_internal
PowerShell
test
PS C:\Users\lifailon> Get-InfluxDatabases -server 192.168.3.102 -delete -database test
_internal
PowerShell
Database storage policies (creat and set default):
PS C:\Users\lifailon> Get-InfluxPolicy -server 192.168.3.102 -database PowerShell
name : autogen
duration : 0s
shardGroupDuration : 168h0m0s
replicaN : 1
default : True
PS C:\Users\lifailon> Get-InfluxPolicy -server 192.168.3.102 -database PowerShell -creat -policyName del2d -hours 48
name : autogen
duration : 0s
shardGroupDuration : 168h0m0s
replicaN : 1
default : True
name : del2d
duration : 48h0m0s
shardGroupDuration : 24h0m0s
replicaN : 1
default : False
PS C:\Users\lifailon> Get-InfluxPolicy -server 192.168.3.102 -database PowerShell -policyName del2d -default
name : autogen
duration : 0s
shardGroupDuration : 168h0m0s
replicaN : 1
default : False
name : del2d
duration : 48h0m0s
shardGroupDuration : 24h0m0s
replicaN : 1
default : True
Get table (measurement) list:
PS C:\Users\Lifailon> Get-InfluxTables -server 192.168.3.102 -database PowerShell
performance
ping
speedtest
HardwareMonitor
Get data from table (measurement) selected:
PS C:\Users\Lifailon> Get-InfluxData -server 192.168.3.102 -database PowerShell -table ping | ft
time host rtime status
---- ---- ----- ------
07/08/2023-15:16:24 HUAWEI-MB-X-Pro 22 True
07/08/2023-15:16:29 HUAWEI-MB-X-Pro 20 True
07/08/2023-15:16:35 HUAWEI-MB-X-Pro 20 True
07/08/2023-15:16:41 HUAWEI-MB-X-Pro 20 True
07/08/2023-15:16:51 HUAWEI-MB-X-Pro 0 False
07/08/2023-15:17:06 HUAWEI-MB-X-Pro 32 True
07/08/2023-15:17:16 HUAWEI-MB-X-Pro 22 True
07/08/2023-15:17:27 HUAWEI-MB-X-Pro 20 True
07/08/2023-15:17:37 HUAWEI-MB-X-Pro 20 True
07/08/2023-15:17:47 HUAWEI-MB-X-Pro 21 True
...
Get data for the last 30 minutes from HardwareMonitor:
PS C:\Users\lifailon> Get-InfluxData -server 192.168.3.102 -database PowerShell -table HardwareMonitor -minutes 30 | Format-Table
time HardwareName Host SensorName SensorType Value
---- ------------ ---- ---------- ---------- -----
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#1 Temperature_0 24
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#1_Distance_to_TjMax Temperature_7 76
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#2 Temperature_1 24
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#2_Distance_to_TjMax Temperature_8 76
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#3 Temperature_2 23
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#3_Distance_to_TjMax Temperature_9 77
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#4 Temperature_3 22
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#4_Distance_to_TjMax Temperature_10 78
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#5 Temperature_4 23
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#5_Distance_to_TjMax Temperature_11 77
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#6 Temperature_5 22
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Core_#6_Distance_to_TjMax Temperature_12 78
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 CPU_Package Temperature_6 24
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 Core_Average Temperature_14 23
02/03/2024-22:27:45 Intel_Core_i5-10400 PLEX-01 Core_Max Temperature_13 24
02/03/2024-22:27:45 MSI_M390_250GB PLEX-01 Temperature Temperature_0 34
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 CPU Temperature_0 28
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 CPU_Socket Temperature_4 27
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 M2_1 Temperature_6 23
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 PCH Temperature_3 36
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 PCIe_x1 Temperature_5 29
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 System Temperature_1 30
02/03/2024-22:27:45 Nuvoton_NCT6687D PLEX-01 VRM_MOS Temperature_2 36
02/03/2024-22:27:45 Radeon_RX_570_Series PLEX-01 GPU_Core Temperature_0 34
02/03/2024-22:27:45 ST1000DM003-1CH162 PLEX-01 Temperature Temperature_0 31
02/03/2024-22:27:45 WDC_WD2005FBYZ-01YCBB2 PLEX-01 Temperature Temperature_0 33
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#1 Temperature_0 47
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#10 Temperature_9 45
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#10_Distance_to_TjMax Temperature_22 55
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#11 Temperature_10 45
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#11_Distance_to_TjMax Temperature_23 55
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#12 Temperature_11 45
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#12_Distance_to_TjMax Temperature_24 55
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#1_Distance_to_TjMax Temperature_13 53
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#2 Temperature_1 48
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#2_Distance_to_TjMax Temperature_14 52
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#3 Temperature_2 47
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#3_Distance_to_TjMax Temperature_15 53
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#4 Temperature_3 45
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#4_Distance_to_TjMax Temperature_16 55
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#5 Temperature_4 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#5_Distance_to_TjMax Temperature_17 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#6 Temperature_5 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#6_Distance_to_TjMax Temperature_18 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#7 Temperature_6 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#7_Distance_to_TjMax Temperature_19 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#8 Temperature_7 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#8_Distance_to_TjMax Temperature_20 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#9 Temperature_8 45
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Core_#9_Distance_to_TjMax Temperature_21 55
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 50
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK Core_Average Temperature_26 47
02/03/2024-22:27:50 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK Core_Max Temperature_25 50
...
💡 Now we can filter the received data in the usual way (without resorting to SQL queries):
$Data | Where-Object {$_.SensorName -match "Package" -and $_.Value -gt 90} | Format-Table
time HardwareName Host SensorName SensorType Value
---- ------------ ---- ---------- ---------- -----
02/10/2024-19:05:24 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 95
02/10/2024-19:20:01 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 92
02/10/2024-19:20:24 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 94
02/10/2024-19:29:04 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 99
02/10/2024-19:30:20 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 98
02/10/2024-19:30:32 12th_Gen_Intel_Core_i7-1260P HUAWEI-BOOK CPU_Package Temperature_12 92
📈 Charts
The Grafana alternative (used WinForms) to create graphs from data obtained with the Ookla-SpeedTest module.
$influx = Get-InfluxData -server 192.168.3.104 -database PowerShell -table speedtest
Get-InfluxChart -time ($influx.time) -data ($influx.download) -title "SpeedTest Download" -path "C:\Users\Lifailon\Desktop"
Get-InfluxChart -time ($influx.time) -data ($influx.upload) -title "SpeedTest Upload" -path "C:\Users\Lifailon\Desktop"
There are no supported framework assets in this package.
Learn more about Target Frameworks and .NET Standard.
This package has no dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.