January 31, 2012 at 5:08 am
Hi,
i need a list of SQL seerver version and edition and i can't find such a table on SCCM. i specifically need the table which has information about SQL editions, eg Enterprise or Standard, etc.
Anyone knows which tables on SCCM i can check?
i have already tried checking the Add remove programs tables.
January 31, 2012 at 5:56 am
What is SCCM?
Here you can find info on the different SQL Server 2008R2 editions:
http://www.microsoft.com/sqlserver/en/us/editions.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 6:00 am
SCCM is system center configuration manager, it's a MS product for remote software installation.
It keeps record of all systems with registered software. it's database resides on SQL Server but now the database is not of use to me because i cannot get what i want out.
To cut the long story, i need a script to connect to different SQL server instances so that i can collect information about the version of SQL and editions since SCCM cant give me such info.
January 31, 2012 at 6:02 am
Ah ok, that makes more sense 🙂
This KB has a few scripts that let you determine version numbers and edition of a SQL Server instance:
How to determine the version and edition of SQL Server and its components
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 6:05 am
Thanks Koen Verbeeck, i am just having a bad day in the office.
The SCCM guys here don't even want to participate in helping out the brother.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply