• State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 25 subscribers
  • Views 875 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.

Check Specific Device Against Latest IOS version

sceritz

I am using NCM to try to identify which of our devices are not on the latest version. Currently we have some older devices that are going to be replaced shortly, but they are generating way too many vulnerability warnings to sift through. Our main device is the newer 3650, and some ot the 2960X's among a few other things. How do I check on basis of device name which devices do not have the latest vulnerabilities without trying to sift through the entire CVE list trying to figure out which vulnerabilities apply to which device?

For example is there a way to query a list of only 3650 WS-C3650 that aren't the latest firmware version?

Parents
  • 0

    You can build a custom query for this quite easily. I use something like this:

    SELECT n.Caption, n.MachineType as Machine_Type, n.IOSVersion as Software_Version

    FROM Orion.Nodes n

    WHERE

    (MachineType LIKE 'Cisco Catalyst 29%x%' AND IOSVersion NOT LIKE '15.2(4)E7%')

    OR (MachineType LIKE 'Cisco 2960' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'Cisco Catalyst 2960-24TC' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'WS-C3560V2-24PS' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'Cisco Catalyst 38%' AND IOSVersion NOT LIKE '16.3.7%')

    OR (MachineType LIKE 'Cisco Catalyst 93%' AND IOSVersion NOT LIKE '16.9.3%')

    OR (MachineType LIKE 'Cisco 29%' AND IOSVersion NOT LIKE '15.6(3)M6%')

    OR (MachineType LIKE 'Cisco 39%' AND IOSVersion NOT LIKE '15.6(3)M6%' )

    OR (MachineType LIKE 'Cisco 4%' AND IOSVersion NOT LIKE '16.3.7%' )

    OR (MachineType LIKE 'Cisco ISR4%' AND IOSVersion NOT LIKE '16.3.7%' )

    ORDER BY n.Caption ASC

Reply
  • 0

    You can build a custom query for this quite easily. I use something like this:

    SELECT n.Caption, n.MachineType as Machine_Type, n.IOSVersion as Software_Version

    FROM Orion.Nodes n

    WHERE

    (MachineType LIKE 'Cisco Catalyst 29%x%' AND IOSVersion NOT LIKE '15.2(4)E7%')

    OR (MachineType LIKE 'Cisco 2960' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'Cisco Catalyst 2960-24TC' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'WS-C3560V2-24PS' AND IOSVersion NOT LIKE '12.2(55)SE12%')

    OR (MachineType LIKE 'Cisco Catalyst 38%' AND IOSVersion NOT LIKE '16.3.7%')

    OR (MachineType LIKE 'Cisco Catalyst 93%' AND IOSVersion NOT LIKE '16.9.3%')

    OR (MachineType LIKE 'Cisco 29%' AND IOSVersion NOT LIKE '15.6(3)M6%')

    OR (MachineType LIKE 'Cisco 39%' AND IOSVersion NOT LIKE '15.6(3)M6%' )

    OR (MachineType LIKE 'Cisco 4%' AND IOSVersion NOT LIKE '16.3.7%' )

    OR (MachineType LIKE 'Cisco ISR4%' AND IOSVersion NOT LIKE '16.3.7%' )

    ORDER BY n.Caption ASC

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.