License Saturation in SQL?

Hi All,

There is a Orion.LicenseSaturation table in SWQL.   Is there anything similar on the SQL tables?

Thank you,

Amit

Parents
  • Not that I can see, and you should avoid making calls directly to SQL whenever possible.  There's always a chance that the underlying database can change, but the SolarWinds Information Service (and thereby SWQL) shouldn't change.

  • I totally agree.   95% of the time I use SWQL.   Sometimes I find that on more complicated queries, going through Information Service can be a bit slow and the widget timesouts.   Whenever I want the fastest speed possible, I'll go the SQL route (taking into account that it does not use account limitations among other things).

  • From a technical sense, I don't know if the information is in SQL, but my guess is that it is somewhere - unless it's buried in the file system or something even more obscure..  However finding it (or collecting it across multiple tables if you have multiple products) seems more of a pain in this case.

    I've found that if you avoid JOINS and instead use Navigation Properties my SWQL queries run quicker.  It's only by a few milliseconds for me (but I only have a small server for testing).  It might be a larger time save on larger data sets.

Reply
  • From a technical sense, I don't know if the information is in SQL, but my guess is that it is somewhere - unless it's buried in the file system or something even more obscure..  However finding it (or collecting it across multiple tables if you have multiple products) seems more of a pain in this case.

    I've found that if you avoid JOINS and instead use Navigation Properties my SWQL queries run quicker.  It's only by a few milliseconds for me (but I only have a small server for testing).  It might be a larger time save on larger data sets.

Children
No Data