hi all, i've downloaded the trial version of SCCM and i'm running it on vm workstation for testing purposes. i'm trying to create a collection in SCCM where in it can find clients which have word installed on them. pic1 shows the basic setup of my enviournment. pic2 shows some details about the collection. This collection is not specific to any collection but it is for the entire systems query. pic 3 shows the collection setup. i am not sure where I am going wrong. I was following a video series to do this but things are not falling my way. Can you all please let me know where I am going wrong. Thank you in advance. Vaibhav

Some how I am not getting the option to upload the pics from where I can do this thanks ......

There is no way to upload pictures to the MS forums. http://www.enhansoft.com/

Hi, Without seeing the picuters, if I understand your question, you want to create a collection for all computers with Word installed. The following query uses Software Inventory so it has to be enabled, it will include all systems with winword.exe present on the system. select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_EXECUTABLE on SMS_G_System_INSTALLED_EXECUTABLE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_EXECUTABLE.ExecutableName = "WINWORD.EXE" Regards, Jörgen-- visit my System center blog at http://ccmexec.com --

Thanks for replying ...... if i am not able to upload the pics then shall i write down the steps that I followed ? That will be lengthy. Can you let me know which logs i can check or what can i check next ?

You could post the query you are using.. that would be a start. Regards, Jörgen-- visit my System center blog at http://ccmexec.com --

Thank you for your reply .... I changed the query as you suggested but no go .... it is still not showing results ....... I have two collections here, one is linked to a specific collection and the other is one is linked to unlimited ..... both donot show any results .....

earlier it was like select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "winword.exe" and then I changed it to select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_INSTALLED_EXECUTABLE on SMS_G_System_INSTALLED_EXECUTABLE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_EXECUTABLE.ExecutableName = "WINWORD.EXE"

I gave it some time but still it is not able to look for the clients in the collection that I made ..... is there any log of file that i can refer to in this case ?

Bring up Resource Explorer for that client and double-check the data that were delivered by software inventory.Torsten Meringer | http://www.mssccmfaq.de

What is the "Schedule" in your "Software Inventory Client Agent". As far as I remember the standard is every 7 days ? Have you tried to make a force a manual "Software Inventory Cycle" on the clients and then "Update Collection Membership" on the ConfigMgr Server.

Thank you for the reply, Torsten ------ I Installed VLC player on one of the client machines and when I brought up resource explorer then it was seen there. Collection was able to also resolve it after applying the query for it however MS-Word / Powerpoint / Excel is not seen in the resource explorer. I even installed MS office on a vista machine but the result is same in the resource explorer. "winword.exe" is missing -- (RE-resource explorer) shows wordicon.exe in there. Michael ------- I changed the software inventory to 1min and even I initiated action for "Software Inventory Client" but as Torsten mentioned the file is not seen in RE. Even calc.exe and mspaint are not reflected in RE....... Any specific reason why MS - Word is not showing up ??? Thanks

How is the software inventory client agent configured? What paths are included and what is excluded? 1min for the SINV cycle is way too aggressive BTW.Torsten Meringer | http://www.mssccmfaq.de

The general tab has the option checked for "enable software inventory on clients" -- simple schedule run @ every 1 min. Under Inventory collection -- file type names is *.exe ......... path is all client hard disk .......... subdirectories yes ............. exclude none ......... reporting details -- file and product details are checked Under file collection --- name *.exe .............. path all client hard disks ................ subdirectories yes ............. size 128 kb ............ exclude none ............. under inventory names ----- name type -- Manufacturer ........ display name ---- Microsoft Corporation ......... This is my test environment so I am not worried about schedule to pull details. Please let me know if you require any other info. Thank you for your time Torsten.

Change the simple schedule to once per day (SINV can run longer than one hour depending on the performance of your testmachines and # of files on the disks). "File collection" has nothing to do with inventory. I suggest disabling that completely (as it copies files from the disk to a inbox on the server). Wait for at least some hours after you changed those settings and give the MP / site some time to process that huge amount of data. The data might show up then after the backlogs were processed (and I guess that there will be a backlog).Torsten Meringer | http://www.mssccmfaq.de

Hello Torsten , I went to the Software Inventory Client Agent and changed the simple schedule to 1 day. Unchecked file collection but still the winword.exe is not present in resource explorer. Any suggestions Thank you Vaibhav

Good news at last ..... the collection shows the machine that have MS - word installed on them. However there is something strange, When I run Resource explorer for client then under file details winword.exe is not mentioned there. However my collection was able to find it. how can this be possible ??? please advise. Thank you

You most like have two resources with the same name. Delete the older resource from your site. http://www.enhansoft.com/

Under all systems I only have one entry for each client ..... no duplicate entries are there ..... please advise. Thank you all

If it show that the exe is there within the collection then it must also be within the resource explorer. They are both getting the data from the exact same place so…. http://www.enhansoft.com/

I agree with you Garth, the data is pulled from the same place. However what I was confused about is the machines are seen in the collection. When I check resource explorer from them then winword.exe is missing. I know this sounds strange ..... but not sure what to do next