Logic Machine Forum
scenes overview - Printable Version

+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: General (https://forum.logicmachine.net/forumdisplay.php?fid=2)
+--- Thread: scenes overview (/showthread.php?tid=1973)



scenes overview - rocfusion - 16.03.2019

Hi,

I have LM's running with 600+ scenes.  Is there are a way to generate a report to show for all scenes which objects are used?

Thx,


Roger


RE: scenes overview - admin - 18.03.2019

Use this as .lp file. It will print out group address and object name for all objects that are in any scene sequence.
Code:
<?
require('apps')

objects = db:getall([[
SELECT * FROM objects
WHERE id IN (SELECT object FROM scene_sequence)
ORDER BY id
]])

for _, obj in ipairs(objects) do
  print(buslib.decodega(obj.id), ' ', obj.name or '', '<br>')
end