When I click on a computer in the SMP Console I get the below error in the Altiris log viewer on the NS:
MainController failure.
Invalid object name 'vInv_SepAgentHealth'.
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
ITMS 8.6 RU1
There Table Views and Data Classes for SEP Agent Health were missing from the database.
Views:
vInv_SepAgentHealth
vInv_SepAgentHealthInternal
vInv_SepAgentHealth
Tables / Data Classes:
Inv_SW_SEPagent
A repair needed to be run in Symantec Installation Manager (SIM) to put the SEP Agent health pieces back into the database. We did a full repair, however, SEP Agent should be part of Inventory, so a repair (or maybe reconfig) of Inventory should be sufficient.