Select distinct Mon2.ManagementPackName,Mon2.MonitorName,Mon2.DisplayName AS MonitorDisplayName,
Mon2.AlertMessage AS [Nombre Alerta],Texto3.LTValue AS Clase,Mon2.AlertSeverity AS Severidad from
(Select distinct Mon.ManagementPackName,Mon.MonitorName,Texto2.LTValue AS DisplayName,
Mon.AlertMessage,Mon.AlertSeverity,Mon.ClaseId from
(select distinct Man.MPName AS ManagementPackName,Monitor.MonitorName,Monitor.MonitorId,
Texto1.LTValue AS AlertMessage,Monitor.TargetManagedEntityType AS ClaseId,
AlertSeverity=
CASE Monitor.AlertSeverity
WHEN '1' THEN 'Warning'
WHEN '2' THEN 'Critical'
WHEN '3' THEN 'Monitor State'
END
from dbo.Monitor AS Monitor
Inner Join dbo.LocalizedText AS Texto1
On Monitor.AlertMessage=Texto1.LTStringID
inner Join dbo.managementpack AS Man
On Monitor.ManagementPackId=Man.ManagementPackId
where Monitor.AlertMessage IS NOT NULL
AND
Texto1.LTSTringType=1 AND Texto1.LanguageCode='ENU') Mon
inner join dbo.LocalizedText AS Texto2
On Mon.MonitorId=Texto2.LTStringID
where Texto2.LTSTringType=1 AND Texto2.LanguageCode='ENU') Mon2
inner join dbo.LocalizedText AS Texto3
On Mon2.ClaseId=Texto3.LTStringID
where Texto3.LTSTringType=1 AND Texto3.LanguageCode='ENU'
Order By MonitorName
Query para Obtener Mensaje de Alerta de Monitores
Started by Alberto Dominguez, jun 07 2013 10:30
No replies to this topic
#1
Escrito 07 junio 2013 - 10:30
Query que nos devuelve información de Monitores (Management Pack, Monitor, Monitor DisplayName, Nombre Alerta, Clase y Severidad):
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 10 julio 2017 - 00:30
Creative Design Engineering pdf
Hanayamata
Chips 2017 1080p BRRIP x264 (mkvtv net) mkv
Killjoys (season 2)
The Wall US S02E05 720p HDTV x264-W4F [eztv]
Masters of Sex saison 3 episode 6
Die Scharfschutzen
Isunshare
Contact Us
Dollhouse
Comments: 0
October 2016
Laia Costa
Candice Renoir
Undefeated Bahamut Chronicle
Скачать
Ver Jesse Stone: Lost in Paradise (2015) Online
Daniel Bruhl
Season 5 Episode 10 First Contact (1)
Hanayamata
Chips 2017 1080p BRRIP x264 (mkvtv net) mkv
Killjoys (season 2)
The Wall US S02E05 720p HDTV x264-W4F [eztv]
Masters of Sex saison 3 episode 6
Die Scharfschutzen
Isunshare
Contact Us
Dollhouse
Comments: 0
October 2016
Laia Costa
Candice Renoir
Undefeated Bahamut Chronicle
Скачать
Ver Jesse Stone: Lost in Paradise (2015) Online
Daniel Bruhl
Season 5 Episode 10 First Contact (1)
#3
Escrito 10 julio 2017 - 01:56
Noblesse: The Beginning of Destruction Episode 01
Season 1 Episode 4 Nolite Te Bastardes Carborundorum
Season 1 Episode 3 Bow Down to Your Mother
Ben 10: Ultimate Alien Cosmic Destruction (PS2) 2010
Supergirl sezonul 2 episodul 18
Critical Role
Teddy Go!
Wetsuit Lyrics Mp3
Vixen: The Movie
Esperanza Mia
malwarebytes anti-malware premium lifetime license
Prevenge (2016)
Watch Ballet 422 Online
Band Of Brothers
La guerra del Planeta de los Simios (2017) espaГ±ol megashare libre
Slovakian
Dj Khaled Feat. Drake - "To The Max" | Phil Wright Choreography | Ig: @phil_wright_
3 Idiots 2009 HD ????? ????? 8.4
Galaxy Rangers
Indonesian ?????????Suspicious.Partner?E07+E08????
백마 н† л ЊнЉё
Glory Road 2006 1080p BluRay x264-HDMI
game of thrones
Justified 56
MP3/Video
Season 1 Episode 4 Nolite Te Bastardes Carborundorum
Season 1 Episode 3 Bow Down to Your Mother
Ben 10: Ultimate Alien Cosmic Destruction (PS2) 2010
Supergirl sezonul 2 episodul 18
Critical Role
Teddy Go!
Wetsuit Lyrics Mp3
Vixen: The Movie
Esperanza Mia
malwarebytes anti-malware premium lifetime license
Prevenge (2016)
Watch Ballet 422 Online
Band Of Brothers
La guerra del Planeta de los Simios (2017) espaГ±ol megashare libre
Slovakian
Dj Khaled Feat. Drake - "To The Max" | Phil Wright Choreography | Ig: @phil_wright_
3 Idiots 2009 HD ????? ????? 8.4
Galaxy Rangers
Indonesian ?????????Suspicious.Partner?E07+E08????
백마 н† л ЊнЉё
Glory Road 2006 1080p BluRay x264-HDMI
game of thrones
Justified 56
MP3/Video
#4
Escrito 17 julio 2017 - 22:49
Khun Samee Karmalor Tee Rak
Whirly Girly season 05 episode 02
The Workplace season 07 episode 05
Видео
Read more
Regarder
Hai Hassi Ban Gae Mp3
Episode 03 - Walk of Punishment
Vidzi.tv
VidLox VF Dvdrip
lirik lagu geisha
3.Sam Hunt - Body Like A Back Road
Allegiant 2016 HD
http://jobngon.com/a...8-1-4-0-crack/'>13/07/2017
Previous Post Previous post: Dave Grohl-Overture-SINGLE-WEB-2016-ENTiTLED
92. Ed Sheeran
A Meia-Noite (1964)
Previous Episode
TV Shows Series
Download
Семейный
TOP 50 Monthly torrents in this category
15:20 watch on Movdivx
Openload.co
Whirly Girly season 05 episode 02
The Workplace season 07 episode 05
Видео
Read more
Regarder
Hai Hassi Ban Gae Mp3
Episode 03 - Walk of Punishment
Vidzi.tv
VidLox VF Dvdrip
lirik lagu geisha
3.Sam Hunt - Body Like A Back Road
Allegiant 2016 HD
http://jobngon.com/a...8-1-4-0-crack/'>13/07/2017
Previous Post Previous post: Dave Grohl-Overture-SINGLE-WEB-2016-ENTiTLED
92. Ed Sheeran
A Meia-Noite (1964)
Previous Episode
TV Shows Series
Download
Семейный
TOP 50 Monthly torrents in this category
15:20 watch on Movdivx
Openload.co
#5
Escrito 17 julio 2017 - 22:54
Whatsapp Funny Videos
Es por tu bien BluRay 1080p
Niall Horan - Slow Hands (Acoustic)
ver Aliados 2016 putlocker en linea gratis
lirik lgu direktur dalam mimpi
http://peb.pl/strzel...olfenstein.html
Passionfruit
Acapulco Shore Nueva Generacion
Die Zwei
Les Ex (2017) 1080p Telecharger
The Musketeers
Download
E10 Episode 10
За Гранью
iZombie Dizinin profil sayfas?na git.
Derniere page
VidLox VF Dvdrip
Quid Pro Quo 2008 DvDRip XviD-FileHunter
Leighton Meester
Batman: The Brave and the Bold
Post Hardcore
hobby 2000 caravan
Telecharger Sully Torrent
Brett Young - In Case You Didn't Know
Socios y sabuesos1989
PC Games
Es por tu bien BluRay 1080p
Niall Horan - Slow Hands (Acoustic)
ver Aliados 2016 putlocker en linea gratis
lirik lgu direktur dalam mimpi
http://peb.pl/strzel...olfenstein.html
Passionfruit
Acapulco Shore Nueva Generacion
Die Zwei
Les Ex (2017) 1080p Telecharger
The Musketeers
Download
E10 Episode 10
За Гранью
iZombie Dizinin profil sayfas?na git.
Derniere page
VidLox VF Dvdrip
Quid Pro Quo 2008 DvDRip XviD-FileHunter
Leighton Meester
Batman: The Brave and the Bold
Post Hardcore
hobby 2000 caravan
Telecharger Sully Torrent
Brett Young - In Case You Didn't Know
Socios y sabuesos1989
PC Games
#6
Escrito 18 julio 2017 - 14:33
Mission Pays Basque (2017)
Life (2017) 720p BluRay x264 Replica
Hladat
Mac Applications
[18+] Affair Family 2017 720p HDRip 570MB Adult Korean Movie - Biplab
Mentes Criminales 2x13
2.Sezon 7.Bolum A Man Without Honor
Version 9
Bosch sezonul 3 episodul 4
Le.Bureau.Des.Legendes.S03.FRENCH.720p.HDTV.x264-S...(A)
Legend of Gingko
more popular apps
Harry And His Bucket Full Of Dinosaurs
???????????????????????
Diziyi indir
The Sarah Jane Adventures
DOWNLOAD
Mike Hagerty
The 1975
@sar?zade
dolina_1998_lavenganza_1998-07-02 mp3
Robinson Crusoe 17 Haziran'da Gosterime Giriyor!
Peliculas De Documentales
Taboo UK
Hacksaw Ridge streaming Ce Film Hacksaw Ridge streaming L'histoire : L'Histoire de Desmond Doss, le premier objecteur de conscience a recu la Medaille d'Honneur du Congres des etats-unis. Pendant la Seconde Guerre mondiale, il est un Medecin, pour eviter d'utiliser une Arme ...la seconde guerre mondiale, l'Armee AMeRICAINE, Medic, Desmond T. Doss, qui a servi pendant la Bataille d'Okinawa, qui refuse de tuer ...
Precious Cargo (Mercancia peligrosa) (2016) Tras un golpe fallido, el ganster Eddie (Bruce Willis), comienza la busqueda de la seductora ladrona Karen (Claire Forlani), que le ha fallado. Para ganarse otra vez la confianza de Eddie, Karen recurre a su ex amante y experto ladron Jack (Mark-Paul Gosselaar).
Life (2017) 720p BluRay x264 Replica
Hladat
Mac Applications
[18+] Affair Family 2017 720p HDRip 570MB Adult Korean Movie - Biplab
Mentes Criminales 2x13
2.Sezon 7.Bolum A Man Without Honor
Version 9
Bosch sezonul 3 episodul 4
Le.Bureau.Des.Legendes.S03.FRENCH.720p.HDTV.x264-S...(A)
Legend of Gingko
more popular apps
Harry And His Bucket Full Of Dinosaurs
???????????????????????
Diziyi indir
The Sarah Jane Adventures
DOWNLOAD
Mike Hagerty
The 1975
@sar?zade
dolina_1998_lavenganza_1998-07-02 mp3
Robinson Crusoe 17 Haziran'da Gosterime Giriyor!
Peliculas De Documentales
Taboo UK
Hacksaw Ridge streaming Ce Film Hacksaw Ridge streaming L'histoire : L'Histoire de Desmond Doss, le premier objecteur de conscience a recu la Medaille d'Honneur du Congres des etats-unis. Pendant la Seconde Guerre mondiale, il est un Medecin, pour eviter d'utiliser une Arme ...la seconde guerre mondiale, l'Armee AMeRICAINE, Medic, Desmond T. Doss, qui a servi pendant la Bataille d'Okinawa, qui refuse de tuer ...
Precious Cargo (Mercancia peligrosa) (2016) Tras un golpe fallido, el ganster Eddie (Bruce Willis), comienza la busqueda de la seductora ladrona Karen (Claire Forlani), que le ha fallado. Para ganarse otra vez la confianza de Eddie, Karen recurre a su ex amante y experto ladron Jack (Mark-Paul Gosselaar).
#7
Escrito 18 julio 2017 - 14:52
Continuum
Super Army of Tentacles 3 The Search for Army of Tentacles 2-HI2U
Feuer und Blut Fire and Blood
Hopeless fountain kingdom (Deluxe) - Halsey
Callie North
Alba Allotta - Le cento migliori ricette con il marsala [Pdf - Cbr - ITA] [TNTVi...
Mixology
Haider Full Movie (2014) DVDRip Watch Online Watch Haider 2014 Hindi DVDRip Free HDTV Online Full Movie You can watch Haider 2014, Haider 2014 Full Movie, Haider Online Full Movie, Haider Hindi Movie Online, Watch Haider 2014, Haider 2014 Online Full Movie, Haider 2014 DvdRip With English Subtitles, Dailymotion, youtube, parts Putlocker, Cloudy, Novamov, MovZap, Videohut Movie: Haider 2014 Directed by: Vishal Bhardwaj Written by: William Shakespeare, Basharat Peer Starring by: Tabu, Shahid Kapoor, Shraddha Kapoor Genres: Crime | Drama | Romance ...
Trancemaster
Assistir ? Episodio 15
Extreme How-To Magazine - May 2014 USA
Episode 3 : Isolement :
WhatsApp
Forbrydelsen
Shrek the Third
Boye (2015) en linea gratis en movie2k
Download
IMDB-7.9
Abigail Breslin
Reality-TV
??) ?????.
Dragonheart: Battle for the Heartfire
Matthew Perry,
The Cooper/Kri season 06 episode 14
Death Valley
The Secret Scripture
Super Army of Tentacles 3 The Search for Army of Tentacles 2-HI2U
Feuer und Blut Fire and Blood
Hopeless fountain kingdom (Deluxe) - Halsey
Callie North
Alba Allotta - Le cento migliori ricette con il marsala [Pdf - Cbr - ITA] [TNTVi...
Mixology
Haider Full Movie (2014) DVDRip Watch Online Watch Haider 2014 Hindi DVDRip Free HDTV Online Full Movie You can watch Haider 2014, Haider 2014 Full Movie, Haider Online Full Movie, Haider Hindi Movie Online, Watch Haider 2014, Haider 2014 Online Full Movie, Haider 2014 DvdRip With English Subtitles, Dailymotion, youtube, parts Putlocker, Cloudy, Novamov, MovZap, Videohut Movie: Haider 2014 Directed by: Vishal Bhardwaj Written by: William Shakespeare, Basharat Peer Starring by: Tabu, Shahid Kapoor, Shraddha Kapoor Genres: Crime | Drama | Romance ...
Trancemaster
Assistir ? Episodio 15
Extreme How-To Magazine - May 2014 USA
Episode 3 : Isolement :
Forbrydelsen
Shrek the Third
Boye (2015) en linea gratis en movie2k
Download
IMDB-7.9
Abigail Breslin
Reality-TV
??) ?????.
Dragonheart: Battle for the Heartfire
Matthew Perry,
The Cooper/Kri season 06 episode 14
Death Valley
The Secret Scripture
#8
Escrito 18 julio 2017 - 20:49
Soulskinner - Descent To Abaddon (2017)
Read More
The Martian
Cai li fu qu...HD - 2011
Chips (2017) 720p BluRay x264 DRONES
Benedict Cumberbatch
openload
paterson
Kingsglaive Final Fantasy XV STREAMING ITA (2016)
Download
Contra Viento y Marea HDTV
English The Fate of the Furious (Fast and Furious 8) (2017)
CSGO v1.35.6.9 [Isohunt.to]
Devious Maids 8
Openload.co
Odysseus - Macht. Intrige. Mythos.
Alien Resurreccion BLuRayRip
Новое слово в жанре ужаса
Read More
The Martian
Cai li fu qu...HD - 2011
Chips (2017) 720p BluRay x264 DRONES
Benedict Cumberbatch
openload
paterson
Kingsglaive Final Fantasy XV STREAMING ITA (2016)
Download
Contra Viento y Marea HDTV
English The Fate of the Furious (Fast and Furious 8) (2017)
CSGO v1.35.6.9 [Isohunt.to]
Devious Maids 8
Openload.co
Odysseus - Macht. Intrige. Mythos.
Alien Resurreccion BLuRayRip
Новое слово в жанре ужаса
#9
Escrito 18 julio 2017 - 20:53
Dr Kevin Leman - Have a New Sex Life by Friday 2017 RETAiL ePUB eBOOK-DiSTRiB...
Capitan America 2: El soldado de invierno
Date My DadS01E02
Download
Rules of Engagement
Episodes
Beauty And The Beast/Krás…
???
Hatim Tai All Drama Song Mp3
[H-Manga] [PONPON] Start Up! [Digital] - [PONPON] Start Up! [DL版] [Japanese]
Miss Peregrine et les enfants particuliers (2016) ...(A)
Fast And Furious 8 BluRay-Screeener
Брианна Хилдебранд
Season 2 Episode 20 Stitched Up Sisters
The Cop – Crime Scene Paris
Suspenso y Misterio
Blu-ray 8.5 2007 Вселенная · 2007
Hamatora
Season 3 Episode 11 Gay Feet
Descargar
Capitan America 2: El soldado de invierno
Date My DadS01E02
Download
Rules of Engagement
Episodes
Beauty And The Beast/Krás…
???
Hatim Tai All Drama Song Mp3
[H-Manga] [PONPON] Start Up! [Digital] - [PONPON] Start Up! [DL版] [Japanese]
Miss Peregrine et les enfants particuliers (2016) ...(A)
Fast And Furious 8 BluRay-Screeener
Брианна Хилдебранд
Season 2 Episode 20 Stitched Up Sisters
The Cop – Crime Scene Paris
Suspenso y Misterio
Blu-ray 8.5 2007 Вселенная · 2007
Hamatora
Season 3 Episode 11 Gay Feet
Descargar
#10
Escrito 19 julio 2017 - 02:13
Mobile Applications with PhoneGap
Durchgedreht
Diabolik Lovers
Spirits Homecoming
dj snake we can turn back the tima to make me allright
Mermaid Forest
Facebook
Harvest Villa
Pluralsight - D3 js Data Visualization Fundamentals
express employment yakima washington
descarga Vulcania en espanol gratis
The Librarians US S03E07 x264-RYBOI mp4
She's the Man
openload.co Logan (2017) 720p BluRay.mp4
Love & Hip H...S06E14
2.Sezon 5. Bolum
tous en scne
19. The Chainsmokers & Coldplay - Something Just Like This (Dzeko Remix)
Wali Band - Serpihan Hatiku
Episode 6
Matantei Loki Ragnarok
Homeward Bound Duology Collections
Durchgedreht
Diabolik Lovers
Spirits Homecoming
dj snake we can turn back the tima to make me allright
Mermaid Forest
Harvest Villa
Pluralsight - D3 js Data Visualization Fundamentals
express employment yakima washington
descarga Vulcania en espanol gratis
The Librarians US S03E07 x264-RYBOI mp4
She's the Man
openload.co Logan (2017) 720p BluRay.mp4
Love & Hip H...S06E14
2.Sezon 5. Bolum
tous en scne
19. The Chainsmokers & Coldplay - Something Just Like This (Dzeko Remix)
Wali Band - Serpihan Hatiku
Episode 6
Matantei Loki Ragnarok
Homeward Bound Duology Collections
#11
Escrito 19 julio 2017 - 11:05
Nazo no Tenkousei
Season 3 Episode 9 Heroin Robin Hood
Season 1 Episode 9 Future Tense
Istoric 27
Ler mais
Kung Fu Panda - Legenden mit Fell und Fu
Comedia
Kirsty Grace
Sick of it A (2017)
Death Note (2015) – Saison 1
► Regarder Backpackers Saison 1 Г©pisode 7 : Episode 7 gratuit en streaming HD & VO / VF / VOST / VOSTFR
Gary Wales
The Growing Pains Movie (2000)
Star Plus Awards Concerts
Torrent Magazine
Zobacz film
Oceanos de Fuego BluRay 1080p
Season 3 Episode 9 Heroin Robin Hood
Season 1 Episode 9 Future Tense
Istoric 27
Ler mais
Kung Fu Panda - Legenden mit Fell und Fu
Comedia
Kirsty Grace
Sick of it A (2017)
Death Note (2015) – Saison 1
► Regarder Backpackers Saison 1 Г©pisode 7 : Episode 7 gratuit en streaming HD & VO / VF / VOST / VOSTFR
Gary Wales
The Growing Pains Movie (2000)
Star Plus Awards Concerts
Torrent Magazine
Zobacz film
Oceanos de Fuego BluRay 1080p
#12
Escrito 30 julio 2017 - 05:10
dual audio hindi
Leave a comment
Hindi Dubbed
Fantastique
???? [??? BY ???..
FREE DOWNLOAD
Windows 7 Ultimate Sp1 Mise Г Jour DГ©cembre 2016
Dr Zakir Naik Peace Tv Urdu Mp3
Law And Order UK 5
serie top mdel du 28042016
My XXX Secretary 3
Thor: Ragnarök (2017)
Funny Desi kid singing punjabi song in funny way
jagg jungle ship dj intro version
Buen rollito / How High (Se les subieron los humos) (2001)
Tooth Fairy (2010) HD
The Driver
Steven Strait
Tom and Jerry: Mouse in Manhattan (1945)
June 2017 (1824)
Bassjackers Jay Hardway El Mariachi
Watch show
Heiter bis todlich: Hubert und Staller
Fear The Walking Dead - Saison 3
Download
Leave a comment
Hindi Dubbed
Fantastique
???? [??? BY ???..
FREE DOWNLOAD
Windows 7 Ultimate Sp1 Mise Г Jour DГ©cembre 2016
Dr Zakir Naik Peace Tv Urdu Mp3
Law And Order UK 5
serie top mdel du 28042016
My XXX Secretary 3
Thor: Ragnarök (2017)
Funny Desi kid singing punjabi song in funny way
jagg jungle ship dj intro version
Buen rollito / How High (Se les subieron los humos) (2001)
Tooth Fairy (2010) HD
The Driver
Steven Strait
Tom and Jerry: Mouse in Manhattan (1945)
June 2017 (1824)
Bassjackers Jay Hardway El Mariachi
Watch show
Heiter bis todlich: Hubert und Staller
Fear The Walking Dead - Saison 3
Download
0 usuarios están leyendo este tema
0 miembro/s, 0 invitado/s, 0 usuario/s anónimo/s