Hi, I would be very interested to know if there is somewhere the SQL map schema, explaining the database structure and the tables information.
Nothing? No where? No answer?
I've looked, answer seems to be use the SDK but I want to use direct queries. What I've noticed is that the queries don't always match up.
That is not published.
Also take a look at this thread Re: where can I get the database schema, structure, or dictionary to include items in reports?
It's not published because it is not supported, and is not guaranteed to remain the same with versions. However, if you must query the DB directly, the easiest way to reverse engineer the query is to use the legacy report writer
From a previous reply - Re: Table to show all 5 statistics being returned from Linux script
A quick pointer for any such future efforts - use the Legacy Reporter on the SolarWinds server and add in the columns that show the data you need. Once you have done designing the report, the Edit menu in the Design view has a 'Show SQL' option. If you choose that option, the SQL query to execute the report will be displayed. So, you shouldn't have to play around with DB schema tools.
What exactly is your requirement to go against the DB directly? Are you trying to display the information in another system?
