Need to create custom report but how do i look up all the table Solarwinds use
Assuming you are trying to write your own query, all of the tables can be viewed via SWQL Studio available here GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.