SCCM 2007 Syntax error
Can seem to fix the below query. returns with syntax error select distinct sys.Name, SMS_G_System_SYSTEM.ResourceID, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from SMS_G_System_SoftwareProduct as prod inner join SMS_R_System as sys on sys.ResourceId = prod.ResourceID inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = sys.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = sys.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "j2se%
October 11th, 2012 2:35pm

You forgot the ending " try this: select distinct sys.Name, SMS_G_System_SYSTEM.ResourceID, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from SMS_G_System_SoftwareProduct as prod inner join SMS_R_System as sys on sys.ResourceId = prod.ResourceID inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = sys.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = sys.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "j2se%" Justin Chalfant | Blog: setupconfigmgr.com | SCUP Catalog: patchmypc.net/scup | Please mark as helpful/answer if this resovled your issue
Free Windows Admin Tool Kit Click here and download it now
October 11th, 2012 3:29pm

Also keep in mind that this will only find 32bit j2se. http://www.enhansoft.com/
October 11th, 2012 4:20pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics