Browse by Tags

All Tags » SQL (RSS)
Wednesday, March 31, 2010 5:17 AM

Part I : Bridging the GAP between AD, DNS, Sites and IP Subnets [ http://ande.in ]

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...
Posted by andersonk | with no comments
Filed under: , , , ,
Wednesday, March 31, 2010 4:31 AM

Active Directory / SCCM Cleanup and Baselining [ http://ande.in ]

Here we are going to see some methods for automating Active Directory cleanup process. Part I Bridging the GAP between AD, DNS, Sites and IP Subnets. Here...
Posted by andersonk | with no comments
Filed under: , , , ,
Tuesday, February 16, 2010 4:34 AM

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...
Posted by andersonk | with no comments
Filed under: , , ,
Friday, January 22, 2010 2:15 AM

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...
Posted by andersonk | with no comments
Filed under: ,
Friday, January 22, 2010 2:11 AM

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...
Posted by andersonk | with no comments
Filed under: ,