WQL query

[nazimb]

Hello,

 

I'm running the query below to pull all the Google Chrome versions installed on our workstations, however i'm getting duplicates results as some workstations have 2 file versions .

I was trying to filter the result by MAX SMS_G_System_SoftwareFile.ModifiedDate and Group by SMS_R_System.Nam, however the MAX function doesn`t work in WQL.

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileVersion, SMS_G_System_SoftwareFile.ModifiedDate
 from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId 
where SMS_G_System_SoftwareFile.FileName = "Chrome.exe"

Any idea how to display the max date ?

 

Thanks,

[GarthMJ]

You can't. I'm not sure why you would want too either using WQL.