1
0
Dentro mis inicios en la informática mi caballo de batalla fue SCCM, por lo cual es un agrado compartir información con respecto a esta tecnología.
Unos de los mayores problemas fue obtener las versiones de Office instalado dentro de la Organización, una solución muy sencilla es hacerlo a través de Query.
Comparto la siguiente Query que le puede ser muy útil.
(select
rs.Netbios_Name0,
rs.User_Name0,
GS.UserName0,
ADX86.Publisher0,
adx86.DisplayName0,
ADX86.Version0,
WS.LastHWScan
from
v_R_System rs
inner join v_GS_COMPUTER_SYSTEM GS on GS.ResourceID = rs.ResourceID
inner join v_GS_ADD_REMOVE_PROGRAMS ADX86 on ADX86.ResourceID = rs.ResourceID
inner join v_GS_WORKSTATION_STATUS WS ON WS.ResourceID= RS.ResourceID
where
adx86.DisplayName0 in (‘Microsoft Office Professional Plus 2010’,
‘Microsoft Office Professional Plus 2013’,
‘Microsoft Office Hogar y Empresas 2016 – es-es’,
‘Microsoft Office Hogar y Empresas 2013 – es-es’,
‘Microsoft Office 365 ProPlus – es-es’,
‘Microsoft Office Professional Edition 2003’,
‘Microsoft Office Standard 2007’,
‘Microsoft Office Professional Plus 2007’,
‘Microsoft Office 97 Professional’,
‘Microsoft Office Enterprise 2007’,
‘Microsoft Office 365 – es-es’,
‘Microsoft Office 365 ProPlus – en-us’,
‘Microsoft Office Standard 2010’,
‘Microsoft Office XP Professional’,
‘Microsoft Office Professional Plus 2016’,
‘Microsoft Office 365 Business – es-es’,
‘Microsoft Office Standard 2013’
))
union
(select
rs.Netbios_Name0,
rs.User_Name0,
GS.UserName0,
ADX64.Publisher0,
ADX64.DisplayName0,
ADX64.Version0,
WS.LastHWScan
from
v_R_System rs
inner join v_GS_COMPUTER_SYSTEM GS on GS.ResourceID = rs.ResourceID
inner join v_GS_ADD_REMOVE_PROGRAMS_64 ADX64 on ADX64.ResourceID = rs.ResourceID
inner join v_GS_WORKSTATION_STATUS WS ON WS.ResourceID= RS.ResourceID
where
ADX64.DisplayName0 in (‘Microsoft Office Professional Plus 2010’,
‘Microsoft Office Professional Plus 2013’,
‘Microsoft Office Hogar y Empresas 2016 – es-es’,
‘Microsoft Office Hogar y Empresas 2013 – es-es’,
‘Microsoft Office 365 ProPlus – es-es’,
‘Microsoft Office Professional Edition 2003’,
‘Microsoft Office Standard 2007’,
‘Microsoft Office Professional Plus 2007’,
‘Microsoft Office 97 Professional’,
‘Microsoft Office Enterprise 2007’,
‘Microsoft Office 365 – es-es’,
‘Microsoft Office 365 ProPlus – en-us’,
‘Microsoft Office Standard 2010’,
‘Microsoft Office XP Professional’,
‘Microsoft Office Professional Plus 2016’,
‘Microsoft Office 365 Business – es-es’,
‘Microsoft Office Standard 2013’
))
