syeal01 ✭✭✭✭✭

I searched THWACK also but didn't find anything. We know that Solarwinds central location for Orion Core logs is C:\ProgramData\SolarWinds\Logs\Orion*. I am guessing most likely List Resources writes its output into those standard Orion log directories.

Checking out your first Query, noticing that you are scanning (JOIN) table Orion.AuditingEvents twice. First get the MAX(…TimeLoggedUtc) and then again for AccountID. Also the ORDER BY in this AccountID subquery looks to me unnecessary sorting. The first query can be made twice as fast I believe fixing above.

Completed

Are you able to reach your DPN Server from Solarwinds Main server? We use SAM for server monitoring. SolarWinds SAM

Hmmm that wouldn't work, right? because I am trying to get interfaces of a Node so basically my 'known' initially is a Hostname or IP Address of a node. But I tried your suggestion with something like this but results with empty Rows. <span class="s5">SELECT</span><span class="s0"> </span><span class="s10"> [</span><span…

I thought using TOP 1 was working but it isn't. Still researching...

Suggest checkout Datetime functions OrionSDK/wiki/SWQL-Functions

Hi Rich, thanks for fixing table connections. I tried your version but getting same results with 368 rows. My test: SELECT NodeID FROM Orion.Nodes WHERE IP_Address = '...' I note down nodeID. SELECT Caption FROM Orion.NPM.Interfaces WHERE NodeID = '<nodeid>' This gives me 19 rows. SELECT IPAddress FROM…

It was my bad. Works Ok. Thanks.

Both these; Truncate NCM_policycache and Truncate NCM_PolicyCacheResults gives error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'NCM_PolicyCacheResults'. Also, how do we Restart the NCM Caching?

Ah thank you so much. I am back in business, queries are now working.

No no still same behavior. My previous update was in addition to your suggestion. I have one Local Admin user - this is the one that does not show any output to NCM.* tables. You suggested DOMAIN\User. This is what is giving me Timeout in SQWL Studio. Thanks for NCM Access screengrab. I am going to check both Local Admin…

Thank you and I tried to use my SSO ID as DOMAIN\name.name but I keep getting Timeout error. Do you think my SSO ID does not have access to Information Service? What setting to enable for that. 

I am definitely connected. The queries on Orion table all works. 

I have a feeling it is something to do with Server Type version because the old posts talks about v2. In Connect To dialog box, I only see v3.

Thank you much. I tried on dozens and all I got was empty Result. NCM.Nodes would definitely be what I am looking for but show empty for me. (Few other tried e.g. FROM NCM.TransferResults, FROM NCM.Interfaces, FROM NCM.ConfigTypes) <span class="s5">SELECT</span><span class="s0"> </span><span class="s5">TOP</span><span…

Edited my 'ask'.