I have a list of assets and the groups I want to add them to. I have created the groups and have the keys associated to them in a separate file. I need a SQL query to add these to the Database.
File 1: AssetName,(Desired)AssetGroup
Asset1,Group1
Asset2,Group1
Asset3,Group2
Asset4,Group3
Asset5,Group3
Asset6,Group3
...
File 2: AssetGroup,AssetGroupID
Group1,10
Group2,11
Group3,12
...
I can retrieve all of the necessary information via PowerShell and I can query the DB, I just don't know how I would set up the SQL to import into the DB.
