• State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 27 subscribers
  • Views 722 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.

Report for all addresses with station is now

TFractal

Hi I would like to know Is it possible or not?

I need report with IP addresses + custom properties (it's Name_of_users)

I did it, but so as I understood - I got reports with historical data of addresses, how can I get result only last values of IP addresses + custom properties (Name_of_users) at the moment without history

Parents
  • 0

    What query are you currently using?

    This is one that I quickly got together to display the IP address assignments to nodes using SWQL.

    Select n.Caption, n.IPAddress

From orion.nodes n 

INNER Join orion.NodeIPAddresses i

ON n.NodeID = i.NodeID

Where n.UnManaged = '0'

    Does this query help as a building block?

Reply
  • 0

    What query are you currently using?

    This is one that I quickly got together to display the IP address assignments to nodes using SWQL.

    Select n.Caption, n.IPAddress

From orion.nodes n 

INNER Join orion.NodeIPAddresses i

ON n.NodeID = i.NodeID

Where n.UnManaged = '0'

    Does this query help as a building block?

Children
No Data

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.