matt1138 Posted January 14, 2014 Report post Posted January 14, 2014 Hi all, I'm running into an issue creating a device collection for my SQL servers. I've seen some suggestions at creating the query where the criteria is Installed Applications.Display Name is like "%SQL Server%". That query works and returns all of my SQL servers but it is also returning any machine that has the SQL Server Native Client on it. Anyone have any suggestions as to how to limit the query any further? Thanks for the help. Quote Share this post Link to post Share on other sites More sharing options...
Morpheus Posted January 14, 2014 Report post Posted January 14, 2014 If it's just the native client try to exclude it Quote Share this post Link to post Share on other sites More sharing options...
matt1138 Posted January 14, 2014 Report post Posted January 14, 2014 I would but the SQL Servers all have the Native Client installed as well. If I exclude all that have the Native client installed, it will remove the actual SQL servers as well, right? Quote Share this post Link to post Share on other sites More sharing options...
matt1138 Posted January 14, 2014 Report post Posted January 14, 2014 Derp! I just added in a criteria for Services.Display Name is like "%SQL Server%" and it started working like I wanted it to. Any machine with just the Native Client should not have a service installed with the SQL Server name as well. Quote Share this post Link to post Share on other sites More sharing options...
