Category Archives: csvde

How to extract the user who has the option Password never expires in the OU

To extract all the users in the OU with the Password never expires details, we can user Dsquery or CSVDE commands

Use the blow command to find and export users with   Password never expires in Active Directory

Dsquery command

dsquery user “OU=Test,DC=test,DC=com” -limit 0 | dsget user -pwdneverexpires >c:tempUsers.txt

dsquery user “OU=Test,DC=test,DC=com” –o rdn -limit 0> c:tempUsers1.txt

Collect this two … [Continue reading]

How to extract bulk object from AD with the specific attributes (Part 1)

Bulk reporting from AD (Part 1)

Extracting the object information from AD is the frequent task for active directory administrators, most of the administrator’s uses script to do the task, but we can use the simple command to extract bulk object from AD

If you want specific attribute details for all the users from TEST OU

syntex:

csvde -f “file 
[Continue reading]

Command to find the number of Sitelink’s for the corresponding site

Command to find the number of Sitelink’s for the corresponding site

csvde -f C:Tempsite.csv -d “CN=Inter-Site Transports,CN=Sites,CN=Configuration,DC=test,DC=com” -r “(CN=*site2*)” -l “cn”

In the above command you will get the output in site.csv file, it contains all the Sitelinks and it’s corresponding DN

Eg: Output

DN,cn
“CN=site1/site2,CN=IP,CN=Inter-Site Transports,CN=Sites,CN=Configuration,DC=test,DC=com”, site1/site2

In this

site2 – Site Name
site1/site2 – Sitelink Name
Test.Com … [Continue reading]