Marketplace_CA_8911

Trouble with bind parameters in SEC_SQL

Discussion created by Marketplace_CA_8911 on Jan 9, 2018
Latest reply on Jan 11, 2018 by Marketplace_CA_8911
Hi All,

I am working on an Automic workflow that can push software to various others systems in our infrastructure using API integration with our S/W Delivery system. Although it works fine, we realize that for every system that a s/w needs to be pushed to, we need an API call to fetch the "system-id". This is causing the number of API calls to escalate very quickly in some scenarios.

The other option I have is to get the "system-id" from a SEC_SQL object instead of API calls. So I am trying something like this, with bind parameters from a vara having a serial number as key, and host-name as value1
{VARA.TARGET_SERVERS, 1, 1}
{VARA.TARGET_SERVERS, 2, 1}
{VARA.TARGET_SERVERS, 3, 1} etc

SELECT convert(nvarchar(450), cast(uuid as uniqueidentifier)) as uuid, label 
FROM   dbo.discovered_hardware 
WHERE label in (?,?,?)

If I modified the query to take a max of 20 names at a time, is there a way I can bind values 1-20 from vara, then use 21-40 and so on, until I exhaust the list of entries?

Outcomes