windows上powershell获取登录日志
# 获取从9月到现在的登录事件日志 $loginEvents = Get-EventLog -LogName Security -InstanceId 4624 -After (Get-Date -Year 2023 -Month 9 -Day 1) | Where-Object {$_.ReplacementStrings[5] -eq "Administrator"} # 创建一个空数组,用于存储登录事件信息 $eventArray = @() # 遍历登录事件日志并提取感兴趣的远程细节信息 foreach ($event in $loginEvents) { $time = $event.TimeGenerated $username = $event.ReplacementStrings[5] $sourceIP = $event.ReplacementStrings[18] $sourceWorkstation = $event.ReplacementStrings[11] # 将登录事件信息添加到数组中 $eventArray += [PSCustomObject]@{ "登录时间" = $time "用户名" = $username "源IP地址" = $sourceIP "源工作站" = $sourceWorkstation } } # 构建桌面上的文件路径 $desktopPath = [System.IO.Path]::Combine($home, "Desktop\login_events.csv") # 将数组输出到 CSV 文件中 $eventArray | Export-Csv -Path $desktopPath -Encoding UTF8 -NoTypeInformationopenEuler release 23.09 换yum源
openEuler release 23.09
[OS] name=OS baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/OS/$basearch/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/OS/$basearch/RPM-GPG-KEY-openEuler [everything] name=everything baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/everything/$basearch/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/everything/$basearch/RPM-GPG-KEY-openEuler [EPOL] name=EPOL baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/EPOL/main/$basearch/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/OS/$basearch/RPM-GPG-KEY-openEuler [debuginfo] name=debuginfo baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/debuginfo/$basearch/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/debuginfo/$basearch/RPM-GPG-KEY-openEuler [source] name=source baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/source/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/source/RPM-GPG-KEY-openEuler [update] name=update baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/update/$basearch/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/OS/$basearch/RPM-GPG-KEY-openEuler [update-source] name=update-source baseurl=http://repo.huaweicloud.com/openeuler/openEuler-23.09/update/source/ metadata_expire=1h enabled=1 gpgcheck=1 gpgkey=http://repo.huaweicloud.com/openeuler/openEuler-23.09/source/RPM-GPG-KEY-openEuler
阿里云rds备份文件本地恢复-mysql-8
阿里云rds备份文件本地恢复-mysql-5.6
//参考官方文档
mysq批量导入脚本
备份文件目录结构
数据库1(文件夹)文件夹名称即为数据库名
表1(文件夹)文件夹名称即为表名
structure.sql(表结构)
data(数据文件夹)
*.sql(备份文件)
Windows-2008-32位域控dc升级到Windows-2012-R2过程记录
原始域控dc系统
现有域控dc为32位,先向域中增加64位windows-server-2008-r2
华为ssl vpn secoclient客户端 接收返回码超时
1.在设备管理器中将:SVN Adapter V1.0驱动禁用
python使用ip2Region库离线查询ip地址归属地,生成Excel报告
参考:
python使用ip2Region库查询ip地址归属地查询/ip朔源自动生成Excel报告
https://www.pythonheidong.com/blog/article/895015/58b65cf3aeda4f51d1f5/