Eric Bockman
asked on
How to purge incorrect SMS 2003 table data from "Software - Companies and Products"
Hello,
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?
Thank you,
Eric
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?
Thank you,
Eric
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That Chapter 5 business in the first link above is in the downloadable book at : http://www.microsoft.com/downloads/details.aspx?familyid=784838B3-34E0-4122-B3E2-17C5B4EEF8F4&displaylang=en - meant to have included that above...
ASKER
The solution was clear but it did not help in clearing up the amount of bad sinv's I'm getting. I ran through the data and it helped, I now only have to clean up once a week instead of daily.
ASKER