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
Store

Anyway to pull the version of SQL from SQL servers.

Those upstairs have asked for a count on our environment. I have managed to pull the data from operating systems, but I am wondering if there's a script or a report that I can find that will give me the version/revision number for SQL.

Find more posts tagged with

Accepted answers

All comments

hpstech

Download the MAP tool from Microsoft and run a scan.

https://www.microsoft.com/en-us/download/details.aspx?id=7826

mesverrum

If they have appinsight on them this will get them

SELECT Name, NodeID, Availability, LastTimeUp, TimeStamp, TemplateDescription, InstanceName, ProductVersion, ProductLevel, Edition

FROM Orion.APM.SqlServerApplicationAlert