Skip to main content
Question

how can i convert OS EOL query into basis of vendor and version

  • March 5, 2025
  • 3 replies
  • 44 views
  • Translate

Forum|alt.badge.img+2

how can i convert OS EOL query into basis of vendor and version ?

 

as of now in OS Support query showing output via device wise , i want to see this in to vendor os wise.

3 replies

Andreas
Employee
  • Employee
  • 23 replies
  • March 5, 2025

Hi ​@Rohit_809 Kumar ,

It sounds like you want to show the Support values aggregated up to the vendor, os and os version level. You can use a “group” statement to do that. Here is a version that does that:

 

foreach device in network.devices
let platform = device.platform
let osSupport = platform.osSupport
where isPresent(osSupport)
group osSupport as osSupports
  by { vendor: platform.vendor, os: platform.os, osVersion: platform.osVersion
    }
    as platformInfo
foreach osSupport in distinct(osSupports)
select {
  Vendor: platformInfo.vendor,
  OS: platformInfo.os,
  "OS Version": platformInfo.osVersion,
  "End of OS maintenance": osSupport.lastMaintenanceDate,
  "End of OS vulnerability": osSupport.lastVulnerabilityDate,
  "End of OS support": osSupport.lastSupportDate,
  URL: osSupport.announcementUrl
}

 

Translate

Forum|alt.badge.img+2

Thanks ​@Andreas  , this is working for me , can we add also total no of devices that belong to same ios or model .

Translate

AricaFN
Employee
Forum|alt.badge.img+1
  • Employee
  • 11 replies
  • March 6, 2025

Hi Rohit,

This will give you the device count for each OS

foreach device in network.devices
let platform = device.platform
let osSupport = platform.osSupport
where isPresent(osSupport)
group device.name as devices
  by { vendor: platform.vendor, os: platform.os, osVersion: platform.osVersion, osSupport
    }
    as platformInfo

select {
  Vendor: platformInfo.vendor,
  OS: platformInfo.os,
  "OS Version": platformInfo.osVersion,
  deviceCount: length(devices),
  "End of OS maintenance": platformInfo.osSupport.lastMaintenanceDate,
  "End of OS vulnerability": platformInfo.osSupport.lastVulnerabilityDate,
  "End of OS support": platformInfo.osSupport.lastSupportDate,
  URL: platformInfo.osSupport.announcementUrl
}

 

Translate

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings