• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 23 subscribers
  • Views 235 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.

Database table in Orion to place about 500 servers into Maintenance

rdevarupala

Hi, I would like to know the database table name in which we can directly run query to read list of machine names from text file  that i wanted to put them in to maintenance. Currently i keep struggling to put about 300-400 machines manually every day to select and place them into maintenance using Orion console, which is very very painfull job for me. I need some script or backened process which will read the list of machines from a text and place them into Maintenance window. Please help  me out.

Thanks in advance.

Ravi

  • 0

    Here's a trivial powershell script that will do this.

    gc .\servers.txt |% {

        $nodeId = get-swisdata $swis "SELECT NodeID FROM Orion.Nodes WHERE Caption=@c" @{c=$_.Trim()}

        Invoke-SwisVerb $swis Orion.Nodes Unmanage @("N:$nodeId", [DateTime]::UtcNow, [DateTime]::UtcNow.AddDays(1), $false)

    }

    It assumes that each line servers.txt matches a Caption in the nodes table. It uses a query to look up the NodeID for that server, then unmanages the node for one day.

    You may want to add additional error checking and validation.

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.