[SMS_InstalledSoftware empty]

Ok, i will. Thanks for your time.

[SMS_InstalledSoftware empty]

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

[SMS_InstalledSoftware empty]

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

[WQL Split large amount of clients]

Hi,

 

We have around 18 000 clients on which we have to deploy a package.

We would like to split them into collections of 300 clients max,

But we'd like to go with dynamic collection.

18000/300 = 60 collections.

Unfortunately, from what i've understood in WQL, you cannot use query such as "SELECT TOP 100 where update XXX not installed "... for each collections.

Do you have a tips that could help me with that ?

One solution would be to use the GUID , that would allow me to create 16 different collection for this update

"Select client where where update XXX not installed and GUID end by 1"

"Select client where update XXX not installed and GUID end by 2"

...

"Select client where update XXX not installed and GUID end by F"

But 18000/16 = 1125

Do you have another idea ?

 

Many thanks for your help