Performs a lookup against a SQL Server database server.
1.SQLLookup - Name of the Macro.
2.Connection String - The SQL Server connection string to open a connection against.
3.Query - The Transact-SQL query to execute.
[SQLLookup|Data Source=DEVELOPMENT;Initial Catalog=TEST;User ID=transfer;Password=P@ssw0rd;|SELECT TOP 1 MachineName FROM dbo.Agent]
Opens a connection against a server named DEVELOPMENT as the transfer user and queries an Agent table in the TEST database for a machine name.
If multiple matches are found the value returned is the first column of the first row. All other results are ignored.
Copyright © 2022 pasUNITY, Inc.
Send comments on this topic.