you do that the report would only reflect systems that were "powered on" at the time of the last scan, so depending on how you scan/use lspush, etc, that might not be the most accurate information?
assuming you track "powered on" as an Asset State (a configurable list) then you would query for all assets (with the columns you want) then join the tblstate table where tblstate like '%On%'
if you are not tracking that or that is not what you meant then please update.
