Month: January 2012

Posted on January 19, 2012 by | 0 Comments | 3,472 Views
    SELECT b.Netbios_Name0, b.User_Name0, CASE WHEN a.FileVersion LIKE '11.%' THEN 'Office 2003' WHEN a.FileVersion LIKE '12.%' THEN 'Office 2007' WHEN a.FileVersion LIKE '14.%' THEN 'Office 2010' ELSE 'Udda Version' END AS 'Office Version', a.FileName, a.FileVersion, a.FilePath FROM v_GS_SoftwareFile a JOIN v_R_System b ON a.ResourceID = b.ResourceID JOIN v_RA_System_SystemOUName c ON a.ResourceID = c.ResourceID WHERE…
Read more »

Posted on January 19, 2012 by | 2 Comments | 475 Views
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 ConfigMgr 2012 RC2 released with some modifications ,avilable here to download ConfigMgr 2012 RC2 http://eskonr.com/2012/01/configmgr-2012-rc2-released/ . In ConfigMgr 2012 RC1 we have 13 files are prereq where as in RC2 we have 25 files as prereq.…
Read more »

Posted on January 19, 2012 by | 0 Comments | 1,805 Views
If you want to remove the registry key from local machine from windows 32 Bit OS (it will also remove the values residing in the key),try the below script as adminstrator (RUN AS). If you are using any deployment tool like Configmgr ,create a folder and place this script inside it  and create a package…
Read more »
ConfigMgr 2012 RC2 released

Posted on January 18, 2012 by | 0 Comments | 444 Views
System center configuration Manager 2012 RC2 is released and avilable to download now. It will be available from the System Center Eval Center: http://technet.microsoft.com/en-us/evalcenter/hh505660.aspx  I have tried it downloading but i can see other components along with System center configmgr 2012 with all the links avilable to download. if you are looking for only System…
Read more »

Posted on January 18, 2012 by | 0 Comments | 9,976 Views
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 etc. You can customise this by adding additional colums http://technet.microsoft.com/en-us/library/dd334593.aspx and Creating Custom Reports By Using Configuration Manager 2007 SQL Views http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052 Select SYS.Netbios_Name0, OPSYS.Caption0 as C054, OPSYS.Version0, OPSYS.CSDVersion0, OPSYS.InstallDate0, OPSYS.LastBootUpTime0, OPSYS.WindowsDirectory0, OPSYS.Description0 from v_R_System…
Read more »
Blog Review For 2011

Posted on January 10, 2012 by | 0 Comments | 40 Views
To kick off the new year, I’d like to share with you data on my blog’s activity in 2011. You may start scrolling! Crunchy numbers : In 2011, there were 33 new posts, growing the total archive of this blog to 144 posts. The busiest day of the year was December 21st . The most popular post…
Read more »