Kaseya Community

Kaseya view to show SQL std, but not SQL express servers?

This question is not answered

Hi, anyone know how to seperate these via a Kaseya view?

All Replies
  • no one have any ideas??

  • It's not something I've tried to work out but if you can cross reference a machine that has the two flavours of SQL then look for a difference in files or registry entries. Then create a custom field and update that field based on whether it finds the files you determined were different.

  • There isn't going to be a "silver bullet" solution for this, but perhaps somebody else out there is more creative than me.

    We could ask SQL (via sqlcmd.exe) with the query: Select @@version (check for "Express")

    There are more things to consider though such as SQL version and whether or not there are instances (can be plural) running.