powershell的查詢(xún)功能
1.用PowerShell查詢(xún)指定OU中所有賬號(hào)的創(chuàng)建時(shí)間\SID\上次修改密碼時(shí)間\最后一次登錄時(shí)間:
Get-ADuser -searchbase ' OU=LL,DC=LL,DC=COM ' -filter * -Properties * | Select-Object Name,SID, Created,PasswordLastSet,@{n="lastLogonDate";e={[datetime]::FromFileTime
($_.lastLogonTimestamp)}} | Export-CSV zuihoudenglu.csv -NoTypeInformation -Encoding UTF8
2.查詢(xún)AD中,默認(rèn)的密碼策略(密碼復(fù)雜性要注、鎖定策略、密碼長(zhǎng)度、密碼有效時(shí)間):Get-ADDefaultDomainPasswordPolicy
3.查詢(xún)AD中,哪些用戶(hù)被選中了“密碼永不過(guò)期”的選頂:
查詢(xún)域中被勾選了密碼永不過(guò)期選項(xiàng)的用戶(hù)
Get-ADUser -Filter 'PasswordNeverExpires -eq $true' -Server A | select name
查詢(xún)某個(gè)OU中被勾選了密碼永不過(guò)期選項(xiàng)的用戶(hù)并導(dǎo)出
Get-ADUser -searchbase ' OU=ll,DC=ll,DC=com ' -Filter 'PasswordNeverExpires -eq $true' -Server A | select name | Export-CSV mimayongbuguoqi.csv -NoTypeInformation -
Encoding UTF8
4.查詢(xún)AD中,已鎖定的用戶(hù)
get-aduser -filter * -properties * | where {$_.lockedout} | ft name,lockedout
5.查詢(xún)AD中,哪些郵件組是空成員
Get-ADGroup -Filter * -Properties Members | where { -not $_.Members} | select Name
6.查詢(xún)AD中OU所有一個(gè)月內(nèi)未登錄的AD帳號(hào)
Get-ADuser -searchbase ‘ OU=ll,DC=ll,DC=com ‘ -filter * -Properties * | Select-Object Name,SID, Created,PasswordLastSet,@{n="lastLogonDate";e=
{[datetime]::FromFileTime($_.lastLogonTimestamp)}} | where {$_.lastlogondate -lt (get-date).AddDays(-30)}
Get-ADuser -searchbase ' OU=ll,DC=ll,DC=com ' -filter * -Properties * | Select-Object Name,SID, Created,PasswordLastSet,@{n="lastLogonDate";e=
{[datetime]::FromFileTime($_.lastLogonTimestamp)}}
7.查詢(xún)AD中,被禁用的賬號(hào)
get-aduser -filter * -SearchBase "OU=ll,DC=ll,DC=com" | where {($_.enabled -eq $false) -and (($_.DistinguishedName).Contains("Leave") -eq $false)} | select
samaccountname,Surname,givenname,enabled,DistinguishedName | Export-Csv -Encoding Unicode -NoTypeInformation D:\ps\jinyongzhanghao.csv
8.查詢(xún)AD中,被禁用的賬號(hào),并啟用(啟用后導(dǎo)出的csv文件中為空,可能是因?yàn)樗鼘?dǎo)出文件是禁用的賬號(hào),而禁用的賬號(hào)已被啟用)
get-aduser -filter * -SearchBase "OU=ll,DC=ll,DC=com" | where {($_.enabled -eq $false) -and (($_.DistinguishedName).Contains("Leave") -eq $false)} | Export-Csv -
創(chuàng)新互聯(lián)公司主營(yíng)義安網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營(yíng)網(wǎng)站建設(shè)方案,手機(jī)APP定制開(kāi)發(fā),義安h5微信小程序開(kāi)發(fā)搭建,義安網(wǎng)站營(yíng)銷(xiāo)推廣歡迎義安等地區(qū)企業(yè)咨詢(xún)
Encoding Unicode -NoTypeInformation D:\ps\qiyongzhanghao.csv |Enable-ADAccount
9.查詢(xún)規(guī)定時(shí)間內(nèi)為登錄的計(jì)算機(jī)
Search-ADAccount -AccountInactive -TimeSpan "3" -ComputersOnly | select name | export-csv computertime.csv
$a=Import-Csv computertime.csv
foreach ($b in $a){
get-adcomputer $b.name | Move-ADObject -TargetPath "ou=delete,ou=ll,dc=ll,dc=com"
}
本文名稱(chēng):powershell的查詢(xún)功能
本文鏈接:http://www.xueling.net.cn/article/pighcs.html