Operating System Deployment Using SCCM 2007

OPERATING SYSTEM DEPLOYMENT USING SCCM 2007

  1) Install windows deployment server ( WDS )

  2) Install Microsoft deployment toolkit ( MDT )- Optional

  3) Install PXE-Role point in SCCM.

         And verify following files also presented :

                C:\RemoteInstall\SMSBoot

                C:\RemoteInstall\ SMSIMAGES

                C:\RemoteInstall\ SMSTemp

                C:\RemoteInstall\ Stores

  

4) Add boot image to standard & PXE Distribution point.

  5) Add Install operating system image to standard distribution point

  6) Create sccm client package ( package from definition method ) and necessary software packages.

  7) Add DHCP Scope options :

Port 66 : <Boot server IP Address>

Port 67 : smsboot\x64\wdsnbp.com

  8) Create Task sequence & assign to required collection

Installing WDS :

Click Next & select Windows Deployment Services

Click Next.

 Click Next

 Click Install.

Click Close.

PXE- Role Installation : 

Site Database -> Site Management -> Site settings -> System systems -> right click

Select “PXE Service point”

 ( Optional: Enable unknown computer support ) & type PXE boot password. Click next

 Click next and finish.
PXE Installation Check : (C:\Program Files (x86)\Microsoft Configuration Manager\Logs\pxesetup.log )

Add Boot Image to Distribution Point :

Add default boot image to PXE Disrtibution point & standard distribution point.

Make sure that, required model network driver added to boot image.

After Boot image Distribution verify following files presented here : C:\Windows\Temp\PXEBootFiles\Windows\Boot\EFI

C:\Windows\Temp\PXEBootFiles\Windows\Boot\PXE

Add Operating System Image wizard :

Site Database -> computer management -> Operating system deployment -> Operating system images  -> right click -> add operating system image.(specify Captured image.wim file instead of install.wim )

Add this image to Standard distribution Point.


ADD Operating System Install Package :

Site Database -> computer management -> Operating system deployment -> Operating system install packages  -> right click -> add operating system install package.

Select operating system image share path and click next. Once completed add to standard distribution point.

TASK Sequence creation : 

NOTE : 

Type desired admin password in that text box.

Assign Task Sequence to Required collection.

 Program rerun behaviour should be : Never Rerun

Once Tasksequence Created and advertised,

Start workstation and press F12 select Network book

Need to provide password for entering to Task Sequence.

==============================================================

ERRORS Faced During OSD and solution : 



1) Error : pxe-e52 - tftp open timedout

add port 66,67 in DHCP

66 Boot server name : Boot server IP address
67 Boot file name  :  SMSBoot\x86\wdsnbp.com


2) Error : error 0x000000032

Sol : disable Apply drivers device option in task sequence.

3) Error : 0*80070005

Sol : access denied for DP,  whatever packages added to Task Sequence should be in Distribution points.
MY CASE : some packages were not added to any distribution points..

---------------------------------------------------------------------------------

Capture Image using Create task media - SCCM

Capturing Image using Task sequence create media wizard,

1) create task sequence capture media,

Select location where you need to save .iso image, click next and finish.

Once ISO Image created, burn it to CD or DVD.

2) Capturing Image using CD,
Run this CD or DVD to machine, where we need to capture image.


Run -> TSMBAUTORUN.EXE

Click Next & Specify destination folder and file name : C:\Windows7 32bit ent sysprep\Win7 32bit ent with all apps

Once Setup is started capturing Image, system will restart once, please wait.

After Restart you will get Following screen.

Thats it, now we can deploy this image with OSD.

Error in PXE Role uninstallation

Error : Unable to delete PXE Role in sccm,

Solution :
Run following sql query in sccm Database.


delete from pkgservers where NALPATH like '%\\sccm server name\smspxeimages$%'
delete from pkgstatus where pkgserver like '%\\sccm server name\smspxeimages$%'

After this, we can able to delete PXE role.

SCCM Report to collect video file information

collecting video file information using SCCM Report

1) add video file extension in inventory collection under software Inventory client agents properties as shown below.

once added all required extension in inventory collection, run software inventory client agent on all systems.

2) Create SCCM Report now, ( i used SQL Server Business intelligence studio configured already)

 In solution explorer, right click -> Reports -> Add new report

 Next

Next

Copy SQL Query into : query string and click on Query Builder ( sql query available below )

SQL Query : 

SELECT     SYS.Netbios_Name0 AS 'System Name', SYS.User_Name0 AS 'User Name', SF.FileName, SF.FilePath, SF.FileSize AS 'FileSize(Byte)', SF.FileModifiedDate,

FCM.CollectionID

FROM         v_GS_SoftwareFile AS SF INNER JOIN

v_R_System AS SYS ON SF.ResourceID = SYS.ResourceID INNER JOIN

v_FullCollectionMembership AS FCM ON FCM.ResourceID = SYS.ResourceID

WHERE     (SF.FileName LIKE '%.avi%'

or sf.filename like '%.3gp'

or sf.filename like '%.flv'

or sf.filename like '%.mov'

or sf.filename like '%.mp4'

or sf.filename like '%.mpg'

or sf.filename like '%.mpeg'

or sf.filename like '%.wmv'

or sf.filename like '%.divx'

or sf.filename like '%.mkv') AND (FCM.CollectionID = @CollectionID)

ORDER BY 'FileSize(Byte)'

Select check box : CollectionID and enter OK

Select CollectionID check box 

Enter the name of the Report

OUTPUT : 

Any help required : prakaash2109@gmail.com

Uninstall uTorrent Completely using command line

How to uninstall uTorrent Completely from system.

1) open notepad and type following command.


cd "C:\Program Files\uTorrent"
uTorrent.exe /uninstall /s
rmdir /s /q "C:\Program Files\uTorrent"
reg delete HKEY_CURRENT_USER\software\BitTorrent /f
reg delete HKEY_CURRENT_USER\software\BitTorrent\uTorrent /f
reg delete HKEY_CLASSES_ROOT\.torrent /f
reg delete HKEY_CLASSES_ROOT\Applications\uTorrent.exe /f
reg delete HKEY_CLASSES_ROOT\uTorrent /f
reg delete HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run /v uTorrent /f

save as batch file ( .bat ) and run. it removes uTorrent completely from your system.

same batch file we can create package through SCCM and distribute via software distribution.

SCCM Software update point error ( Error = 0*80004005)

ERROR : Failed to add update source for wuaagent, group policy error.

Solution :

Deleted registry.pol  from : c:\windows\system32\grouppolicy\machine\registry.pol.

Now initiate software update scan cycle and software deployment scan cycle.

Now verify. Wuahandler.log, log file will show “Async searching of updates using WUAgent started.”

Asset Information with username in SCCM

Asset Information with username in SCCM

Create a new report with following SQL query : 

select  distinct
    R.ResourceID,
    R.User_Name0,
    R.Netbios_Name0 AS 'Computer_Name',
    R.Resource_Domain_OR_Workgr0 AS 'Domain_workgroup',
    S.SiteName as 'SMSSiteName',
    OS.Caption0 AS 'OperatingSystem',
    OS.CSDVersion0 AS 'ServicePackLevel',
    SEQ.SerialNumber0 AS 'SerialNumber',
    SEQ.SMBIOSAssetTag0 AS 'AssetTag',
    CS.Manufacturer0 AS 'Manufacturer',
    CS.Model0 AS 'Model',
    WS.LastHWScan AS 'Last_Scan_Date',
    RAM.TotalPhysicalMemory0 AS 'Memory_KBytes',
    Pro.NormSpeed0 AS 'Processor_GHz',
    (Select sum(LD.Size0) from v_GS_LOGICAL_DISK LD where LD.ResourceID = R.ResourceID) As 'DiskSpace_MB',
    (Select sum(LD.FreeSpace0) from v_GS_LOGICAL_DISK LD where LD.ResourceID = R.ResourceID) As 'Free_Disk_Space_MB',
    U.Full_User_Name0
  from
    dbo.v_R_System_Valid R
    inner join dbo.v_GS_OPERATING_SYSTEM OS on (OS.ResourceID = R.ResourceID)
    inner join dbo.v_GS_WORKSTATION_STATUS WS on (WS.ResourceID = OS.ResourceID)
    inner join dbo.v_GS_SYSTEM_ENCLOSURE_UNIQUE SEQ on (SEQ.ResourceID = R.ResourceID)
    inner join dbo.v_GS_COMPUTER_SYSTEM CS on (CS.ResourceID = R.ResourceID)
    inner join dbo.v_GS_X86_PC_MEMORY RAM on (RAM.ResourceID = R.ResourceID)
    inner join dbo.v_GS_PROCESSOR Pro on (Pro.ResourceID = R.ResourceID)
    inner join dbo.v_FullCollectionMembership FCM on (FCM.ResourceID = R.ResourceID)
    inner join dbo.v_Site S on (FCM.SiteCode = S.SiteCode)
    left outer join dbo.v_R_User U on U.Unique_User_Name0 = R.User_Domain0+'\'+R.User_Name0
--    inner join v_GS_LOGICAL_DISK LD on (v_GS_LOGICAL_DISK.ResourceID = R.ResourceID) and LD.DeviceID0=SUBSTRING(OS.WindowsDirectory0,1,2)
--    left join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM on (SCUM.ResourceID = R.ResourceID)
 Where
    FCM.CollectionID = @CollectionID
Order by
    R.Netbios_Name0

Create Prompt value for Collection : 

Prompt SQL Statement : 

begin
if (@__filterwildcard = '')
select CollectionID, Name from v_Collection order by Name
else
select CollectionID, Name from v_Collection
WHERE CollectionID like @__filterwildcard
order by Name
end