Software cannot be deployed through SCCM

Question

Software cannot be deployed through SCCM

Avyayah 1,291

Created a package with associated Device collection. The following query is used to deploy the application.
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_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name = "MachineName" and SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%SAP GUI for Windows 7%"

or

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_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_R_System.Name in ('MachineName','MachineName2') and SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%SAP GUI for Windows 7%"

Any thoughts on why this query is not working. The executable will not deploy on the chosen PC .

Can someone direct me to right forum where I can ask questions on system center configuration Manager

Accepted answer

1 additional answer

Your answer

Answer 1

Amandayou-MSFT 11,156

Hi @Avyayah ,

We could find one of client which is deployed with the software 'SAP GUI for Windows 7%' to check if the application is installed in this client.

Besides, applications in Configuration Manager support state-based monitoring, which enables you to track the last application deployment state for users and devices. We could refer to this picture:

Here is the article about it:
https://learn.microsoft.com/en-us/mem/configmgr/apps/deploy-use/monitor-applications-from-the-console

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Avyayah 1,291 Reputation points

2021-08-21T20:57:04.127+00:00

@Amandayou-MSFT Yes, I am familiar with deployment but need suggestions on this query- Can we use in clause in query if there are more than one computer?
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_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Name in ("X1, X2")and SMS_G_System_INSTALLED_SOFTWARE.ARPDisplayName like "%SAP GUI for Windows X%"
Amandayou-MSFT 11,156 Reputation points

2021-08-25T08:10:03.063+00:00

Hi,

Thanks for your reply.

I checked the query, it seems there is no problem, as Garth mentioned, we should check if there is the software is listed in resource explorer firstly.

Best regards,
Amanda
Avyayah 1,291 Reputation points

2021-08-25T13:14:29.28+00:00

The query is working, some of the PC's were not connected to VPN so the software was not deployed. We are good now.
Amandayou-MSFT 11,156 Reputation points

2021-08-26T09:20:53.83+00:00

Hi,

Thanks for your update. I am glad to hear that the problem is solved. If you have any other issues, please don't hesitate to let us know.

Thanks and have a nice day.

Best regards,
Amanda

Answer 2

Garth Jones 1,666 MVP

Have you confirmed in resource explorer that the software is listed for these computers?

Share via

Software cannot be deployed through SCCM

1 additional answer

Your answer