Thank you for your help! It's close but not quite right. The MNE's are skewing the results which I should have mentioned. There may be multiple MNE's per server and I want to only count one .NET version per server. I know it should be simple to calculate but struggling on how to do it.
In your first query you want to calculate each server name in each LOB. Now, you want to calculate only one .Net version per server. I am sorry but I am not very clear with your requirement. Please attach screen shot of your requirement or elaborate it in a clear way.