Postman以webapi抓取zabbix資料

• 在zabbix新增API token (只要做一次，要把token存下來)

Run powershell with TaskSchd 工作排程器

Reference:

PowerShell：備份檔案及工作排程器設定

 

在工作排程器執行 powershell，不能直接指定 ps1 檔案。

 

設定方法：

需要在「程式或指令碼」打powershell

「新增引數」打-file “C:\script\import.ps1” 才能正常運行

 

2024/10/23 update:

如果要把output & error 輸出到檔案，「新增引數」打-file “C:\script\import.ps1 *> log.txt”

Reference: 

How to log the output of a PowerShell script when running it as a scheduled task?

Powershell Script for Microsoft SQL server

Reference:

Insert Data Into SQL Server Table Using PowerShell

Connect to SQL Server Database from PowerShell

 

#連線資料庫
$serverName = "SQL01"
$databaseName = "wiside"
$tableName = "dbo.raw_data"
$uid = 'sa'
$pwd = 'mypassword'

$Connection = New-Object System.Data.SQLClient.SQLConnection
$Connection.ConnectionString = "server='$serverName';database='$databaseName';User ID = $uid; Password = $pwd;"
$Connection.Open()
$Command = New-Object System.Data.SQLClient.SQLCommand
$Command.Connection = $Connection

$insertquery="INSERT INTO $tableName ([ID],[mac],[vendor],[datetime]) VALUES ('$ID','$mac','$vendor','$datetime')"

$Command.CommandText = $insertquery

$Command.ExecuteNonQuery()

$Connection.Close();

catch exception on powershell script

Reference: 

在 PowerShell 中使用 Try/Catch 捕捉錯誤訊息

try {
    # 主要程式邏輯
}
catch [System.NotSupportedException] {
    Write-Output "不支援"
}
catch [System.IO.DirectoryNotFoundException] {
    Write-Output "找不到資料夾"
}
catch {
    Write-Output "通用的例外處理"
}

Powershell script 登入網頁、執行指令 (未完成)

Reference:

Logging Into webpage with Invoke-WebRequest

Login and download a file in web using powershell

PowerShell Tip of the Week: Create Invoke-WebRequest from Chrome 

 

狀況：

有一支IPCAM的NTP有問題，這家廠商已經不提供韌體更新。

登入它的管理網頁有手動同步時間，這功能正常。
我想用powershell script登入IPCAM，再click "time sync"。

但是這一支IPCAM的登入網頁用javascript，我就卡住了.....
 

使用 Powershell ISE

 

$azr = Invoke-WebRequest -Uri "http://211.72.66.73:8120/" -SessionVariable sbv
$azr
$azr|gm
$azr.Forms
$dbform = $azr.Forms["myForm"]
$dbform.Fields
$dbform.Fields["Username"] = "username"
$dbform.Fields["Password"] = "password"
$dbform.Action
$r = Invoke-WebRequest -Uri "http://211.72.66.73:8120/" -WebSession $sbv -Method Post -Body $dbform.Fields