tblSoftware size exploded

[csac_it]

We have 575 assets, using Microsoft SQL LocalDB, and the database is running out of room because the tblSoftware table is up to 6,476,624 kb with an index of 2,927,720 kb (that's about 9.3 GB of the max of 10.2 GB for localDB).

Looking at the Software tab, there is one item, 'ms-resource:AppStoreName v. 1.0.61591.0' which has 25,840,476 entries (for only 575 assets mind you). The tblSoftware table has 25,855,269 lines, so presumably this one item accounts for more than 99.9% of the table size.

I have disabled SOFTWAREMSSTOREAPPS from scanning, but that doesn't seem to be getting rid of the entries. I have run Truncate logs and Shrink numerous times, with little effect.

How do I clean up the table? Thanks.

[csac_it]

It has been almost 24 hours since I upgraded, and there has been no reduction in the table size, so I am assuming something manual needs to be done; is there any help available on what I should do?

[Mercedes_O]

Hi @csac_it  please contact our support team so that a colleague can investigate further Contact Support - Lansweeper IT Asset Management

[csac_it]

I have downloaded and installed 11.1.0.11. Will the extra lines get deleted over time, or do I need to do anything specific to clean them up?

[ErikT]

@csac_it,

The issue should be fixed in version 11.1.0.11 released today. 

You can download it here: 

Update Lansweeper - Lansweeper IT Asset Management

[dougohm]

Hi Erik,

I see ~10,000 instances of this software name in my environment of ~800 computers. We are currently running 11.1.4.6. Do we need to perform any of the manual cleanup steps described in other posts here? Please let me know if you need any additional information from me. Thanks!