Your company's ad could live here and reach over 50,000 people a month!

Author: Anderson K

Part IV : Move Computers to OU based on IP Subnets

To automate the movement of computers in the Default Computers Container to the Location OUs based on their IP Subnets defined in the Active Directory Sites and Subnets Source OU ande.in/Computers Destination OUs ande.in/Asia/India/Computers ande.in/Asia/Japan/Computers ande.in/Europe/Italy/Computers ande.in/North America/Canada/Computers ande.in/South America/Argentina/Computers Note : 1. We are ...

Part III : Move all Disabled computers to Standard Disabled OU

Here we move all Disabled computers from OUs to a standard OU. Note : Chenge the following names in the script. Standard Disabled OU : “OU=Disabled,DC=ande,DC=in” Standard Disabled OU : “ande.in/Disabled” $log [Default : C:\Log_310310.log] add-pssnapin Quest.ActiveRoles.ADManagement $Log = Get-Date -uformat "C:\Log_%d%m%Y.log" ###################### $Date_Move2Disabled = Get-Date echo ...

Part II : Identifying and Disabling Stale Computers

By Using the table we created from Part I, we identify the computers with password age and lastlogontimestamp > 60 days and disable them. Stale Computers can be identified based on their Password Age and LastLogonTimeStamp Go Further : Machine Account Password Process “The LastLogonTimeStamp Attribute” – “What it was designed for and how it works” SQL Query to find Stale Computers Note : Change...

Bridging the GAP between AD, DNS, Sites, IP Subnets and SCCM using Powershell

Imagine if you get the data of all Computers with Name,IP,Subnet and Site details in a single script !!! That is what we are going to do… Note : 1. We are going to use 3 Functions Find-Site and Get-Site : Used to identify Subnet and Site Details. Credit goes to /\/\o\/\/ Split-Job : Used to speed up the script execution. So the script will execute 10 times faster. Credit goes to Arnoud Jansveld 2....

SCCM Query for total count of OS and Service Pack

This SQL query can be used to find the overall count of Operating systems and their Service packs SELECT Caption0 as ‘Operating System’,CSDVersion0 as ‘Service Pack’, COUNT(*) AS ‘Count’ FROM v_GS_OPERATING_SYSTEM,v_R_System WHERE v_GS_OPERATING_SYSTEM.Resourceid=v_R_System.Resourceid GROUP BY Caption0,CSDVersion0 ORDER BY Caption0,CSDVersion0

SCCM Query for identifying Software based on Executables

This SQL query can be used to search for installed software based on their executables SELECT VRS.Name0 as ‘Computer Name’, VRS.User_Name0 as ‘User Name’, SF.FileName as ‘File Name’, SF.FileDescription as ‘File Description’, SF.FilePath as ‘File Path’, SF.ModifiedDate as ‘Modified Date’ FROM v_R_System VRS,v_GS_SoftwareFile SF...