At this time the Lookup objects action in the Automation rules is limited to 100 objects as covered on this article, but for environments with many assets, it would be relevant to have a larger limit of objects that could be queried at the same time.