# Servers to scan
$servers = ( 
	"server1",
	"server2",
	"server3"
	);

# Server and database where data is stored.
$InfrastructureInfoServer = "InfServer";
$InfrastructureDatabase = "InfDatabase";

## Get data from each server and store.
foreach ($s in $servers)
{
	# Your query to be run against each server. Assumes windows auth.
	$result = Invoke-sqlcmd " `
	 	SELECT `
	 		GETDATE() AS Date, `
	 		@@servername As servername, `
			cpu_count AS [Logical CPU Count], `
			hyperthread_ratio AS [Hyperthread Ratio], `
			cpu_count / hyperthread_ratio AS [Physical CPU Count], `
			physical_memory_in_bytes / 1048576 AS [Physical Memory (MB)], `
			sqlserver_start_time `
		FROM `
			sys.dm_os_sys_info WITH (NOLOCK) OPTION(RECOMPILE); " `
	-ServerInstance "$s" ;
	
	#Store the results into the Infrastructure server. Assumes windows auth
	Invoke-Sqlcmd " `
  		INSERT INTO Infrastructure_changes values ( `
  			'$($result[0])', `
  			'$($result[1])', `
  			'$($result[2])', `
  			'$($result[3])', `
  			'$($result[4])', `
  			'$($result[5])', `
  			'$($result[6])'  `
  			) " `
	-ServerInstance $InfrastructureInfoServer `
	-Database $InfrastructureDatabase 
}