Hi, anyone know how to seperate these via a Kaseya view?
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.