Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Acessing database

contracer

Is there any way to issue a select command and store data in a file ?

I need get this data and create a chart.

Thanks

Find more posts tagged with

Accepted answers

All comments

FormerMember

There sure is, but a lot of different ways to get there.

I use the following command, run from a command line to get a list of Windows servers. This is run on a server which has SQL.

sqlcmd -S <ServerNameGoesHere> -E -d netperfmon -W -h -1 -o <YourOutputFileNameHere> -Q "select caption from nodes where vendor like 'windows' order by caption"

Customize the query as needed. If you need more let me know.

contracer

Thanks.

I need issue this command from a server that doesn´t sql installed ( sql stays in a remote server).

Is there any free tool that I could use to issue this command ?