Left join v_Site on (v_FullCollectionMembership.SiteCode = v_Site.SiteCode) Inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_PROCESSOR on (v_GS_PROCESSOR.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_X86_PC_MEMORY on (v_GS_X86_PC_MEMORY.ResourceID = v_R_System_Valid.ResourceID) LEFT join v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) Left join v_GS_SYSTEM_ENCLOSURE_UNIQUE on (v_GS_SYSTEM_ENCLOSURE_UNIQUE.ResourceID = v_R_System_Valid.ResourceID) Inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID) Where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and v_FullCollectionMembership.CollectionID = As (Select sum(v_GS_LOGICAL_DISK.FreeSpace0) V_FullCollectionMembership.CollectionID = As ,
Where v_GS_LOGICAL_DISK.ResourceID =v_R_System_Valid.ResourceID and V_GS_PROCESSOR.NormSpeed0 AS ,įrom v_GS_LOGICAL_DISK inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_GS_LOGICAL_DISK.ResourceID ) V_GS_X86_PC_MEMORY.TotalPhysicalMemory0 AS , V_GS_SYSTEM_ENCLOSURE_UNIQUE.SMBIOSAssetTag0 AS , Then v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 When (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP.TopConsoleUser0 = '-1')
#How to query a mac address in sccm how to
I wanted to use Hardware 01A report to include the MAC Adresses but I don't know how to do it.