如何从“ALARM数据库”中获取我需要的生产停机时间？ [英] How to get the production downtime I need from "ALARM Database"?

问题描述

数据库与此相似：

Database is simliar to this:

展开 | 选择 | Wrap | 行号

推荐答案

@superleochen


我们非常清楚，标记名I16MUDL11的分解时间为42秒，即：

@superleochen
Just so we are crystal clear, the Breakdown Time for Tagname I16MUDL11 would be 42 seconds, namely:

展开 | 选择 | Wrap | 行号

谢谢，ADezii~


你的假设是真的。 Tagname I16MUDL11的呼吸时间为Tagname I16MUDL11。这两次故障是42秒。


另外，也许我不应该说频率，我想得的是每个机器部件的多少次，即标记名，分解。 br />

感谢您的帮助。

Thank you, ADezii~

Your assumption is true. The breatdown time for "Tagname I16MUDL11" is 42 seconds for these 2 breakdowns.

Also, maybe I shouldn''t say "Frequency", what I want to get is how many times each machine part, which is "Tagname", break down.

Appreciate your help.

@superleochen


请耐心等待，我会看到我能想到的，现在的解决方案并不是很明显，我不认为这很简单。你能否为我提供更多的数据，比如1000条记录，包含在你可以附加到帖子的表格中？

@superleochen
Please be patient and I''ll see what I can come up with, the solution right now is not exactly obvious, and I don''t think that it will be simple. Can you possibly supply me with more data, say 1,000 Records, contained within a Table that you can Attach to a Post?

这篇关于如何从“ALARM数据库”中获取我需要的生产停机时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！