• Mike Rockwell (Progress Software)

    Here's the Query:

     

    1. SELECT PivotDeviceToDiscoveryRoleTemplate.DeviceID
    2. FROM DiscoveryRoleTemplates INNER JOIN
    3. PivotDeviceToDiscoveryRoleTemplate ON DiscoveryRoleTemplates.nDiscoveryRoleTemplateID = PivotDeviceToDiscoveryRoleTemplate.DiscoveryRoleTemplateID
    4. WHERE (DiscoveryRoleTemplates.KindOfRole = 2) AND (DiscoveryRoleTemplates.Name Like N'Windows%')

    IF you want to do Cisco IOS, change the "LIKE N'Windows%' do = N'Cisco IOS' to match exactly "Cisco IOS". If you want to just look for Cisco, then replace "Windows" with "Cisco"