Checks

8 years ago

Complete the first step successfully. From the implementation of the script to its execution inside the Snow portal. I would like to thank the support provided by colleagues. In addition, the following question arose: How to pass to the portal a list of software that the computer has installed. select A.NAME AS Software from tblApplication AS A left join tabCID_cf_a_1 AS B on a.ApplicationID = b.ElementID LEFT JOIN tblComputerApplications AS C ON C.ApplicationID = A.ApplicationID LEFT JOIN tblComputer AS D ON D.ComputerID = C.ComputerID left join tblApplicationStoreData as E on e.ApplicationID = a.ApplicationID LEFT JOIN [SnowAutomationPlatformDomain].[DBO].[services] as portal on portal.name = a.name where OperatingSystem in ('Microsoft Windows 7 Enterprise','Microsoft Windows 10 Enterprise') and [Software Específco] = 1 and IsInstalled = 1 and HostName ='"+$ResSComp.NetbiosName+"'" I created a PS Web Service that receives the name of the computer and performs this query, but I do not know how to use it in the portal. The idea is to show in the portal a list of software that will be installed on the next computer. Thanks again to all.

Expand Post

1 of 13

RicardoPereira
8 years ago
Complete the first step successfully. From the implementation of the script to its execution inside the Snow portal. I would like to thank the support provided by colleagues. In addition, the following question arose: How to pass to the portal a list of software that the computer has installed. select A.NAME AS Software from tblApplication AS A left join tabCID_cf_a_1 AS B on a.ApplicationID = b.ElementID LEFT JOIN tblComputerApplications AS C ON C.ApplicationID = A.ApplicationID LEFT JOIN tblComputer AS D ON D.ComputerID = C.ComputerID left join tblApplicationStoreData as E on e.ApplicationID = a.ApplicationID LEFT JOIN [SnowAutomationPlatformDomain].[DBO].[services] as portal on portal.name = a.name where OperatingSystem in ('Microsoft Windows 7 Enterprise','Microsoft Windows 10 Enterprise') and [Software Específco] = 1 and IsInstalled = 1 and HostName ='"+$ResSComp.NetbiosName+"'" I created a PS Web Service that receives the name of the computer and performs this query, but I do not know how to use it in the portal. The idea is to show in the portal a list of software that will be installed on the next computer. Thanks again to all.
Expand Post

Related Topics