MongoDB with Powershell

Question

I'm retriving a VM utilization details in a variable($report)which is in JSON format.

$report looks something like:

{
   { 
   "VM_Name" : "VMtest1"
   "Datastore":"KJo91"
   },
   { 
   "VM_Name" : "VMtest2"
   "Datastore":"KJo91"
   },so on....
}

Now I need to import this into MongoDB via powershell. Is it possible?Or should I save it as a Jsonfile and import? For both cases required a powershell command.

Thank you in advance.

autosvet · Accepted Answer · 2017-09-26 07:39:43Z

1

Yes, it is possible. You need to use Mongo C# driver and then the standard .NET object approach. Check this links: C# and .NET MongoDB Driver and Using Mongodb with PowerShell

answered Sep 26, 2017 at 7:39

autosvet

8801 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user8428195 Over a year ago

Yes I have used C# MongoDB Driver.

kenorb · Accepted Answer · 2017-10-20 13:59:59Z

0

Yes, I have used C# MongoDB Driver, I can import a JSON file (Sample1.json) into MongoDB, e.g.

# Command Used
$report = Get-VM #retrives the VM Details
$report | ConvertTo-Json -Depth 1 | Out-File "Path" # Here a file is saved in the specified path and I can import the file to MongoDB using the below command:
.\mongoimport.exe  --db $dbName --collection $collectionName ./sample1.json --jsonArray

Instead of creating a file, I'm using a variable which has the data in JSON format:

# Command used
$result = $report | ConvertTo-Json -Depth 1

Now I have to import the $result variable (which contains the collection/document) into MongoDB.

edited Oct 20, 2017 at 13:59

kenorb

169k95 gold badges712 silver badges796 bronze badges

answered Sep 26, 2017 at 9:19

user8428195

12 bronze badges

Collectives™ on Stack Overflow

MongoDB with Powershell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related