• State Not Answered
  • Locked Locked
  • Replies 6 replies
  • Subscribers 26 subscribers
  • Views 831 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Where are my missing nodes?

brianbooher

If I run this query in SWQL Studio:

SELECT  SysName,  Uri,  Caption  FROM  Orion.Nodes 

I get 2076 rows.

But if I go into the Orion "Settings:Manage Nodes" set to "[No Grouping]" I get 5310 objects.

I am trying to change my nodes' "Caption" field and not seeing a bunch of nodes that I can see in the Manage Nodes list under "Name".

-Brian

 

  • 0

    What happens when you run an inventory report on all Nodes? Does is match the SQL output or Manage Nodes output?

    The following query will allow you to see if you have any duplicate nodes based on the Caption being unique:

    SELECT Caption from Nodes GROUP BY Caption HAVING count (*)>1

  • 0 in reply to m_roberts

    I created an All Nodes report and it returned 5310 rows.

    I ran the query you provided and it returned only 7 rows.

  • 0 in reply to brianbooher

    Are you running the swql report under a different account than the one you are accessing the web interface with? Just wondering if account permissions are limiting the return on the query. 

  • 0 in reply to marcrobinson

    Nope, using the same account when I log into SWQL Studio as I do when I log into Orion and create the all Nodes report or view all nodes in the Manage Nodes page.

  • 0 in reply to brianbooher

    So this smells like a permissions issue (just my 2 cents).

    Without knowing exactly what has been tried... have you:

    1. Closed SWQL Studio conpletely? Not sure a lot of people know this but just like SSMS (SQL Mgmt Studio) you can have multiple connections to different Orion servers using various authentication methods in the tool.
    2. Attempted logging in with the local admin account via SWQL Studio to run the exact query?

    Does this query give you the same resulting number?

    SELECT COUNT(n.NodeID) AS [TotalNodes] FROM Orion.Nodes AS n

    I've been tripped up by logging into multiple orion servers with different accounts in SWQL Studio and wondered why my numbers were off.

    Other things to think about are:

    1. How is you access given (AD Group)? Are you using an AD Account?
    2. What version of SolarWinds Orion are you on
    3. What version of SWQL Studio are  you using?

    Anyway I hope this helps and I'm mobile and have a bunch more thoughts on what you could look at / try by going to stop here for now lol

  • 0 in reply to sum_giais

    That was it. I had inherited my Solarwinds installation and the account we used for SWQL was limited to access only a single group. There was a lot in that group so I hadn't really noticed how much it was missing until now. Thanks to all for your assistance in this. -Brian

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.