Find all devices with same SysOID

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

- Is there a way to find all the devices with the specific SysOID in question?

- - - - - -

SysOID:

1.3.6.1.4.1.8072.3.2.10

 

System Description:

Linux nhnaunxlpdmp041.goldlnk.rootlnka.net 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 11 19:12:04 EDT 2020 x86_64

- - - - - -

 

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Cause

n/a

Resolution

Using REST you can do a filtered get with a body that looks at ManageableDevice.SystemObjectID value

This finds devices with sysOID = 1.3.6.1.4.1.9.1.1145

 <FilterSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filter.xsd">      <Filter>         <ManageableDevice.SystemObjectID type="EQUAL">1.3.6.1.4.1.9.1.1145</ManageableDevice.SystemObjectID>      </Filter>      <Select use="include" isa="exclude"/>   </FilterSelect>

 

You can also do a query in MySql on CAPC, using the netqosportal database;

select * from t_device where SystemOID= '1.2.3.4.5 ....'\G;

Of you can run something like this, if you want to limit it to the Data Aggregator; this assumes Data Source ID of 3, but yours may be different

select ItemName from dst_device where SourceID=3 and SYstemOID='1.3.6.1.4.1.9.1.2101' \G;

 

You can also output the queries to a file

./mysql -uroot -pnetqos -D netqosportal -e 'select ItemName from dst_device where SourceID=3 and SYstemOID="1.3.6.1.4.1.9.1.2101" \G' > /tmp/output.txt