Finding Queries by SFTP Export Server

Need to query for queries that export to a particular server? In this example, 34.200.21.44 is the server IP we’re searching for.

Create a query on the CJ > Related > Query base, then add a Formula subquery filter:

q__JID_.config.value('(p[k = "export_server"]/v)[1]', 'varchar(500)') LIKE '%34.200.21.44%'

This example can be adapted to search for other parts of the connection string, such as username.