SOLVED SCCM Collection to list computers installed with teamviewer

[syed sameer]

hi Prajwal

how should I create collection of PC's having TeamViewer software

 

[Ashish]

Dear Syed,
You can create a query based collection and use the below query and it should do the job (I used it myself as I had exactly same requirements like yours)
Do let me know if this helped answer your question.Thanks

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_Systeminner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "TeamViewer%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Team%"

 

[syed sameer]

thanks prajwal

 

[Prajwal Desai]

Marking this thread as Solved.