Client Management Suite

 View Only
  • 1.  InvHist_SoftwareProduct_InstallationInfo Table Grown to 57 GB

    Posted Jan 20, 2011 11:29 AM

    Our NS 7 database has ballooned to 90 GB and after working with our DBA we discovered the InvHist_SoftwareProduct_InstallationInfo table is a whopping 57 GB.  The current plan is to truncate this table as we do not do any software inventory at our university.

    My questions is, does anyone know why or how this may have occurred?  More importantly, is there an obvious NS setting I may have misconfigured?

    Thanks,

    Bryan



  • 2.  RE: InvHist_SoftwareProduct_InstallationInfo Table Grown to 57 GB
    Best Answer

    Posted Jan 20, 2011 03:49 PM

    You have to disable the history of resources
    in the NS, Clic in Settings > All Settings

    go to the folder

    Settings > Notification Server > Resource and Data Class Settings > Resource Hystory

    then disable o change "Keep History Duration"

    Software License Evaluation Data Classes  > SoftwareProduct InstallationInfo

    or

    Software Management > InstalledSoftware

    Attached Images



  • 3.  RE: InvHist_SoftwareProduct_InstallationInfo Table Grown to 57 GB

    Posted Jan 21, 2011 03:44 PM

    Awesome, thanks Cesar.  I disabled SoftwareProduct InstallationInfo and verified that InstalledSoftware was set to 6 months.