Paddy: June 2011

Monday, June 20, 2011

SYSPREP 2003

sysprep a windows 2003 R2 image, follow the below:

Insert CD1
go to Support\Tools\Deploy.cab
select everything and extract them to c:\sysprep ( a folder that you have created it)
Double click sysprep.exe.
Keep the default settings (Options un-selected, shutdown mode: shutdown)
click on Reseal
And press Ok

Hyper – V --- SysPrep Windows 2008 R2

1) Install WINDOWS 2008 R2 on the host machine

2) Add Hyper V role

3) Create a new VM to act as the base IMAGE

4) Mount an ISO version of windows 2008 or R2

5) Install the OS

6) Run Sysprep (/generalize switch enabled), Shutdown

7) Inside Hyper V manager, Export to a alternate location

8) After Export is done, copy the entire folder to your permanent location

9) Inside Hyper V manager, import the VM you copied.

10) Rename to a friendly name.

11) Fire the new VM up, run through the sysprep process and poof!

12) Make sure you chose "Copy the virtual machine (create a new unique ID)' option, this is not the default.

Tuesday, June 14, 2011

SCCM 2012 can be download as a VHD here.

SCCM 2012 beta 2 can be download as a VHD here.

Wednesday, June 8, 2011

LAB - IPv6 Test Lab for Windows Server 2008 R2 and Windows 7

Check it IPv6 LAB available http://social.technet.microsoft.com/wiki/contents/articles/ipv6-test-lab-for-windows-server-2008-r2-and-windows-7.aspx

Tool for SAM – from xAssets for SCCM

SAM Features with xAssets -

Configurable, Robust and Complete Reporting of all SCCM Assets
Software Asset Management
Options to discover Linux, Unix, Mac, IP Phone, Network Equipment into the SCCM inventory
Integrate to Active Directory and other IT systems
Contract Management
Spare Parts Inventory
Scalable to Large Enterprises
Hosted SAAS or Locally Installed

Some good MS Blogs

Monday, June 6, 2011

Software Inventory less than 21 Days - Collection

select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where ResourceId in (select ResourceID from SMS_R_System inner join SMS_G_System_LastSoftwareScan on SMS_G_System_LastSoftwareScan.ResourceID = SMS_R_System.ResourceId where DATEDIFF(dd,SMS_G_System_LastSoftwareScan.LastScanDate,GetDate()) > 21 )

SCCM/ SMS Console Installed Systems Collection

select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Systems Management Server 2003 Administrator Console"

Patch Supersedence Report from SQL Query

select cir.FromCIID [New CI],
info.BulletinID [New BulletinID],
info.ArticleID [New ArticleID],
info.Title [New Title],
info.InfoURL [New InfoURL],
info.DatePosted [New DatePosted],
cir.ToCIID [SUPERSEDED CI],
info2.BulletinID [Superseded BulletinID],
info2.ArticleID [Superseded ArticleID],
info2.Title [Superseded Title],
info2.InfoURL [Superseded InfoURL],
info2.DatePosted [Superseded DatePosted]
from v_CIRelation cir
left join v_UpdateInfo info on cir.FromCIID = info.CI_ID
left join v_UpdateInfo info2 on cir.ToCIID = info2.CI_ID

where RelationType = 6

((info.ArticleID = @KBNumber) OR (info2.ArticleID = @KBNumber))

order by info.BulletinID, info.ArticleID

Microsoft Virtual Academy

Now you can learn from Microsoft Virtual Academy

Improve your IT skill set and help advance your career with a free, easy to access training portal. Learn at your own pace, focusing on Microsoft technologies, gain points and get recognition.

https://www.microsoftvirtualacademy.com/Home.aspx