3. 数据库与Excel操作3.1 SQL查询 (MySQL/MSSQL)IPguard相关查询:查在线用户:SELECT ... FROM AGENT WHERE DATEDIFF(NOW(), AGENT.AGT_ONLINE_TIME)=0查用户组:SELECT AGENT_GROUP.AGT_GRP_NAME FROM AGENT_GROUPActive Directory相关查询:...
2. 常用命令与脚本2.1 系统信息与硬件目的Windows命令Linux命令查看序列号/资产号wmic bios get serialnumber`dmidecode \grep "Serial Number*"`查看系统启动时间wmic path Win32_OperatingSystem get LastBootUpTimeuptime查看CPU逻辑核数wmic cpu get Num...