SCCM SQL Query : Find Lync Versions



select  distinct v_R_System.User_Name0,v_r_system.Name0,v_R_System.Active0,v_Add_Remove_Programs.DisplayName0,v_Add_Remove_Programs.TimeStamp,v_Add_Remove_Programs.InstallDate0,v_Add_Remove_Programs.Version0
from v_Add_Remove_Programs
inner join v_R_System on v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID
where v_Add_Remove_Programs.DisplayName0 like 'Microsoft Lync 2010'



Comments

Popular posts from this blog