SMM MDM DB Growing, InvHist_DCName_Delta tables are not getting purged

Article:TECH196999  |  Created: 2012-09-20  |  Updated: 2013-10-27  |  Article URL http://www.symantec.com/docs/TECH196999
Article Type
Technical Solution


Issue



Symantec Mobile Management Growing as a result of Mobile Management Solution Delta History tables not getting purged


Environment



SMM 7.1 to 7.2 SP1

This issue will be addressed in SMP 7.5


Solution



1- Import the attached xml file (\Altiris\Notification Server\Bin\Tools\ImportExportUtil.exe /import "DataConnSchedule.xml" )
2- Run (TruncateDeltaTables.sql) SQL query to truncate Mobile Inventory History Delta tables.
3- Run (Enable Mobile Inventory DataClass Purge edit.sql) SQL to enable Mobile Inventory Purge edit.


Supplemental Materials

SourceETrack
Value2937865


Article URL http://www.symantec.com/docs/TECH196999


Terms of use for this information are found in Legal Notices