Find all devices with same SysOID
search cancel

Find all devices with same SysOID


Article ID: 204621


Updated On:


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


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

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

- - - - - -



Release : 3.7

Component : IM Reporting / Admin / Configuration




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

This finds devices with sysOID =

 <FilterSelect xmlns:xsi="" xsi:noNamespaceSchemaLocation="filter.xsd">      <Filter>         <ManageableDevice.SystemObjectID type="EQUAL"></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= ' ....'\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='' \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="" \G' > /tmp/output.txt