![]() ![]() TopConsoleUser0Įlse v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP. Is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP. I'm with Garth, I hate IPs in reports but here you go. Where v_FullCollectionMembership_Alias.CollectionID = by v_R_System_Valid_Alias.Netbios_Name0 Left join v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP_Alias on (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) LEFT join v_GS_LOGICAL_DISK_Alias on (v_GS_LOGICAL_DISK_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) and v_GS_LOGICAL_DISK_Alias.DeviceID0=SUBSTRING(v_GS_OPERATING_SYSTEM_Alias.WindowsDirectory0,1,2) Left join v_Site_Alias on (v_FullCollectionMembership_Alias.SiteCode = v_Site_Alias.SiteCode) ![]() Inner join v_FullCollectionMembership_Alias on (v_FullCollectionMembership_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) LEFT join v_GS_PROCESSOR_Alias on (v_GS_PROCESSOR_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) LEFT join v_GS_X86_PC_MEMORY_Alias on (v_GS_X86_PC_MEMORY_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) LEFT join v_GS_COMPUTER_SYSTEM_Alias on (v_GS_COMPUTER_SYSTEM_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) Left join v_GS_SYSTEM_ENCLOSURE_UNIQUE_Alias on (v_GS_SYSTEM_ENCLOSURE_UNIQUE_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) Inner join v_GS_OPERATING_SYSTEM_Alias on (v_GS_OPERATING_SYSTEM_Alias.ResourceID = v_R_System_Valid_Alias.ResourceID) Where v_GS_LOGICAL_DISK_Alias.ResourceID =v_R_System_Valid_Alias.ResourceID and v_FullCollectionMembership_Alias.CollectionID = As (Select sum(v_GS_LOGICAL_DISK_Alias.FreeSpace0) V_FullCollectionMembership_Alias.CollectionID = As , Where v_GS_LOGICAL_DISK_Alias.ResourceID =v_R_System_Valid_Alias.ResourceID and V_GS_PROCESSOR_Alias.NormSpeed0 AS ,įrom v_GS_LOGICAL_DISK_Alias inner join v_FullCollectionMembership_Alias on (v_FullCollectionMembership_Alias.ResourceID = v_GS_LOGICAL_DISK_Alias.ResourceID ) In most cases there are probably more MAC-addresses than one because a laptop has a separate network adapters for physical and wireless connections so I need to list them both. ![]() V_GS_X86_PC_MEMORY_Alias.TotalPhysicalMemory0 AS , Hi, I have a below SQL query to get the machines information with one MAC address. V_GS_COMPUTER_SYSTEM_Alias.Manufacturer0 AS , V_GS_SYSTEM_ENCLOSURE_UNIQUE_Alias.SMBIOSAssetTag0 AS , V_GS_SYSTEM_ENCLOSURE_UNIQUE_Alias.SerialNumber0 AS , V_GS_OPERATING_SYSTEM_Alias.CSDVersion0 AS , V_GS_OPERATING_SYSTEM_Alias.Caption0 AS , Then v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP_Alias.TopConsoleUser0 When (v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP_Alias.TopConsoleUser0 is NULL or v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP_Alias.TopConsoleUser0 = '-1') V_R_System_Valid_Alias.Resource_Domain_OR_Workgr0 AS , V_R_System_Valid_Alias.Netbios_Name0 AS , #SCCM REPORT WITH MAC ADDRESS CODE#The SQL Query for the report is below.Ĭan anyone offer some assistance in adding the code needed to achieve the goal. I am having so much trouble achieving what sounds to be a simple task, i want to include the MAC address and IP Address details into a default SCCM report. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |