I need to get a list of PC name, IP, Model, and Serial Number based on the IP address or hostname.
On results pane of a query, when I only choose Name and IP, it'll give me all alive IP addresses with host name. But if I choose Model and/or Serial Number, the results list will shrink! and will only show the ones with Model and serial Number and will filter the ones without these info!
1. Is there any way to force it to list Model and Serial for all? (I guess not easy)
2. more importantly: How to list all IP addresses and Names, and for the ones that SCCM can't get the Model and Serial Number, just leave the field blank, not filter it the entire row?
select SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_G_System_PC_BIOS.SerialNumber from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId where SMS_R_System.IPAddresses like "10.106.%" or SMS_R_System.NetbiosName like "ITD%"
- Edited by Ray Darvi Monday, April 27, 2015 9:50 PM