Query sql servers version

(imported topic written by ygarti91)

hi everyone iam looking for a relvance to query all the version of my sql server in my organization

like 2005 enterprise 9.00.3042

i need to find all the sql server in my organization

and i dont find any in the bes console

thanks

(imported comment written by SystemAdmin)

Hi ygarti,

The Tivoli Endpoint Manager for Lifecycle package and the Tivoli Endpoint Manager for Software Use Analysis product include an analysis called “Microsoft SQL Server and Client Tools Version Detection.” The data from this analysis can flow into the Software Use Analysis reports to give you various rollup reports with filtering and sorting.

The analysis reports the following:

Installed SQL Server 7.0 instances (including MSDE), versions, and service pack levels, if applicable

Full name of installed SQL Server 2000 instances (including MSDE), versions, and service pack levels, if applicable

Full name of installed SQL Server 2005 instances (including Express), versions, and service pack levels, if applicable

Full name of installed SQL Server 2008 instances (including Express), versions, and service pack levels, if applicable

Core Processor Count

Physical Processor Count

Installed SQL Server 7.0 Client Tools version, if applicable

Installed SQL Server 2000 Client Tools version, if applicable

Installed SQL Server 2005 Client Tools versions, if applicable

Installed SQL Server 2008 Client Tools versions, if applicable

All SQL Server, Analysis Services, and Reporting Services instance names and versions, if applicable

Here’s how it looks in TEM SUA:

https://sn2files.storage.live.com/y1p3x7WpesWu_9Q_7r9_nRfkTS4fUWRlNu580TErn3Jd1OE9rCcw2uykEhj2y5Wf9Ay9HjrzlL11aYfjEDIytY2dA/SQL_Server_Editions_Report-1.jpg?psid=1

– Jeff

(imported comment written by ygarti91)

this is exactly what i need how can i do this ?

(imported comment written by NoahSalzman)

Does your company own the Software Use Analysis add-on to TEM/BigFix? It used to be called DSS SAM (Software Asset Management).

http://www-01.ibm.com/software/tivoli/products/endpoint-software-use-analysis/