Access status table of partitioned zone

Question

question

martin.j asked Jun 23, '20 Benjamin W2 edited Jun 23, '20

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.

Software Version:

FlexSim 20.1.3

flexsim 20.1.3 statistics zone zone partition

1592907407134.png (52.9 KiB)

Answer 1 · 2020-06-23T17:14:19Z

Benjamin W2 answered Jun 23, '20 Benjamin W2 edited Jun 23, '20

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.

question