can any one tell how to generate report of computers with SFB installed. I don't see SFB in add or remove programs. How to get the

When you install it what is listed in ARP for it?

It doesn't show up anything in ARP related to SFB.

as per the community link - http://community.skype.com/t5/Windows-desktop-client/Completely-Uninstall-Skype-For-Business/td-p/3961381

Skype for business was Lync/is an update to Lync which is part of Microsoft Office.  Due to this the naming conventions of the software install/uninstall may say "Skype for Business" or "Lync".I have a big headache on how to find the computers with/without SFB installed. I need a SQL query and the app is not seen in ARP.

as per the community link - http://community.skype.com/t5/Windows-desktop-client/Completely-Uninstall-Skype-For-Business/td-p/3961381

Skype for business was Lync/is an update to Lync which is part of Microsoft Office.  Due to this the naming conventions of the software install/uninstall may say "Skype for Business" or "Lync".I have a big headache on how to find the computers with/without SFB installed. I need a SQL query and the app is not seen in ARP.

So what you are saying is that is does in fact show up in ARP as either Lync or SFB. As such why can't you then query for either software title and get a list of who has it?

@Garth - There is an entry of Lync 2013 in the add or remove programs. SFB sits on the top of Lync 2013. I can easily list the computers with Lync 2013 installed, but what I want is to list the computers that has got SFB installed. Lync 2013 installed doesn't mean SFB is also installed ?. You got what I am trying to say here ?

how are you deploying this skype for business ? via software updates if so,use the reports for compliance how many are installed and how many are not. If you are using the application deployment/legacy method,still get this from reports. If this patch not available in ARP,you must use Compliance (DCM) to check the patch (easiest method i would see on this) instead of enabling Win32_QuickFixEngineering. more via  https://t3chn1ck.wordpress.com/2010/10/20/sccm-dcm-inventory-for-installed-windows-hotfixes/

Why can't you do something like this?

select 
	* 
from 
	dbo.v_Add_Remove_Programs ARP
Where
	(
		ARP.DisplayName0 like '%Lync%'
		and ARP.ResourceID in 
		(
			Select 
				ARP.ResourceID 
			from 
				dbo.v_Add_Remove_Programs ARP
			Where 
				ARP.displayname0 like 'Update for Skype for Business 2015 (KB2889853)%')
	)