SMM MDM DB Growing, InvHist_DCName_Delta tables are not getting purged

book

Article ID: 157079

calendar_today

Updated On:

Products

Mobile Management

Issue/Introduction

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

Resolution

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.

 

Applies To

SMM 7.1 to 7.2 SP1

This issue will be addressed in SMP 7.5

Attachments

TruncateDeltaTables.sql get_app
Enable Mobile Inventory DataClass Purge edit.sql get_app
DataConnSchedule.xml get_app