SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007'…
Month: January 19, 3:56 pm
SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet…
Long back have posted how to download prerequsisits which are required for configMgr 2012 RC1 http://eskonr.com/2011/10/configuration-manager-2012-prerequisites-download/ . Day ago there was…
If you want to remove the registry key from local machine from windows 32 Bit OS (it will also remove…
System center configuration Manager 2012 RC2 is released and avilable to download now. It will be available from the System…
had a requirement to see how many computer falls within the specific subnet. select a.name0,b.IP_Subnets0 from v_R_System a,dbo.v_RA_System_IPSubnets b where…
simple and straight forward report that gives you the computers with operating system,CSD version(service Pack),Version number,OS Installed date,LastBootup time.windows Directory…
To kick off the new year, I’d like to share with you data on my blog’s activity in 2011. You may…