SQL :
Select
Count(SD.Name0) Counts,
PF.DisplayName0,
PF.Version0
From v_Add_Remove_Programs PF
Join v_R_System SD on PF.ResourceID = SD.ResourceID
Where PF.DisplayName0 = 'McAfee VirusScan Enterprise'
Group By PF.DisplayName0, PF.Version0
Order By Counts, PF.Version0
Select
Count(SD.Name0) Counts,
PF.DisplayName0,
PF.Version0
From v_Add_Remove_Programs PF
Join v_R_System SD on PF.ResourceID = SD.ResourceID
Where PF.DisplayName0 = 'McAfee VirusScan Enterprise'
Group By PF.DisplayName0, PF.Version0
Order By Counts, PF.Version0
No comments:
Post a Comment