Need to show inventory list details of a resource through message scenario (email)

Summary:

Hi All, there is a requirement to send an email to the resource every morning with the information in his inventory.
We have set up the launch condition as route activation, but unable to find a way to show all the devices and related information like retired devices list and Device inbox list through message scenario.

Is there a way in OFSC to achieve this ?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):