@gbaron That is intended by the language of the query. Apparently we don’t have the info for those OSs. Whether they don’t exist yet, or we don’t have it. This is filtered out by the line
where isPresent(osSupport)
If there is not data, we filter it out.
I guess you are saying that you don’t want these filtered out. We would just show “null” or “no value” for these entries….?
In the short term you can try this version of the NQE query where I added if statements.
foreach device in network.devices
let platform = device.platform
let osSupport = platform.osSupport
select {
Device: device.name,
Vendor: platform.vendor,
Model: platform.model,
OS: platform.os,
"OS Version": platform.osVersion,
"End of OS maintenance": if isPresent(osSupport) then osSupport.lastMaintenanceDate else null: Date,
"End of OS vulnerability": if isPresent(osSupport) then osSupport.lastVulnerabilityDate else null: Date,
"End of OS support": if isPresent(osSupport) then osSupport.lastSupportDate else null: Date,
URL: osSupport?.announcementUrl,
Location: device.locationName,
Tags: device.tagNames,
"Collection IP": device.snapshotInfo.collectionIp,
"Management IP(s)": platform.managementIps,
Type: platform.deviceType
}
What I mean is that they are valid IOSs that should be listed. Roger opened a ticket about this as well. Appreciate the short term fix, but it doesnt help any as we are cross-referencing the output of the EOS data in that NQE to populate a STIG NQE, that requires parameters to run, in an effort to show devices passing or failing for an upcoming audit. So in reality, it doesnt work because the lack of EOS dates/data doesnt allow for a true pass/fail, which leaves us where we are with the Indeterminate outcome.