Does Software Center detect manually installed programms too ? / Office 365 query returns wrong client

IT Guy 106 Reputation points
2020-12-22T10:55:38.217+00:00

Dear community.

I am new to application packaging and i have a few basic questions.

  1. When i create an application for my Software Center but someone installs the same software manually, will the Software Center on the client show that application as "installed" ?
  2. Will i find this manuall installations when i create a collection with a query ?
  3. I have problems to create a query to find an installed Office 365 32 bit software.
    I made two packages for Office 365 with the integrated assistant (32 bit and 64 bit).
    I installed the 32 bit package sucessfully on a client and also 64 bit on an other client. Then i made two software queries to find these Office 32 Bit / 64 bit installations.
    Now, the client with the 32 bit version is displayed as a member of the 64bit collection but the installed Office 365 software version is definitely a 32 bit version. I had installed also the 64 bit version once on that client but now the 32 bit version is installed and works fine.
    You can see in the screenshot i took from the task manager, winword.exe is a 32 bit application.

50300-winword-32bit.png

i have these two queries for Office 365 from the internet:

This query should find 32 bit installations but founds nothing

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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft 365 Apps for enterprise - en-us"

this query found a correct one (64 bit version) and a system with a 32 bit version

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_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Microsoft 365 Apps for enterprise - en-us"

how can i check what data is stored in the SCCM / MECM for that mistakenly detected client ?
I think the 64 bit query is correct because it also finds a machine that really has office 64 bit installed, so i think there is something wrong with the stored data of the other client with the 32 bit version.

When i use te Ressource Explorer on the SCCM to check the client data, i found Office 365 as a 32 bit version (Install path) but the query for 64 bit still returns that client

50377-ressource-explorer.png

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
467 questions
0 comments
Accepted answer
  1. Jason Sandys 31,186 Reputation points Microsoft Employee
    2020-12-22T20:34:11.383+00:00

    Software Center doesn't detect anything. Software Center is simply a user UI.

    1. Yes, it will be shown as installed as long as it meets the defined detection methods for applications deployed to a system.
    2. Yes, once again assuming it meets the criteria for the query you provide. Don't confuse the application inventory collected by hardware inventory with detection methods defined in your applications though as these are two different and unrelated mechanisms.
    3. SMS_G_System_ADD_REMOVE_PROGRAMS_64 corresponds to Installed Applications (64) in Resource Explorer and SMS_G_System_ADD_REMOVE_PROGRAMS and corresponds to Installed Applications in Resource Explorer. The Installed Software category in Resource Explorer is based on information gathered by Hardware Inventory as well but is part of Asset Intelligence and corresponds to the SMS_InstalledSoftware class in WMI. Keep in mind that Hardware Inventory is not a dynamic process though and is only periodically collected based on your client settings. Thus, your queries are not the same as the data you've highlighted in Resource Explorer.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. IT Guy 106 Reputation points
    2020-12-24T09:34:18.553+00:00

    Thank you very much for your feedback and for your permanent support.

    Wish you a happy x-mas and a great 2021.

    0 comments