Category Archives: Microsoft - Page 2

SCCM report to count hardware models

I needed an SCCM report to count how many of each type of hardware model we had in the environment. I created a new report with the following query:

select
GSCS.Manufacturer0 as [Manufacturer],
GSCS.Model0 as [Model],
count(*) as [Count]
from v_R_System RS
left join v_GS_COMPUTER_SYSTEM GSCS on RS.ResourceID = GSCS.ResourceID
Group by GSCS.Model0, GSCS.Manufacturer0
Order by GSCS.Model0

Report to pull Name, Serial, Model and Object Creation in SCCM for Specific OU

Read more »

Using WDS for legacy RIS images, SCCM boot Images, and PSP (SCCM PXE Service Point)

Using WDS for legacy RIS images, SCCM boot Images, and PSP (SCCM PXE Service Point)

Read more »

WDS Architecture Detection

Each network booting computer should set DHCP option 93 to indicate the client’s architecture. This enables a PXE server to know at boot time the exact architecture of the client from the first network boot packet. On many x64-based computers, the architecture value is either not set (missing) or is not set to the expected value. (Generally, this means that the architecture is specified as x86-based when the computer is x64-based). Read more »