PowerShell for Domain Systems Information Reports

With normal network maintenance and hardware replacement cycles it is a good idea to keep an eye on the age and other information of the computers on your network. There are lots of third party tools to run more detailed reports, but if you want a quick report why not use PowerShell on Server 2012 and export to a CSV file.

Open up PowerShell as an administrator and review the Get-ADComputer commands

Get-ADComputer -Filter *

Will show you basic AD attributes of the systems:

clip_image002[4]

Get-ADComputer -Filter * -Properties * will give you way too much information but shows you all the possible variables you can choose from. Below are some of the more common properties you would likely want to query for reports:

clip_image004[4]

clip_image006[4]

clip_image008[4]

Now to run the following command to see the fully qualified computer names, the date and time they were created in AD, along with last logon date and time:

Get-ADComputer -Filter * -Properties "DNSHostName","Created","LastLogonDate" |select dnshostname,created,lastlogondate

clip_image010[5]

Note: This just shows when created/joined to the domain it is not a confirmation of the computers true age. That will require further research but typically this will provide the ballpark needed.

Now to run the command again but this time export the data we want to a CSV file in C:\Temp\ that can be more easily viewed, edited and sorted in Excel.

Get-ADComputer -Filter * -Properties "DNSHostName","Created","LastLogonDate" |select dnshostname,created,lastlogondate |Export-csv C:\temp\computerdata.csv

clip_image011[5]

Note: It creates a “#TYPE Selected.Microsoft.ActiveDirectory.Management.ADComputer” field on Line 1A you can delete.

Using the example above you can add or remove properties to your report. For example I will add operating system information and change the fully qualified computer name to the shorter “Name”:

Get-ADComputer -Filter * -Properties "Name","Created","LastLogonDate",”OperatingSystem” |select name,created,lastlogondate, operatingsystem |Export-csv C:\temp\computerdata.csv

clip_image013[5]

This should provide you quick answers you need regarding your systems

Happy Querying!

Reference: Ed Buford

Comments

Post a Comment

Popular posts from this blog

Office 365 Deployment Tool Office Download fails “Could not Install”

Image
Problem: you run the setup.exe /download download.xml and fails immediately with “Couldn’t install” You make sure all the settings are correct (see other blogs) and find nothing wrong Solution: Change drives and run it as an administrator again. For example above i am in the F:\OfficeDeploy directory which is the same directory I have the download.xml directing the download to. If i Change to the c: and run the same command again it works The Office Data folder was created and updated as shown below:
Read more

FRS to DFSR Post Cleanup “File Replication NtFrs Stopped”

Image
After successfully migrating from FRS to DFSR you get the File Replication NtFrs service is Stopped error on the local servers AD DS Services list. In the Event logs you may see Event id 13575 13577. You can confirm your migration completed by opening a cmd prompt as administrator and typing in: dfsrmig /getmigrationstate After your migration to DFSR is completed and you have given your servers ample time to propagate this service is no longer required. Since it is set to “Automatic”, as shown below” it shows in logs as a false positive error. Edit the File Replication Service and change it to “Disabled”, as shown below: Once it is listed as “Disabled” it will no longer show in the Console as an “error” Note : it may take some time to clear from the active view
Read more

Domain Migration SubinACL /Migratetodomain How To:

Caution : DO NOT run this on Domain Controller C:\ and only run on roaming profiles folders, or my docs shares day of migration to avoid ownership change issues. Confirm Domain trust is in place and users and groups have been migrated Test ping of olddomain.org from new domain Test ping of newdomain.org from olddomain Add newdomain.org domain controller host records to olddomain.org including reverse DNS records Confirm the user running the app is a domain admin in BOTH domains Download SubinACL here: http://www.microsoft.com/en-us/download/details.aspx?id=23510 /Migratetodomain- command will add the permissions of the new user to the old files and folders for example if jimbob@olddomain.org was migrated to the new domain jimbob@newdomain.org and you run the command below any file or folder in that path that has jimbob@olddomain.org will add Jimbob@newdomain.org with the exact same permissions. This is a safer way to migrate by keeping the old and new permissions intact while a
Read more