We need to find how many installations of SQL Servers we have in the organization.
I have created a query to find the following:
Computer.Software.Add or remove Programs.Program.Name = Microsoft SQL Server 2000 or 2005 or 2008
Query returns all server have these installations but on many of them, there is no SQL Management studio installed but only the SQL tools.
For example, attached is a screenshot of a server that has only the SQL Server configuration manager installed but in the Add remove programs, the SQL Server 2008 R2 seems to be installed.
Is there any way to find what we want?
It is for licensing purposes in order to specify if there is need to purchace more SQL licenses.
Thanks in advance,
SQLserver.PNG 39.8 K