DX NetOps

 Looking for spectrum SQL queries which can list out the below:

1. SQL query that lists all of the managed devices, unique device Ids, type of device, manufacturer, model, OS details, etc.

2. SQL query that lists all of the Layer-2 and Layer-3 connections between the managed devices and the interfaces.

This shouldn't be done via SQL, but rather through the RESTFul API or VNM Shell (or CABI if you have it installed).