Views Resources table in SWQL?

Is there a complement to the Resources table from the SQL Database (dbo.Resources) in SWQL? (I cannot see anything but the Views table in the latest stable release of SWQL Studio)

In line with this feature request ( ) I would like to make a temporary work around using a Custom Query Resource that would be similar to this in SQL:

SELECTv.ViewTitle 'VIEW TITLE',r.ResourceName 'RESOURCE TYPE',r.ResourceTitle 'RESOURCE TITLE',r.ViewColumn 'VIEW COLUMN',r.Position 'VERTICAL POSITION'FROM Views vJOIN Resources r ON r.ViewID = v.ViewIDWHERE v.ViewID = 1 --SWQL: WHERE v.ViewID = ${ViewID}ORDER BY r.ViewColumn, r.Position

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

Find more posts tagged with

SWQL

loop1 systems

Accepted answers

All comments

tdanner

The next release has SWIS entities for "Orion.Views" and "Orion.Resources".

zackm

Thanks tdanner. Do you know if a variable such as ${ViewID} would work in a situation like this as well?

tdanner

${ViewID} does not seem to be an available macro. I don't see any other macros specific to the view that you could use either.

wluther

tdanner & zackm I have been waiting for these two for a while now... I wonder what else will be in the next release. Are you at liberty to say, estimate, guess, mention, or acknowledge, or will the suits in fine print come looking for you?

lol...

tdanner

Are you in the NPM 12 beta? That would be the best way to learn all the ins and outs before the release. There's a lot of stuff - NPM 11.5 was more than a year ago.

wluther

tdanner Yes sir, I am in that beta. However, my tiny brain must be malfunctioning, again, as usual, as it did not send me the memo to simply point my sdk login to the beta server... pfft... how worthless can I be... WAIT... nobody answer that!

Thanks,

-Will