SCCM 2007 / SMS 2003 SQL Package Related Query

———————————————————————————————————————————–SQL Query:–>———————————————————————————————————————————– To know the package Name and ID SELECT     PackageID, NameFROM         dbo.v_Package———————————————————————————————————————————– ———————————————————————————————————————————–SQL Query:–> If you want to filter with the package ID then modify the Query to SELECT     PackageID, NameFROM         dbo.v_PackageWHERE     (PackageID = 'YourPKGID') ———————————————————————————————————————————–——————-Thanks,https://sccm07.blogspot.com/

Failed to remove package from SMS / SCCM Retired/ Correpted distrubution point

Failed to remove package from a retired distrubution point   Select * from pkgservers where NALpath like '%retired DP pathDP$'Select * from pkgstatus where pkgserver like '%retired DP pathDP$' by runing above two commands verifiy that you have got the correct Correpted DP package ID or not. then if you find it you can safly … Read more

SCCM OSD All Log Files

Operating System Deployment Log Files   The following table lists and describes the operating system deployment log files. Log File Name Description CCMSetup.log Provides information about client-based operating system actions. CreateTSMedia.log Provides information about task sequence media when it is created. This log is generated on the computer running the Configuration Manager 2007 administrator console. … Read more

Analyzing Windows Kernel Dumps

Analyzing Windows Kernel Dumps   This post contains information on steps I took to investigate a kernel mode dump with a repeatable 0x7F bugcheck caused on a workstation when printing a specific document to a generic LaserJet 4000 on a remote print server. After analysing the kernel dump, the problem appeared to be occurring in … Read more

This was a basic overview of the ‘for’ command

This was a basic overview of the ‘for’ command This is the first in a series of posts containing information on what I consider the building blocks to automate repetitive tasks at the Windows command-line. These components are the for, find, findstr, set, if and echo commands, control files used for data input, combined with … Read more