VNQM / IP SLA Operation Table Question

Question

We recently upgraded IP SLA v3.5.1 to VNQM v4.0.1 after the upgraded all of the IP SLA data was available. A few days later a DB Admin managed to remove the NetPerfMon DB. After the DB was imported from backup the data and all IP SLA operations had disappeared but the NPM nodes & data and the NTA data was available.

What table(s) does VNQM data reside within? Thank you in advance for any and all assistance.

bob55 · Answer

Hi,

Could you confirm the backup of the database, you have restored later, was made after the upgrade to VNQM 4.0.1? There is couple of db schema changes between 3.5.1 and 4.0.

Thanks,

Robert

jiri.tomek · Answer

Hello Webbster,

historical data for IPSLA operations are stored (based on operation type) in Voip*OperationResults_Daily/Detail/Hourly tables. Operation themselves are in VoipOperationInstances.