Systems Management Question

Report for full SQL Server installs

06/20/2017 834 views
Has anyone come up with a reliable method to report on just full SQL Server Installs in K1000?  I want to suppress the inclusion of Compact, Express, Management Studio, just  and just get the list of servers that have a full install on them.  I see the articles from 2012 in ITNinja, I tried them but they don't exclude the false positives. 

Is there an attribute to query that is absolutely unique to a full SQL server install (SQL Server 2000 up through  SQL Server 2016)?         

0 Comments   [ + ] Show comments


Be the first to answer this question

This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ