UI 網站

开启无敌模式，以快照方式启动，关机后开机会被还原
cat /etc/pve/qemu-server/190.conf
args:-snapshot

web界面中把虚拟机的“硬件”-“显示”设置“qxl”
修改/etc/pve/qemu-server/ 下的配置文件
echo "args: -spice ‘port=8101,disable-ticketing,seamless-migration=on,addr=0.0.0.0′
" >> /etc/pve/qemu-server/131.conf

args: -spice ‘port=9131,password=000000,seamless-migration=on,addr=0.0.0.0′
" >> /etc/pve/qemu-server/131.conf

addr=0.0.0.0容许网段
seamless-migration=on,password=12345’
seamless-migration=on QMP支持
password=xxxx,可以进行密码验证
disable-ticketing参数可以去掉密码验证

使用virt-viewer连接
remote-viewer spice://10.104.1.233:8101 –spice-usbredir-auto-redirect-filter="-1,0x24ae,-1,-1,0|-1,0x1c4f,-1,-1,0|-1,-1,-1,-1,1″ –spice-usbredir-redirect-on-connect="-1,0x24ae,-1,-1,0|-1,0x1c4f,-1,-1,0|-1,-1,-1,-1,1″ -f

其中-f 全屏
spice-usbredir-auto-redirect-filter 筛选插入的usb设备是否能不用勾选自动重定向到虚拟机内
spice-usbredir-redirect-on-connect 筛选spice-channel连接的时候是否能自动重定向已经插在物理机上的usb设备

usb acl
,,,,
<类> <供应商>，<产品>，<版本>，允许>
lsusb 标识转换
bus 003 device 003: ID 24ae:2010 其中24ae转换为 0x24ae 放在供应商哪里
USB内容参考

https://www.spice-space.org/usbredir.html

https://blog.csdn.net/FlayHigherGT/article/details/89332051

#!/bin/bash
#########################################################################
# File Name: systeminfo.sh
# Author: LookBack
# Email: admin#dwhd.org
# Version:
# Created Time: Sun 26 Jul 2015 05:53:31 PM CST
#########################################################################

uptime() {
#已開機時間
echo "系统开机时间:$(date -d "$(awk ‘{printf("%d\n",$1~/./?int($1)+1:$1)}’ /proc/uptime) second ago" +"%F %T")"
#已運行時間
awk ‘{a=$1/86400;b=($1%86400)/3600;c=($1%3600)/60;d=$1%60}{printf("系统已经运行%d天%d时%d分%d秒\n",a,b,c,d)}’ /proc/uptime
}

cpuinfo() {
#CPU型號
awk -F’:[ ]‘ ‘/model name/{printf ("CPU型号:%s\n",$2);exit}’ /proc/cpuinfo
#CPU細部
awk -F’:[ ]‘ ‘/physical id/{a[$2]++}END{for(i in a)printf ("%s号CPU\t线程数:%s\n",i+1,a[i]);printf("CPU总颗数:%s\n",i+1)}’ /proc/cpuinfo
#CPU頻率
awk ‘/model name/{print "CPU频率:"$NF;exit}’ /proc/cpuinfo
}

meminfo() {
#記憶體
awk ‘/MemTotal/{a=$2/(1024^2);if(a<1){a=$2/1024;printf ("内存:%dM\n",a~/\./?int(a)+1:a)}else printf("内存:%dG\n",a~/\./?int(a)+1:a)}’ /proc/meminfo
}

diskinfo() {
fdisk -l | awk ‘/(Disk )?\/dev\//’
}
case "$1″ in
cpu)
cpuinfo
;;
mem)
meminfo
;;
uptime)
uptime
;;
disk)
diskinfo
;;
all)
for i in `awk -F\( ‘/^([a-z]|[0-9]|_).*\(\)/{print $1}’ $0`; do $i && echo "";done
;;
*)
echo $"Usage: $0 {cpu|mem|uptime|disk|all}"
exit 2
esac

新建db_backup.sql檔案，填入以下內容。
– 定義需要備份的資料庫
DECLARE @backupDatabase VARCHAR(20) = ‘DB_NAME’

– 定義資料庫備份檔案存放的基礎路徑
DECLARE @backupBasePath VARCHAR(MAX) = ‘D:/DB_NAME/’

– 定義備份檔名，檔名格式：_backup__.bak
DECLARE @backupFileName VARCHAR(50) = NULL

– 獲取當前時間戳
DECLARE @backupTime DATETIME = CURRENT_TIMESTAMP

– 處理備份檔名稱
SET @backupFileName = @backupDatabase + ‘_backup_’ + CONVERT(VARCHAR(25), @backupTime, 112) + ‘_’ + REPLACE(CONVERT(VARCHAR(25), CURRENT_TIMESTAMP, 114), ‘:’, ") + ‘.bak’

– 處理完整的備份檔案路徑
SET @backupBasePath = @backupBasePath + @backupFileName

– 執行備份
BACKUP DATABASE @backupDatabase TO DISK = @backupBasePath

到這裡已經可以使用指令碼對資料庫進行備份，但仍需手動執行指令碼，無法實現自動定時備份的需求。
新建db_backup.bat檔案
sqlcmd -S localhost -U sa -P 123 -i ./db_backup.sql -o ./db_backup.log
sqlcmd -S <資料庫連線地址> -U <資料庫登入名> -P <資料庫密碼> -i <要執行的指令碼檔案> -o <執行日誌檔案>
3. 建立Windows任務計劃
輸入taskschd.msc開啟任務計劃程式對話方塊
輸入任務名稱
如果是伺服器環境，安全選項中務必選擇不管使用者是否登入都要執行
新建觸發器
設定觸發器為按預定計劃執行一次
在觸發器高階設定中選擇重複任務間隔根據需要設定，持續時間設定為無限期。這樣配置的結果就是在觸發後，無限期地每隔xx時間段重複一次
新建操作
選擇剛才新建的批處理指令碼
檢查批處理指令碼中是否包含有關目錄結構的語句，比如需要讀寫某個位置的檔案。如果有且是Windows Server 2012及以後的作業系統，就需要配置起始位置，起始位置設定為批處理的目錄即可。

@echo off
title Activate Windows Server (ALL versions) for FREE!&cls&echo ============================================================================&echo #Project: Activating Microsoft software products for FREE without software&echo ============================================================================&echo.&echo #Supported products:&echo http://bit.ly/kmsclientkeys&echo.&echo.&echo ============================================================================&echo Activating your Windows…&set i=1
cscript //nologo slmgr.vbs /ipk 4DWFP-JF3DJ-B7DTH-78FJB-PDRHK >nul&cscript //nologo slmgr.vbs /ipk 22XQ2-VRXRG-P8D42-K34TD-G3QQC >nul&cscript //nologo slmgr.vbs /ipk 7M67G-PC374-GR742-YH8V4-TCBY3 >nul&cscript //nologo slmgr.vbs /ipk RCTX3-KWVHP-BR6TB-RB6DM-6X7HP >nul&cscript //nologo slmgr.vbs /ipk 39BXF-X8Q23-P2WWT-38T2F-G3FPG >nul&cscript //nologo slmgr.vbs /ipk YQGMW-MPWTJ-34KDK-48M3W-X4Q6V >nul&cscript //nologo slmgr.vbs /ipk W7VD6-7JFBR-RX26B-YKQ3Y-6FFFJ >nul&cscript //nologo slmgr.vbs /ipk TM24T-X9RMF-VWXK6-X8JC9-BFGM2 >nul&cscript //nologo slmgr.vbs /ipk WYR28-R7TFJ-3X2YQ-YCY4H-M249D >nul&cscript //nologo slmgr.vbs /ipk GT63C-RJFQ3-4GMB6-BRFB9-CB83V >nul&cscript //nologo slmgr.vbs /ipk 74YFP-3QFB3-KQT8W-PMXWJ-7M648 >nul&cscript //nologo slmgr.vbs /ipk 489J6-VHDMP-X63PK-3K798-CPX3Y >nul&cscript //nologo slmgr.vbs /ipk YC6KT-GKW9T-YTKYR-T4X34-R7VHC >nul&cscript //nologo slmgr.vbs /ipk TT8MH-CG224-D3D7Q-498W2-9QCTX >nul&cscript //nologo slmgr.vbs /ipk 6TPJF-RBVHG-WBW2R-86QPH-6RTM4 >nul&cscript //nologo slmgr.vbs /ipk 48HP8-DN98B-MYWDG-T2DCC-8W83P >nul&cscript //nologo slmgr.vbs /ipk XNH6W-2V9GX-RGJ4K-Y8X6F-QGJ2G >nul&cscript //nologo slmgr.vbs /ipk HM7DN-YVMH3-46JC3-XYTG7-CYQJJ >nul&cscript //nologo slmgr.vbs /ipk XC9B7-NBPP2-83J2H-RHMBY-92BT4 >nul&cscript //nologo slmgr.vbs /ipk 4K36P-JN4VD-GDC6V-KDT89-DYFKP >nul&cscript //nologo slmgr.vbs /ipk 2WN2H-YGCQR-KFX6K-CD6TF-84YXQ >nul&cscript //nologo slmgr.vbs /ipk 8N2M2-HWPGY-7PGT9-HGDD8-GVGGY >nul&cscript //nologo slmgr.vbs /ipk BN3D2-R7TKB-3YPBD-8DRP2-27GG4 >nul&cscript //nologo slmgr.vbs /ipk KNC87-3J2TX-XB4WP-VCPJV-M4FWM >nul&cscript //nologo slmgr.vbs /ipk W3GGN-FT8W3-Y4M27-J84CP-Q3VJ9 >nul&cscript //nologo slmgr.vbs /ipk D2N9P-3P6X9-2R39C-7RTCD-MDVJX >nul&cscript //nologo slmgr.vbs /ipk JCKRF-N37P4-C2D82-9YXRT-4M63B >nul&cscript //nologo slmgr.vbs /ipk WC2BQ-8NRM3-FDDYY-2BFGV-KHKQY >nul&cscript //nologo slmgr.vbs /ipk CB7KF-BWN84-R7R2Y-793K2-8XDDG >nul&cscript //nologo slmgr.vbs /ipk WVDHN-86M7X-466P6-VHXV7-YY726 >nul&cscript //nologo slmgr.vbs /ipk N69G4-B89J2-4G8F4-WWYCC-J464C >nul&cscript //nologo slmgr.vbs /ipk WMDGN-G9PQG-XVVXX-R3X43-63DFG >nul&cscript //nologo slmgr.vbs /ipk DPCNP-XQFKJ-BJF7R-FRC8D-GF6G4 >nul&cscript //nologo slmgr.vbs /ipk 6Y6KB-N82V8-D8CQV-23MJW-BWTG6 >nul&cscript //nologo slmgr.vbs /ipk PTXN8-JFHJM-4WC78-MPCBR-9W4KR >nul&cscript //nologo slmgr.vbs /ipk 2HXDN-KRXHB-GPYC7-YCKFJ-7FVDG >nul&cscript //nologo slmgr.vbs /ipk N2KJX-J94YW-TQVFB-DG9YT-724CC >nul&cscript //nologo slmgr.vbs /ipk 6NMRW-2C8FM-D24W7-TQWMY-CWH2D >nul
:server
if %i%==1 set KMS_Sev=kms7.MSGuides.com
if %i%==2 set KMS_Sev=kms8.MSGuides.com
if %i%==3 set KMS_Sev=kms9.MSGuides.com
if %i%==4 goto notsupported
cscript //nologo slmgr.vbs /skms %KMS_Sev%:1688 >nul&echo ============================================================================&echo.&echo.
cscript //nologo slmgr.vbs /ato | find /i "successfully" && (echo.&echo ============================================================================&echo.&echo #My official blog: MSGuides.com&echo.&echo #How it works: bit.ly/kms-server&echo.&echo #Please feel free to contact me at msguides.com@gmail.com if you have any questions or concerns.&echo.&echo #Please consider supporting this project: donate.msguides.com&echo #Your support is helping me keep my servers running everyday!&echo.&echo ============================================================================&choice /n /c YN /m "Would you like to visit my blog [Y,N]?" & if errorlevel 2 exit) || (echo The connection to my KMS server failed! Trying to connect to another one… & echo Please wait… & echo. & echo. & set /a i+=1 & goto server)
explorer "http://MSGuides.com"&goto halt
:notsupported
echo ============================================================================&echo.&echo Sorry! Your version is not supported.&echo.
:halt
pause >nul

如何禁用 Microsoft Office 應用程序上煩人的通知欄。
1.打開你的 Office 應用
只需啟動具有煩人通知的 Office 程序即可。
2.打開隱私設置
轉到文件 > 選項 > 常規 > 隱私設置或主頁 > 信任中心 > 信任中心設置 > 隱私選項 > 隱私設置。
https://cdn.msguides.com/wp-content/uploads/2021/04/Remove-GET-GENUINE-OFFICE-You-may-be-a-victim-of-software-counterfeiting-notification.png
或
.從註冊表中刪除 KeyManagementServiceName
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\SoftwareProtectionPlatform" /f /v
KeyManagementServiceName
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OfficeSoftwareProtectionPlatform" /f /v KeyManagementServiceName

apt udpate
apt install code -y

export LANG=en_US
xdg-user-dirs-gtk-update
在按 updatenames

手動調整時間
會出現Failed to set time: Automatic time synchronization is enabled
先關閉自動 ntp
timedatectl set-ntp no
調整為 2021-03-01 14:10:40
timedatectl set-time "2021-03-01 14:10:40
調整完再開機
timedatectl set-ntp yes

REM 主選單
:MENU
cls

For /f "tokens=2 delims=: " %%A in (‘nslookup myip.opendns.com. resolver1.opendns.com 2^>NUL^|find "Address:"‘) Do (Set ExtIP=%%A)
@Echo.
Echo External IP is : %ExtIP%

REM 若有變動則寫入IP.log 檔中
if not "%ExtOldIP%" == "%ExtIP%" (
Echo Time:%time:~0,8% External IP is: %ExtIP% >> IP.log )

set ExtOldIP=%ExtIP%

REM 每隔多久重新偵測一次
timeout /t 5
goto menu

:END

route add
其他常用route 指令
● route add 用來加入路由路徑
例如：route add 192.168.0.0 mask 255.255.0.0 192.168.1.1 if 0×2 metric 20
指出 Network Destination、Netmask、Gateway、Interface 和 metric。
● route -p add 用來永久加入路由路徑，使用-p 參數可以保留路徑設定，不會因為電腦重開機而消失。
例如：route -p add 192.168.0.0 mask 255.255.0.0 192.168.1.1 if 0×2 metric 20。
● route delete 用來刪除路由路徑。
例如：route delete 192.168.0.0 mask 255.255.0.0。
● route change 用來修改現有的路徑設定。
例如：route change 192.168.0.0 mask 255.255.0.0 192.168.1.1 if 0×2 metric 10
將原先路徑設定的 metric 20 改為 10，這種修改最直接的影響就是改變路徑的選擇，如果有兩條路徑可以選之時，metric 較低的路徑將被優先考慮。

打上你要新增的路由 以下面為例（含指令（route add）+IP+MASK+閘道+介面計量+網卡號碼）：
route add 10.115.50.0 mask 255.255.255.0 10.115.50.1 metric 1500 IF 14

Tracert