Searching on the service name will eliminate all of those tools only installs...
This will give you a list of all servers that have SQL Server installed. SELECT DISTINCT cs.Name0 As CompurerName, os.Caption0 FROM v_GS_COMPUTER_SYSTEM cs INNER JOIN v_GS_SERVICE s ON s.ResourceID = cs.ResourceID INNER JOIN v_GS_OPERATING_SYSTEM os ON os.ResourceID = cs.ResourceID WHERE S.Name0 LIKE 'MSSQL%' AND os.Caption0 LIKE '%SERVER%' To get specific versions, that other link posted is a better option. From: [email protected] [mailto:[email protected]] On Behalf Of Michael Mott Sent: Thursday, May 23, 2013 8:24 AM To: [email protected] Subject: [mssms] RE: Detecting SQL in CM I'm looking for a pretty comprehensive sql ties to arp proper detection and such. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Michael Mott Sent: Thursday, May 23, 2013 10:19 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Detecting SQL in CM Looking for a more accurate, as that may show just the tools installed but no sql actually installed. Does that make sense? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Thursday, May 23, 2013 9:58 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Detecting SQL in CM What are you looking for here? You could find SQL Server instances by searching on the service name LIKE MSSQL%. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Michael Mott Sent: Thursday, May 23, 2013 6:23 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Detecting SQL in CM Guys, any good blog posts on sql installation detections thru SCCM\CM, even if it's just SQL queries themselves? Michael Mott | Solutions Engineer - MI and OH 1E | Empowering Efficient IT Mobile: 734-790-6643 [email protected]<mailto:[email protected]> | www.1e.com<http://www.1e.com/> Facebook<http://www.facebook.com/1eglobal> | Twitter<https://twitter.com/1e_global/> | YouTube<http://www.youtube.com/1enews> | Blogs<http://blogs.1e.com/> | RSS<http://blogs.1e.com/index.php/feed/> Please consider the environment before printing this e-mail ________________________________ DISCLAIMER: This is a PRIVATE AND CONFIDENTIAL message for the ordinary user of this email address. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind 1E to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
