select sys.Name0 , v_Add_Remove_Programs.DisplayName0,
v_Add_Remove_Programs.Version0, OPSYS.Caption0 as [Sistema Operativo],
case when pr.addresswidth0 = 64 then 'Windows 64bits'
when pr.addresswidth0=32 then 'Windows 32bits'
end as [Tipo de sistema operativo],
case when pr.addresswidth0=32 and pr.DataWidth0=64 then 'Si'
end as [Windows 32-bit en maquina x64]
from v_R_System sys
join v_Add_Remove_Programs
on sys.ResourceID = v_Add_Remove_Programs.ResourceID
join v_gs_processor pr
on sys.resourceid=pr.resourceid
join dbo.v_GS_OPERATING_SYSTEM OPSYS
on sys.resourceid=opsys.resourceid
where
v_Add_Remove_Programs.DisplayName0
like '%software buscado%'
Query para ver si un software instalado ha sido reportado a SCCM
Started by Alberto Dominguez, feb 06 2013 12:04
No replies to this topic
#1
Escrito 06 febrero 2013 - 12:04
Dejo código:
Saludos,
Alberto Dominguez
Enterprise Architect y Trainer
MCT, MCPD, MCITP, MCITP Dynamics, MCSE, MCSA, MCTS, MCP...
ITIL V3 Foundation Qualification in IT Service Management
Perfil Profesional Twitter
Alberto Dominguez
Enterprise Architect y Trainer
MCT, MCPD, MCITP, MCITP Dynamics, MCSE, MCSA, MCTS, MCP...
ITIL V3 Foundation Qualification in IT Service Management
Perfil Profesional Twitter
#2
Escrito 01 agosto 2017 - 10:51
BitLord.com
43. Lorde - Pure Heroine (Extended)
2016muhmmad Tahir Adri Mp3 Songs Pk Mp3
Download
101 - 150
L'Amant double 1080p TrueFrench Film Torrent complet en francais
fuad ektai tumi amar mp3
Needless
Downsizing (2018)
Tape 407 (Area 407)
Gintama Season 5 (Gintama 2011) Episode 18
Saichia Wongwirot
Ranking de mejores Conferencias
Digimon (2) Zero Two
Papinka - Dimana Hatimu (Lirik).mp4
Pietno gangu
Hegre 17 07 25 Ariel And Mike Nude Photo Workshop XXX 1080p MP4-KTR[rarbg]
1. Sezon
Season 4 Episode 11 TBA
Magda Szubanski
Basic Cantonese_A Grammar and Workbook pdf
43. Lorde - Pure Heroine (Extended)
2016muhmmad Tahir Adri Mp3 Songs Pk Mp3
Download
101 - 150
L'Amant double 1080p TrueFrench Film Torrent complet en francais
fuad ektai tumi amar mp3
Needless
Downsizing (2018)
Tape 407 (Area 407)
Gintama Season 5 (Gintama 2011) Episode 18
Saichia Wongwirot
Ranking de mejores Conferencias
Digimon (2) Zero Two
Papinka - Dimana Hatimu (Lirik).mp4
Pietno gangu
Hegre 17 07 25 Ariel And Mike Nude Photo Workshop XXX 1080p MP4-KTR[rarbg]
1. Sezon
Season 4 Episode 11 TBA
Magda Szubanski
Basic Cantonese_A Grammar and Workbook pdf
0 usuarios están leyendo este tema
0 miembro/s, 0 invitado/s, 0 usuario/s anónimo/s