tom3297

Hi everyone, Im busy trying to import assets into a database with powershell. The script look like its working but doesen't import all the data i need. Anyone who has expirience with this script? Or maybe has some tips? import-Module –name D:\MDTDB.psm1 Connect-MDTDatabase –sqlServer SRV-MDT-01 –instance SQLEXPRESS –database MDT $machines = Import-Csv D:\mdtimport.csv For($i=1; $i -le $machines.count; $i++) { New-MDTComputer -AssetTag $machines[$i-1].Name -Description $machines[$i-1].Name -SerialNumber $machines[$i-1].UUID -settings @{ OSInstall='YES';OSDComputerName=$machines[$i-1].Name } } { $PCNAME=$machines[$i-1].Name write-host Updating $machines[$i-1].Name get-mdtcomputer -assetTag $machines[$i-1].Name | Set-MDTComputerRole -roles @('Laptop - Gemert - Bakel') } }

It Needs to be kept up to date.

so the data needs to go, from SRVSQL03 database TPD_PROD Table dbo.hardware To SRV-MDT-01 database MDT Table dbo.settings From colum naam to colum OSDComputerName From colum objectid to colum ID And Add C to colum Type To SRV-MDT-01 database MDT Table dbo.computerIdentity From colum naam to colum Description From colum Serienummer to colum SerialNumber From colum objectid to colum ID

Ik trying to connect two databases in Microsoft SQL. I need to move data from one to the other. to do this i made a linked Database. Now im trying to move data from a Table1 on the linked server to a table on the server ill be using. But i only want to move specific Collums to an other specific Collum. And to make is extra difficult i need to put a C in the first Collum of everything i add do it will know what is added. Thanks in advance.

yes you can do it in the software

i upgraded to the corsair M65 yesterday an the first thing i have to say is that i love it. it is a medium sized mice and i fits great in my hand the response it great. the sniper button that lowers the dpi can be very useful. the top has a fine feeling to it and the sides have a good grip they feel like verry fine sandpaper. the software can be used to customize the buttons (that have fine click)an change the 3 dpi settings and the sniper button http://images.bit-tech.net/content_images/2013/08/corsair-raptor-m40-review/m40-6b.jpg

if you want a wireless system i recommend to take a look at sonos it works incredible and it has a lot of options http://www.sonos.com/

the mass effect series

nice build man it looks amazing

spotify premium

the company was founded in 1979 http://en.wikipedia.org/wiki/Teufel_%28manufacturer%29 Sennheiser was founded in 1945 just after WW2

there very light wight only 180g an the padding is verry nice

they sound amazing certainly for the price they have great bass (not over reacting bass like in beats but just nice bass). it is a german brand i also never heard of them until somone told these to me. and thanks for the quick replay. :) http://www.teufelaudio.co.uk/headphones/headphones-aureol-real-p12277.html

Just bought new head phones they were 100 euro They really sound amazing Whats your opinion on it Teufel Aureol® Real The pictures were taken with a Samsung galexy s 3 mini

vlc is awesome i am using it for years and for setting up a server you could use twonky emit or Allshare