Hi Bruno,

All trending from an Aggregation rule will be saved under the elementName 'Skyline Generic Aggregator DMA<ID>'. So the easiest way to get this data would be to use the following filter

SELECT * from dataavg WHERE elementName = 'Skyline Generic Aggregator DMA<ID>'

Or if you want the data for all the agents in the cluster

SELECT * from dataavg WHERE elementName LIKE 'Skyline Generic Aggregator DMA%'.

For more specific trending you will need to get some data from the aggregations rule xml file. these can be found under C:\Skyline DataMiner\Aggregation

The central database columns have the following relations

• iDmaID = Dmaid part of <AggregationElement id="[DMAID]/[EID]"/>
• iEid = Eid part of <AggregationElement id="[DMAID]/[EID]"/>
• iPid = Parameter attribute of the <Trending>.<trend>
• chIndex = <AggGUID>.<ViewID>.<aggtableIndex>
• elementName = Skyline Generic Aggregator DMA<iDmaID>
• parameterName = Result value <chIndex>

  As an example I used the following settings:

Which generated the following (abbreviated) xml:

and these results:

To fetch the trending of i.e. row qaTable 500_1 we could use the following data.

• IDMAID
  • columname: iDmaID
  • Value: Dmaid part of <AggregationElement id="[DMAID]/[EID]"/>
  • Value in example: 408
  • Source of Value: XML->AggregationElement->dmaid-part
• IEID
  • columname: iEid
  • Value: Eid part of <AggregationElement id="[DMAID]/[EID]"/>
  • Value in example: 1110
  • Source of Value: XML->AggregationElement->eid-part
• iPid
  • columname: iPid
  • Value: Parameter attribute in <Trending>.<trend>
  • Value in example: 4005
  • Source of Value: XML->Trending->Trend->paramter Attribute
• chIndex
  • columname: chIndex
  • Value: <AggregationGUID>.<viewID>.<aggtableRowKey>
  • Value in example: bc6725aca0a64aeda06faf7e4b7f2c57.10654.qaTable 500_1
  • Source of Value:
    • Guid: XML->ID
    • ViewID: ID of the view named Aggreg (Can be found in the properties of the view)
    • TableIndex: Result->rowname (or-1 if standalone parameter)
• elementName
  • columname: elementName
  • Value: Skyline Generic Aggregator DMA<ID>
  • Value in example: Skyline Generic Aggregator DMA408
  • Source of Value:see iDMAID
• parameterName
  • columname: parameterName
  • Value: Result value <chIndex>
  • Value in example: Result value bc6725aca0a64aeda06faf7e4b7f2c57.10654. qaTable 500_1
  • Source of Value:see chIndex