suggestion for a specific query

[maffef]

Hi

 

I created this query

-----------------------------------------------------------------------------------------

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_System inner 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 5 Host%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version not like "5.1.9220" and SMS_R_System.OperatingSystemNameandVersion != "Microsoft Windows NT Workstation 6.1" and SMS_R_System.ResourceDomainORWorkgroup = "MB_AU" or SMS_R_System.ResourceDomainORWorkgroup = "mb_sg" or SMS_R_System.ResourceDomainORWorkgroup = "mb_jp"

--------------------------------------------------------------------------------------------

 

The result should also given me computers without winversion 6.1 but it still shows computers with 6.1.

Already done Update Collection Ship but not the result which I want.

[wmmayms]

Hi

 

I created this query

-----------------------------------------------------------------------------------------

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_System inner 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 5 Host%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version not like "5.1.9220" and SMS_R_System.OperatingSystemNameandVersion != "Microsoft Windows NT Workstation 6.1" and SMS_R_System.ResourceDomainORWorkgroup = "MB_AU" or SMS_R_System.ResourceDomainORWorkgroup = "mb_sg" or SMS_R_System.ResourceDomainORWorkgroup = "mb_jp"

--------------------------------------------------------------------------------------------

 

The result should also given me computers without winversion 6.1 but it still shows computers with 6.1.

Already done Update Collection Ship but not the result which I want.

 

U cannot use NOT LIKE in that way.

 

If you gonan create such a query you need to use a subselect.

[maffef]

U cannot use NOT LIKE in that way.

 

If you gonan create such a query you need to use a subselect.

 

 

 

Can you show me how?

[Eswar Koneti]

Can you show me how?

 

refer this blog http://verbalprocessor.com/2010/01/30/better-subselect-queries/ to know more about subselected quiries.