→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
joled
Engaged Sweeper
Hello,
I have a few asset reports that I would like to try to create but I will start with this one. I would like to create a report that only shows an asset if it has a child assigned to it. The child asset will show up in the report also, perhaps directly under the parent.

For instance, I have a Surface Pro that has a receipt printer connected to it. The Surface Pro is an asset and the receipt printer is a separate asset. The Surface Pro has a relation in which the receipt printer is assigned as a child of the Surface Pro.

Does anyone know if such a report already exists, and where to find it if it does? If not can you suggest sample query to do this. Any ideas is appreciated.

Thanks in advance.
Joe
2 REPLIES 2
joled
Engaged Sweeper
Thank you David.
David_G
Lansweeper Employee
Lansweeper Employee
This question was sent in via e-mail as well. From Lansweeper version 6.0.100 and onwards, there is a new built-in report called 'Assets: Asset to asset relations'. This report can also be found here.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now