querybuilder - How do I request the SystemObjectID and subnet information

book

Article ID: 210667

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction

How do you get the SystemObjectID and subnet/mask for a device in querybulder?

Environment

Release : 20.2

Component : OPENAPI

Resolution

These field are not available in query builder. However they can be obtained using REST. 

This list can be obtained using by using the REST filter below and doing a POST to the URL http://<DA_SYSTEM>:8581/rest/devices/manageable/filtered in a rest client 

<FilterSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filter.xsd">
    <Select use="exclude" isa="exclude">
        <Item use="exclude">
            <Name use="include"/>
        </Item>
        <ManageableDevice use="exclude">
            <SystemObjectID use="include"/>
        </ManageableDevice>
        <Device use="include">
            <Longitude use="exclude"/>
            <Latitude use="exclude"/>
            <Elevation use="exclude"/>
            <DiscProfileID use="exclude"/>
            <ChangeDetectionDisabledMFs use="exclude"/>
            <PolledItemCount use="exclude"/>
            <SupportedProtocols use="exclude"/>
            <CalculatedContactStatus use="exclude"/>
            <ContactStatus use="exclude"/>
            <StopLoading use="exclude"/>
            <PrimaryIPAddress use="exclude"/>
            <supportsOnDemandMFDiscovery use="exclude"/>
            <StopPoll use="exclude"/>
        </Device>
    </Select>
</FilterSelect>