Archive

Archive for June, 2017

EXCEL TRICKS

June 8, 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 Tags:

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 Tags: