SELECT COUNT(distinct ResourceID) as [Count], IP_Subnets0 as Subnet FROM dbo.v_RA_System_IPSubnets WHERE IP_Subnets0 NOT IN (SELECT IPSubnet…
Browsing: SCCM 2007
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…
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…
The idea for this blog started one rainy Saturday afternoon when my 5-year-old daughter hopped on the computer and pulled…
We’ve seen this issue come up a couple of times so I wanted to give it a mention here just…
Long back i posted report http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post…