question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked Amandayou-MSFT commented

Software cannot be deployed through SCCM

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

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered Amandayou-MSFT commented

Hi @SahaSaha-5270,

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:

124939-8202.png

Here is the article about it:
https://docs.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.



8202.png (205.5 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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%"

0 Votes 0 ·

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

0 Votes 0 ·

The query is working, some of the PC's were not connected to VPN so the software was not deployed. We are good now.

0 Votes 0 ·

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

0 Votes 0 ·
GarthJones-9654 avatar image
0 Votes"
GarthJones-9654 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.