Summary: Hardware 01A – Summary of computers in a specific collection report is Hardware Asset Intelligence reports contain a summary view of all of the computers in a collection. It’s very useful to add two more columns, on for machine IP address and one for Subnet. Report query: SELECT DISTINCT TOP (100) PERCENT dbo.v_R_System_Valid.Netbios_Name0 AS […]

The following SQL query can be use to generate report in System Center Configuration Manager to retrieve Machine and User Information from a specific collection. Result below query will include the following: Machine Name Domain Name Login User ID User Name Full User Name Machine Serial Number. Manufactures Model Machine assigned site SQL Query: Select […]