naxbikes.blogg.se

However, when I run the statement but substituting microsoft for adobe, nothing returns.

This statement does work and returns output displaying all the machines with office 2007. Select distinct SMS_R_System.Name 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 ="microsoft I have a query statement below that works fine for querying microsoft office enterprise 2007. I'm trying to query all workstations in my domain that have adobe acrobat x pro installed on them using sms 2007.