Equipment Utilization

Using VB.NET

I have been asked to extract, by individual item, the utilization over a time frame. This needs to be for all items, not a single item.

For example:

Location 1 had a 1000 widgets on Jan 1.

Location 1 put 200 widgets on Job 1 on Jan 02.

Location 1 put 200 widgets on Job 2 on Jan 04.

Is there a means, using API, to build the extract in the following reporting manner, assuming the duration is Jan 01 - Jan 10,or is this something that will have to be built manually?

ITEM, DATE, OWNED, USED
Jan 01, 1000, 0
Jan 02, 1000, 200
Jan 03, 1000, 200
Jan 04, 1000, 400
Jan 05, 1000, 400
Jan 06, 1000, 400
Jan 07, 1000, 400
Jan 08, 1000, 400
Jan 09, 1000, 400
Jan 10, 1000, 400

Hi James. We have a utilization dashboard feature in the works, should be shipping in a few months. It will be a subscription-based service though.

Quantify doesn’t store any historic data. To get at what you’re wanting you’ll need to export what you want daily to an external data store and then report off of that.