(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:
– 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/