Archive for June, 2017
EXCEL TRICKS
06/08/2017
No comments
Check if Cell A matches Cell B
=IF(A1=B1,”match”,””)
Check if value in Cell A matches in Column B
=IF(ISERROR(MATCH(A1,B:B, 0)), “No Match”, “Match”)
Categories: Uncategorized
Detecting members of protected group in AD
To get the list of protected users:
Get-ADUser -LDAPFilter “(admincount=1)” | select name
To get the list of protected groups:
Get-ADGroup -LDAPFilter “(admincount=1)” | select name
To get the list of protected users and export:
Get-ADUser -LDAPFilter “(admincount=1)” | select name | Export-csv c:\users\users.csv
To get the list of protected groups and export:
Get-ADGroup -LDAPFilter “(admincount=1)” | select name | Export-csv c:\users\users.csv
Categories: Uncategorized