RL008 Posted May 10, 2010 Share Posted May 10, 2010 I am trying to get all SQL server in my work network. I kow how to do it in windows : SQLCMD -L > c:\servers_filename.txt Is there a way to do it in Autoit directly? thanks Link to comment Share on other sites More sharing options...
water Posted May 10, 2010 Share Posted May 10, 2010 (edited) I am trying to get all SQL server in my work network. I kow how to do it in windows : SQLCMD -L > c:\servers_filename.txt Is there a way to do it in Autoit directly? thanks You could use "Run" with flag $STDOUT_CHILD to get the output of SQLCMD into AutoIt Or you could run an LDAP command against the Active Directory to query for "(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*))" Edited May 10, 2010 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
RL008 Posted May 10, 2010 Author Share Posted May 10, 2010 You could use "Run" with flag $STDOUT_CHILD to get the output of SQLCMD into AutoItOr you could run an LDAP command against the Active Directory to query for "(&(objectCategory=computer)(servicePrincipalName=MSSQLSvc*))"can you please give an example of "Run" command and I/O ? Link to comment Share on other sites More sharing options...
water Posted May 10, 2010 Share Posted May 10, 2010 can you please give an example of "Run" command and I/O ?A running example can be found in the help file for the command "StdoutRead" My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
RL008 Posted May 10, 2010 Author Share Posted May 10, 2010 A running example can be found in the help file for the command "StdoutRead"thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now