As part of the network discovery process, I noticed that it was picking up the iPhone and other Apple machines (Macs, iPads) that were on the corporate network either via being plugged in or on the wireless LAN. Shortly afterwards, there was a requirement to report on all the Apple devices found in the environment. [...]

Continue reading...

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 [...]

Continue reading...

I’ve often used a very simple query to find if a processor is 64 bit capable. Open up a command prompt and enter the following: wmic cpu get datawidth I doesn’t matter the version of the Operating System you are running, this WMI query will return the actually hardware processor capability. If it returns a [...]

Continue reading...