cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Get list of DNS data source name

Jackie_
Level VI

Hello,

 

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

 

Jackie__0-1694803457276.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User


Re: Get list of DNS data source name

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")
);
-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User


Re: Get list of DNS data source name

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

-Jarmo
Jackie_
Level VI


Re: Get list of DNS data source name

@jthi Thanks Jarmo!

 

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

jthi
Super User


Re: Get list of DNS data source name

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")
);
-Jarmo
Jackie_
Level VI


Re: Get list of DNS data source name

Appreciate it