SWQL Equivalent of NodeListResourcesCache table

To date I have reported on the last time 'list Resources' was run against a node by querying the table named NodeListResourcesCache directly via MS SQL. I cannot find an equivalent using SWQL. Anyone know if this is exposed

Find more posts tagged with

sql

npm

Accepted answers

All comments

shocko

Bump

flackovic

I wasn't able to find a simple solution in SWQL Studio, but you can run SQL queries using SWIS by using the Orion.Reporting ExecuteSql verb.

A short example in PowerShell:

$result = Invoke-SwisVerb $swis 'Orion.Reporting' 'ExecuteSql' "SELECT CachedTime FROM [dbo].[NodeListResourcesCache] WHERE NodeID = XXXX"

$result.diffgram.DocumentElement.ExecuteSQLResults.CachedTime

You would have to adjust the query and script for your exact needs for how you'd like to present the data.

DGNetops

Very nice! I am going to test this out. I have been trying to tweak and optimize a list resources automated job that is running too long. I want to have the ability to use this to check the last time the node list resources was ran for a device.