AnsweredAssumed Answered

Extracting data from "notes" field

Question asked by JeroenDG on Oct 23, 2017
Latest reply on Oct 27, 2017 by Declan_Dempsey

Hello

 

A customer has asked to extract the content of the "Notes" field from devices in spectrum. 

I have followed this document: Configure User-Defined Device Attribute Polling - CA Spectrum - 10.1 to 10.1.2 - CA Technologies Documentation 

 

 

And came up with this: 

<devicemodel-polling xmlns="http://www.ca.com/SRM/AttributePollMapping"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<user-defined-poll modelType="GnSNMPDev">
<poll-attribute attrId="0x118b8">
<varchar-storage id="1"/>
<reports label="Company Name Cisco"/>
</poll-attribute>
<poll-attribute attrId="0x11564">
<varchar-storage id="4"/>
<reports label="Notes"/>
</poll-attribute>
<poll-attribute attrId="0x118bc">
<varchar-storage id="2"/>
<reports label="Description"/>
</poll-attribute>
<poll-attribute attrId="0x114e2">
<int-storage id="4"/>
<reports label="DisposablePrecedence"/>
</poll-attribute>
<poll-attribute attrId="0x11554">
<varchar-storage id="3"/>
<reports label="Create_IF_Port"/>
</poll-attribute>
<poll-attribute attrId="0x11b41">
<datetime-storage id="1" />
<reports label="CreateTimeNow" />
</poll-attribute>
</user-defined-poll>
</devicemodel-polling>

 

 

 

This is were I added:

<poll-attribute attrId="0x11564">
<varchar-storage id="4"/>
<reports label="Notes"/>
</poll-attribute>

 

The file is stored in \spectrum\tomcat\webapps\spectrum\web-inf\repmgr\config\devicemodel-polling.xml

 

Now, were can I find the output of this? I am using a mysql query browser. 

 

In the end, I need this data to create a report in JasperSoft. 

 

I must admit that I am new to the CA technologies so please excuse me if there is an obvious answer to this question. 

Outcomes