Client Management Suite

On a 7.1 SP2 (and even with earlier version) we have noticed that if an EXE file has been deleted from a client it remain into the database even after a Complete Inventory.

This is a HUGE problem i think cause the value in the inventory cannot be trusted ...(we have a case opened, still without solution after several webex)?

Some one has the same experience?

Do you have more information about the "it" that remains in the database?  What report are you working with?  What .exe is deleted?  What is your full inventory schedule?

Is the exe still listed in Resource Explorer for that PC or just listed in the CMDB? I think unused files are only cleaned from the CMDB by the "Clean File Resources" Task weekly by default.

Even if you do a full Software Inventory, this won't necessarily inventory file resources, you have to select that additionally. And it may be that a delta won't detect individual file changes.

Severa exe file were deleted for example Skype.exe I've worked on audio software and built by ourself some report using inv_file_details table and vcomputer. Full inventory is monthly But has bene run as task severa time eventuali by Symantec support

The file is stil present on resource explorer. Not present on NSI The task clan file resource gas run severa time We do complete inventory not delta checking all the options needed and Symantec support did it by theirself too. :(

Inv_File_Details shows all files inventoried on any computer ever.  There is nothing in the table that I see that ties it to a computer in vComputer.

For example, this SQL query:

I had a similar issue - if u run this script as a task, does it clean it up?  that's what support suggested to me.

if exist "C:\Program Files\Altiris\Altiris Agent\Agents\SoftwareManagement\data\softwarecache.xml" del "C:\Program Files\Altiris\Altiris Agent\Agents\SoftwareManagement\data\softwarecache.xml"

 

you have right about "Inv_File_Details" .. it was the frustration ...

this is the exact query i can use to check

 

select * from dbo.Inv_Installed_File_Details iifd

join vComputer vc on vc.Guid=iifd._ResourceGuid

where iifd.Name='skype.exe' and vc.Name like '%NAMECOMPUTER%

 

Using the 2nd query is mine same workaround ... in that way the results are correct.

BUT i cannot ask the customer to use if he has to count program like putty.exe and so on that are NOT installed on a system ...

I've re-run a software inventory on these computer several time but skype.exe still there in the report (not on the endpoint)

Thanks sally,

 i'll give a try next day and report here for results.

Why not just use a Compliance Report or Installed Software report accessible when right-clicking on a Managed Software Delivery policy?  I assume this is a software resource you defined, which is associated with an active MSD policy.

I'm not sure why you're using Inv_Installed_File_Details when you should be using Inv_AddRemoveProgram.

In my case, the old software was showing up when viewing a computer record in CMS and toggling to 'licensed programs' and i wanted that info to be correct for quick viewing

You cannot track file like putty that aren't installed, or portable software if you use Inv_AddRemoveProgram 

Compliance Report is really useful if you need to meter the license, BUT if you are checking only the presence of a file that's not useful.

In mine opinion it is completely unfair that if a file has been deleted it remains present on the DB....

Still the same problem ... can be related to the date not in english format?

Deleted files and deleted programs will only be noticed by a Full inventory.  A delta inventory is not sufficient to detect this change.  You should perform a Targeted Software Inventory if you need data that takes into account uninstalled software for programs like Putty.  Any Managed Software Delivery is going to have a detection rule, and that detection rule will inform a Compliance report, so you shouldn't need to wait for a Full inventory in those cases.

But yes, short answer, if a program .exe is deleted, or if a program is uninstalled and no longer appears in Add/Remove Programs, it will take a full inventory to tell the CMDB that it should no longer be listed in Inv_AddRemoveProgram, for example.

Does this answer your question?

exatly same problem deleted files will be not removed from "Inv_Installed_File_Details".