How to purge incorrect SMS 2003 table data from "Software - Companies and Products"
Posted on 2009-07-14
I have an SMS 2003 server that appears to be keeping data on non existent software. When I run a report on to find old software in our network, the report puls up thousands of machines that supposedly have the old software on it. After verifying that the old software is not on the machines, I run the report again, and it still shows the software as loaded. I have setup the client agents software inventory to collect data once a day. I have also set the site maintenance tasks of delete aged inventory history (actually delete everything is set), and yet this old data still shows up in the reports. Is there a way to quick purge the data in the "Software - Companies and Products" table and have SMS Repopulate it?