Resolved! Report based on Default Gateway
At the moment i've got a report as below.Select Distinct Top 1000000 co1.Computername, co1.Computer, co1.Username, cs1.Manufacturer, cs1.Model, csp1.IdentifyingNumber As [Serial Number], cpu.Name As [Processor Model], cpu.MaxClockSpeed As [CPU (MHz)]...