SMS_InstalledSoftware empty

[richtonp]

Hi,

 

We need to retreive informations from the table INSTALLED_SOFTWARE_DATA. I've read that this table is linked to the Asset intelligence. i've enabled AI and selected the SMS_InstalledSoftware (and other tables) in the client settings.

However i don't see this table ever being populated (neither the SMS_InstalledExecutable) on any of my clients. WMI explorer and queries returns me 0 instances. What i've tried :

Launched Full hardware inventory (and other inventory as well)

Reinstalled SCCM Client

Checked dataldr.log to see if MID file were processed correctly (no error)

Checked the ressource explorer (last inventory ok) + the nodes --> Hardware --> Application and Applications64 are giving me some results

 

Do you know if there is a way to monitor how the SMS_InstalledSoftware table is populated on a specific client ?

 

Thanks in advance for your advices

[GarthMJ]

Have you looked at the AI log on the client computer?

[richtonp]

Hi,

 

The AssetAdvisor.log returns

 

Inventoried 46 InstalledSoftwares

 

... Software list

 

Successfully Completed Inventory for SMS_InstalledSoftware AssetAdvisor 07/07/2015 16:58:12 5220 (0x1464)

However, nothing in the WMI class SMS_InstalledSoftware

[GarthMJ]

If the log shows that there are 46 and WMI doesn't, then it sound like your client(s) are not healthy.

 

I would suggest contacting CSS directly for support, they can work with you or solve this problem.

[richtonp]

Ok, i will. Thanks for your time.