Início > SCCM > Query Internet Explorer

Query Internet Explorer

Pessoal recentemente precisei atualizar todos I.E da empresa aonde estou alocado, segue a query que utilizei para identificar as versões do I.E.

I.E 6
 
select distinct SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_R_System.AgentTime from  SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\Arquivos%" and SMS_G_System_SoftwareFile.FileVersion like "%6.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" or SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\program files%" and SMS_G_System_SoftwareFile.FileVersion like "%6.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" order by SMS_R_System.NetbiosName
 
I.E 7
 
select distinct SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_R_System.AgentTime from  SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\Arquivos%" and SMS_G_System_SoftwareFile.FileVersion like "%7.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" or SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\program files%" and SMS_G_System_SoftwareFile.FileVersion like "%7.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" order by SMS_R_System.NetbiosName
 
I.E 8
 
select distinct SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_R_System.AgentTime from  SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\Arquivos%" and SMS_G_System_SoftwareFile.FileVersion like "%8.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" or SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\program files%" and SMS_G_System_SoftwareFile.FileVersion like "%8.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" order by SMS_R_System.NetbiosName
 
I.E 9
 
select distinct SMS_R_System.NetbiosName, SMS_G_System_SoftwareFile.FileVersion, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_R_System.AgentTime from  SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\Arquivos%" and SMS_G_System_SoftwareFile.FileVersion like "%9.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" or SMS_G_System_SoftwareFile.FileName = "iexplore.exe" and SMS_G_System_SoftwareFile.FilePath like "%:\\program files%" and SMS_G_System_SoftwareFile.FileVersion like "%9.%" and SMS_G_System_SoftwareFile.FileVersion not like "%ganeshs%" order by SMS_R_System.NetbiosName

Obrigado pela leitura e até a próxima publicação,

Abraços.

Nielsen Almeida

Categorias:SCCM
  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão /  Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão /  Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão /  Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão /  Alterar )

Connecting to %s

%d bloggers like this: