New Tables on NPM don´t appear on SDK using SWQL Studio

What you see through the API are entities that are specifically exposed by us.   We do not automatically expose all the tables you see in the database.  While it is possible for you to expose your tables, I'm not sure it something we support.

I just left a meeting where we discussed this very issue.  We have our MIS group creating some custom SQL reports for us, which we found impossible to create natively with SolarWinds,  To create those reports. our SQL admin added a local table to the SOLARWINDS database, containing data imported from other SQL applications we run in-house.   My existing perl code has been reading a CSV file I manually exported from our SQL CRM, and naturally this gets stale quickly.  We were just discussing if it is possible for SWIS-based applications like perl using the Orion SDK to read from the custom table, instead of a local CSV file.  We sadly concluded that doing this would not be possible, but your response above implies that perhaps it is possible, after all.

Given that this is not supported, is there any information available that would allow us to expose our custom table so that a  perl script can use the SDK to do something like '$swis->QueryXml( "SELECT Sitecode, LocID, State FROM OUR_CRM_TABLE WHERE State='CA'") ?  Would it possible to make that table available to the SolarWinds Report Writer?  If we can, we could do everything we need from inside SolarWinds without MIS assistance.

At this point we have full support for custom properties/columns for Nodes, Volumes, Interfaces (NPM), and Applications (SAM), but not whole custom tables. I'm sorry, but you're on your own for that.