Hi Pascal,
In your case method for file scan really does not look applicable as it resolves issues with inventoried files, but not software. Unless you use Software Catalog Data Provide Inventory task for discovering software based on inventoried files. Do you use it? If not then I don't think that removing records from Inv_Installed_File_Details may help to resolve your problem
Secondly I agree with Juri Zenkevits, it may be more efficient to work with Symantec support to localize root cause of your observation.
Anyway it would be good to have more details, so could you please collect the following information for one of affected computers(if you escalate this problem to Support then provide them with this information):
1) You mentioned that Inv_AddRemoveProgram table contains record for Software with the install flag = '1' for affected computer, however you believe that this software is not installed on computer already. How did you verify it? May you please provide screenshot or output from Inv_AddRemoveProgram with remarks what computer/software are reported incorrectly. Just to double check that Computer ResourceGuid and SoftwareComponentGuid match to affected computer and software.
2) May you please also make screenshot or output of 'Programs and Features' from Control Panel of affected computer?
3) May you please run non-delta Software Inventory Scan once again on affected computer but with additional steps
3.1) Enable Trace logging of Symantec Management Agent before running scan
3.2) Enable capturing NSE files before running scan.
to capture NSE on affected computer set the following registry key on this computer
[HKEY_LOCAL_MACHINE\SOFTWARE\Altiris\Altiris Agent\Transport]
"Capture Events Folder"="c:\\NSECaptures"
3.3) Provide Agent log captured during scan
3.4) Provide NSE files captured during scan(located on affected computer at location set in registry key in step 3.2)
3.5) Provide Software Cache file created by executed scan after scan is completed. This is XML file located at C:\Program Files\Altiris\Altiris Agent\Agents\SoftwareManagement\data\SoftwareCache.xml
3.6) May you also provide SMP logs from server captured in timeframe between "scan is started" and "scan results appear on NS'
4) You mentioned that you used detection rule in order identify "is software installed or not " using alternative approach. Does it mean that you used targeted software inventory policy? May you please provide screenshot of rule you used? Or you may export rule as XML and provide this XML file
5) It would be nice to have agent logs captured with Trace level when those detection policies are executed on affected client.
6) You mentioned that "compliance "flag" into CMDB not reset correctly". May you please clarify what do you mean? Is my understanding correct that you expected to see compliance status changed after you had modified detection rule? May you please provide more accurate description what rule was used before change and what rule was used after change(if you may provide screenshots it would be the best option)?
7) You mentioned that you tried to detect software using file version check. Is it possible to provide this file as well, so that you may try to reproduce
detection problem in-house
Sorry for a lot of questions/requests, but we need them to localize problem as root cause may be in different places..
Thank you,
Roman