topic Re: Get list of DNS data source name in Discussions

Get list of DNS data source name

Jackie_ — Fri, 15 Sep 2023 18:44:28 GMT

Hello,

Is there a way to get the list of the DNS data source using JSL?

jthi — Fri, 15 Sep 2023 19:23:52 GMT

You could use Run Program(), call powershell, use command Get-OdbcDsn and parse from the return

Jackie_ — Fri, 15 Sep 2023 19:45:19 GMT

@jthi Thanks Jarmo!

I haven't used Run Program before. Mind sharing a reference code to save the DNS in the lists?

jthi — Fri, 15 Sep 2023 19:52:30 GMT

Scripting Index and JMP Help page I did link should get you there

Names Default To Here(1);

rp = Run Program(
	Executable("powershell.exe"),
	Options({"Get-OdbcDsn"}),
	ReadFunction("text")
);

Jackie_ — Sun, 17 Sep 2023 13:33:45 GMT

Appreciate it