This query is handy when we want to get MAC address for a
machine in the environment, especially when we see No task sequence is
available error in PXE boot.
***********************************************************************Select
v_R_System.Netbios_Name0, SYS.User_Name0,
v_RA_System_MACAddresses.MAC_Addresses0
from
v_R_System, v_R_System SYS, v_RA_System_MACaddresses,
v_fullcollectionmembership
where
v_ra_system_macaddresses.resourceid=v_r_system.resourceid
and v_fullcollectionmembership.resourceid=v_ra_system_macaddresses.resourceid
and SYS.resourceid=v_r_system.resourceid
************************************************************************
More SCCM custom reports can be found here
No comments:
Post a Comment