SQL :
Select Distinct
Count(SoftwareFile.FileName) as 'Total Count:'
From System_Disc
Join vSms_G_System_SoftwareFile as SoftwareFile
On SoftwareFile.ClientId = System_Disc.ItemKey
Where SoftwareFile.FileName = 'WinWord.Exe'
And SoftwareFile.FileVersion = '14'
Select Distinct
Count(SoftwareFile.FileName) as 'Total Count:'
From System_Disc
Join vSms_G_System_SoftwareFile as SoftwareFile
On SoftwareFile.ClientId = System_Disc.ItemKey
Where SoftwareFile.FileName = 'WinWord.Exe'
And SoftwareFile.FileVersion = '14'
Thank you very much for keep this information. free word counter
ReplyDelete