For thefirst part, please refer to http://powergui.org/thread.jspa?threadID=2701&tstart=0.

(This post providesinformation on how you can use Management Shell for AD from Quest Software todo various management tasks for your Active Directory. For a quick introductioninto Management Shell for AD, please refer to: http://powergui.org/thread.jspa?threadID=2700&tstart=0)

Let's try somethingreal.

For alluser accounts, let's count users for each department:

(I reallyrecommend trying 100 as size limit first)

What we didhere, we build a list of all users in domain, then group them by Departmentproperty using build-in cmdlet Group-Object and then sort the results descendingby count.

To sort bydepartment name, execute the following:

We can dothe same for other attributes.

Let's seehow many employees are working in each city:

To countmailboxes per each mailbox store, use homeMDB attribute. As homeMDB does not presentedin default property list returned by Get-QADUser cmdlet, use the {$_.DirectoryEntry.homeMDB}as property name for the workaround:

A quick explanationfor the  "{$_.DirectoryEntry.homeMDB}"here. This is actually a very small piece of code that first access the DirectoryEntryproperty of the object passed though the pipe (the object returned byGet-QADUser cmdlet). Then, it access the homeMDB property of theDirectoryEntry. With this workaround you can access any AD attribute.

Regards,
Andrei [Quest]
This posting is provided "AS IS" with no warranties, and confers no rights