locked
SCCM for client that only have SQL management studio installed and for client that have the full version of SQL server installs RRS feed

  • Question

  • Hi All,

    I am currently performing a software audit for licence purposes can you please advise how I can Query SCCM for client that only have SQL management studio installed and for client that have the full version of SQL server installs thanks

    Thursday, December 5, 2013 10:58 AM

All replies

  • Hi,

    It seems the SQL Management Studio does not have a separate name in WIN32REG_addRemovePrograms. If so, it cannot be querid out separately.

    I suggest you create a DCM to detect the file smss.exe under SQL installation path and the clients donot have other components installed. This may find out the clients that have only SQL Management Studio installed.


    Juke Chou

    TechNet Community Support

    Tuesday, January 21, 2014 2:59 AM