This query will show the machine name, IP address, and ram memory:
********************************
select distinct
SMS_R_System.NetbiosName,
SMS_G_System_PC_BIOS.SerialNumber, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory,
SMS_R_System.IPAddresses, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DNSDomain
from SMS_R_System inner join SMS_G_System_PC_BIOS
on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_X86_PC_MEMORY
on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId
inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION
on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId
order by SMS_R_System.NetbiosName
*****************************************
0 commenti:
Post a Comment
Give me you feedback!