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.

Extract Name and EOL_Date from orion database

Hello Experts,

I want to extract network device EOL_Date from Orion database , How to do it using powershell.

I need the name of the node and the assoicated EOL

Thanks in advance.

-Prashant Girennavar.

  • To run SWIS queries from PowerShell, install the Orion SDK and run these commands:

    Add-PSSnapin SwisSnapin

    $swis = Connect-Swis -hostname YourOrionServer -Username YourOrionUsername -Password YourOrionPassword

    Get-SwisData $swis "SELECT n.Nodes.Caption, n.EndOfSupport, n.EndOfSales, n.EndOfSoftware, n.EosLink FROM NCM.NodeProperties n"