question

martin.j avatar image
0 Likes"
martin.j asked Benjamin W2 edited

Access status table of partitioned zone

If I create a partitioned zone the system gives this very nice status overview of its contents that is updated live. What I would ideally like to do is make a snapshot of this partitioned content overview in a statistics collector (or similar) with a timestamp every night at midnight.

Is there a way to access the partitions table seen in the picture below?

It seems rather crude having to create a statistics collector that collects the contents of the zone, and use a calculated table to create this overview, and then take a snapshot of it with another collector, when the information is evidently already gathered in the zone status and must be maintained somewhere.

FlexSim 20.1.3
flexsim 20.1.3statisticszonezone partition
1592907407134.png (52.9 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Benjamin W2 avatar image
0 Likes"
Benjamin W2 answered Benjamin W2 edited

Hi @martin.jensen,

I don't believe there is an easy way to do this. From what I could understand from the model tree, it looks like this table is actually generated from an SQL query. You might be able to dig into the tree to find the table where the original data is stored, copy it to a global table, then run a query on that. However, I think it would be easier just to use the statistics collectors and calculated tables.

Here is where the data for the partitioned table is stored:

MODEL:/Tools/ProcessFlow/ProcessFlow/Zone>stats/partitions

@Jordan Johnson please chime in if there is a better way.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.