Wednesday, 9 July 2014

Using SCCM reporting to get the GUID of PCs

I recently needed to get the GUID and PC name of every single PC in our organisation. I used the reporting feature in SCCM and put together a very simple SQL query. Here's the query, in case it is useful to someone else.
    v_R_System.Netbios_Name0, v_R_System.SMBIOS_GUID0
This returns the PC name and GUID of every single machine in the SCCM database.

No comments:

Post a Comment