# Downtime report

**URL:** <https://forum.inductiveautomation.com/t/downtime-report/17896>\
**Category:** Ignition\
**Created:** [May 2, 2018, 11:12am UTC](https://forum.inductiveautomation.com/t/downtime-report/17896 "2018-05-02T11:12:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgoetschalckx](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Post date:** [May 2, 2018, 11:12am UTC](https://forum.inductiveautomation.com/t/downtime-report/17896/1 "2018-05-02T11:12:06Z")

</div>

I need to make a report of the downtime of my machine.  
so i already have the time how long the machine is shut down when there is a problem, but when the machine is getting started again they need to choose why the machine was shut down. does anybody know how i can link this choice to the downtime? so that I get a list with what problems took place and how long it took to solve them.

Thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 2, 2018, 11:48am UTC](https://forum.inductiveautomation.com/t/downtime-report/17896/2 "2018-05-02T11:48:59Z")

</div>

The simple answer is to use Sepasoft’s OEE and downtime module. (-:

The generic answer is to include in your table of operator-entered reasons the record ID from the machine-driven events tables as a foreign key. Then you can join the two tables when querying to produce your downtime report. The SQL can be non-trivial, which is why there’s a module available to help people do this.

---

<div class="post-metadata">

**Author:** ![dgoetschalckx](https://avatars.discourse-cdn.com/v4/letter/d/67e7ee/32.png) [@dgoetschalckx](https://forum.inductiveautomation.com/u/dgoetschalckx)\
**Post date:** [May 4, 2018, 9:02am UTC](https://forum.inductiveautomation.com/t/downtime-report/17896/3 "2018-05-04T09:02:18Z")

</div>

i don’t really understand what you mean. i pretty new with then program.  
is there another whey to help me? maybe a video or something

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 4, 2018, 12:37pm UTC](https://forum.inductiveautomation.com/t/downtime-report/17896/4 "2018-05-04T12:37:18Z")

</div>

> [@dgoetschalckx](#):
>
> maybe a video or something

Yes. For those new to programming and to Ignition, [Inductive University](https://www.inductiveuniversity.com/library/) is the place to learn.