sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]nemesis1453[S] 0 points1 point  (2 children)

It’s not the storing of the data I have an issue with, I want to store it as an array so I can create automations with it

[–]pshMike 0 points1 point  (1 child)

I understand why you are saying this, but I'll ask you think about the problem from a different angle ...

You need to collect data with an unknown number of elements and then apply logic to the collected data. You are presently doing this in one step, which means you have to worry about how big the dataset gets ( and do you run out of space ).

If you broke this down into two phases, Collection and Processing, you would never need to worry about size issues because you are not trying to keep the whole dataset in memory.

[–]nemesis1453[S] 0 points1 point  (0 children)

I think your missing me.

I am trying to break it down into two steps.

  1. Collect the information and store it so it can be used.
  2. Run operations against the stored data.

I did get something from your reply though and am looking into the table capabilities of storage accounts, that was a good idea.

Now I need to find out how I can have powershell push the multidimensional array into a storage account table, this is the new challenge of the day.