anybody can help me to understand the NNM's SOLID DB well?
i'm working on developing NNM's report, some questions to ask: 1.in table of snmp_daily_trend, i find the HOST_NAME column,but it indicate a node,like one ROUTER,how can i distinguish one ROUTER'S every interface's IN/OUT BYTES info? need i join it with other tables in NNM's SOLID DB to get what i wanted?
2.in same table of 1,how can i get exactly every hour's IN/OUT bytes info in one day of every node or interface? i find a column named INSTANCE,what it refer to?
3.by configured in NNM,can it save one WORKSTATION'S info,like disk utils,cpu utils, into nnm's trend table?