Select distinct Mon3.ManagementPackName,Mon3.RuleName,Mon3.RuleDisplayName,
Mon3.NombreAlerta,Mon3.Clase,Mon3.Severity,Texto4.LTValue AS MensajeAlerta from
(Select distinct Mon2.ManagementPackName,Mon2.RuleName,Mon2.RuleDisplayName,
Mon2.NombreAlerta,Texto3.LTValue AS Clase,Mon2.Severity from
(Select Distinct Mon.ManagementPackName,Mon.RuleName,Texto2.ElementName,Mon.RuleDisplayName,
Texto2.LTValue AS NombreAlerta,Mon.ClaseId,Mon.Severity from
(Select Distinct Man.MPName AS ManagementPackName,Regla.RuleId,Regla.RuleName,
Texto.LTValue AS RuleDisplayName,Regla.TargetManagedEntityType AS ClaseId,
Severity=
CASE CAST(rm.RuleModuleConfiguration AS XML).value('(/Severity)[1]','nvarchar(1)')
WHEN '0' THEN 'Information'
WHEN '1' THEN 'Warning'
WHEN '2' THEN 'Critical'
END
from dbo.rules AS Regla
inner join dbo.LocalizedText AS Texto
On Regla.RuleId=Texto.LTStringID
inner Join dbo.managementpack AS Man
On Regla.ManagementPackId=Man.ManagementPackId
inner join dbo.rulemodule rm
on rm.Ruleid=regla.Ruleid
where Texto.LTSTringType=1 AND Texto.LanguageCode='ENU'
AND CAST(RuleModuleConfiguration AS XML).value('(/Severity)[1]','nvarchar(1)') IS NOT NULL) as Mon
inner join dbo.LocalizedText AS Texto2
On (Mon.Rulename+'.AlertMessage')=Texto2.ElementName
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') Mon3
inner join dbo.LocalizedText AS Texto4
On (Mon3.Rulename+'.AlertMessage')=Texto4.ElementName
where Texto4.LTSTringType=2 AND Texto4.LanguageCode='ENU'
Order By RuleName
Query para Obtener Mensaje de Alerta de Reglas
Started by Alberto Dominguez, jun 07 2013 14:29
No replies to this topic
#1
Escrito 07 junio 2013 - 14:29
Query que nos devuelve información de Reglas (Management Pack, Regla, Regla 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 07 julio 2017 - 17:56
Mom saison 1 Г©pisode 7
Aye Dil Kar Ki Yad Main Mp3
Internet Download Manager (IDM) 6.25 Build 21 Registered
Les Chroniques de Shannara saison 1 Г©pisode 1 et 2
Crunch Time
Next Page
Amazing Girls in Latex Love Sex
Gorillaz
Latest Videos
Popularity
10.Sezon 18.Bolum Book of the Damned
Adventure
Coming Soon
Ransom (season 1)
Les Simpson saison 28 Г©pisode 11
Die Simpsons
Гун Бэйби
The L.A. Complex
24-04-2015, 07:05
Diomedes DГazCancionesDiscografГa
14 серия - The Cooper-Kripke Inversion
Almost Human 2013
Aye Dil Kar Ki Yad Main Mp3
Internet Download Manager (IDM) 6.25 Build 21 Registered
Les Chroniques de Shannara saison 1 Г©pisode 1 et 2
Crunch Time
Next Page
Amazing Girls in Latex Love Sex
Gorillaz
Latest Videos
Popularity
10.Sezon 18.Bolum Book of the Damned
Adventure
Coming Soon
Ransom (season 1)
Les Simpson saison 28 Г©pisode 11
Die Simpsons
Гун Бэйби
The L.A. Complex
24-04-2015, 07:05
Diomedes DГazCancionesDiscografГa
14 серия - The Cooper-Kripke Inversion
Almost Human 2013
#3
Escrito 11 julio 2017 - 19:19
Swallows and Amazons (2016)
Xmovies8.com
Hooten & the LadyDernier episode ajoute: Saison 1 - Episode 8
The Dancer
Best Natalie Portman Movies
JDowmloader 13 JUN Zevera +Online TUTO
Mission: Impossible – Ghost Protocol (2011) Watch Online Hindi Dubbed
The Lottery
Delusion (2016)
The New Shmoo
Yu-Gi-Oh!: The Dark Side of Dimensions Movie
Comunidad Jarigo 1
Lynne Wilmot
RSS Beslemesi
November 2012 (8246)
Katherine Sigismund
(2016) DVD Batman Return of the Caped..
Dark Matter S03E06 HDTV x264 SVA rarbg Anonymously
Episode list
Le.Bureau.Des.Legendes.S03E05.FRENCH.720p.HDTV.x26...(A)
download suara kutilang jambul
Next Let Me Make You a Martyr (2017)
Xmovies8.com
Hooten & the LadyDernier episode ajoute: Saison 1 - Episode 8
The Dancer
Best Natalie Portman Movies
JDowmloader 13 JUN Zevera +Online TUTO
Mission: Impossible – Ghost Protocol (2011) Watch Online Hindi Dubbed
The Lottery
Delusion (2016)
The New Shmoo
Yu-Gi-Oh!: The Dark Side of Dimensions Movie
Comunidad Jarigo 1
Lynne Wilmot
RSS Beslemesi
November 2012 (8246)
Katherine Sigismund
(2016) DVD Batman Return of the Caped..
Dark Matter S03E06 HDTV x264 SVA rarbg Anonymously
Episode list
Le.Bureau.Des.Legendes.S03E05.FRENCH.720p.HDTV.x26...(A)
download suara kutilang jambul
Next Let Me Make You a Martyr (2017)
#4
Escrito 14 julio 2017 - 21:09
HD King Charles III
Willkommen bei den Louds
9 comentarios
kun anta versi dugem
Jordan Peele,
Mini-Max
Erase Your Social
Prime Suspect 1973
Download
Frequency 2000 720p Esub BluRay Dual Audio English Hindi GOPI SAHI
El Gringo
Himegoto
7 Naatkal (2017) HQ DVDScr
Bhola o Bhola
Teachers
$200.00 - $299.99
Disney Evermoor
Хентай, порно и эротические мультфильмы
Pompidou
Ugaritic literature
Les Bodins – Grandeur Nature (2016) Streaming Spectacle HD
Die Schone und das Biest (2017)
Mystery Girls
The Shannara Chronicles 8.2
(2016) DVDRip Andel Pane 2
Willkommen bei den Louds
9 comentarios
kun anta versi dugem
Jordan Peele,
Mini-Max
Erase Your Social
Prime Suspect 1973
Download
Frequency 2000 720p Esub BluRay Dual Audio English Hindi GOPI SAHI
El Gringo
Himegoto
7 Naatkal (2017) HQ DVDScr
Bhola o Bhola
Teachers
$200.00 - $299.99
Disney Evermoor
Хентай, порно и эротические мультфильмы
Pompidou
Ugaritic literature
Les Bodins – Grandeur Nature (2016) Streaming Spectacle HD
Die Schone und das Biest (2017)
Mystery Girls
The Shannara Chronicles 8.2
(2016) DVDRip Andel Pane 2
#5
Escrito 14 julio 2017 - 21:45
El Chema
American Dad S14E14 WEB-DL x264-RARBG
Christian & Gospel
Imposters
Beautiful Stranger Madonna Mp3
For Windows (Активаторы и прочее)
Pretty Woman 1990 BD Rip 720p 5xRus Ukr Eng mkv
Frank Grillo
SD Card Data Recovery Wizard v8 8 8 8 + Crack + Portable
Read More
La Llegada BluRay-Screeener
David Morse
Legionario Despues de su ultima mision en Afganistan y tras su fiesta de bienvenida, un soldado espanol despierta junto al cadaver de una joven que no es su prometida. Queriendo encontrar a su chica, se desboca a ello ya sea pidiendo ayuda a riesgo de ser culpado o a solucionarlo el mismo.
KWON JI YOUNG (EP)
Telecharger
Histoires Fantastiques
The Weather Man (2005)
Almost There (season 1)
The Sin (2004)
Shadowhunters HDTV
RSS Feed
Clowns Shed No Tears
American Dad S14E14 WEB-DL x264-RARBG
Christian & Gospel
Imposters
Beautiful Stranger Madonna Mp3
For Windows (Активаторы и прочее)
Pretty Woman 1990 BD Rip 720p 5xRus Ukr Eng mkv
Frank Grillo
SD Card Data Recovery Wizard v8 8 8 8 + Crack + Portable
Read More
La Llegada BluRay-Screeener
David Morse
Legionario Despues de su ultima mision en Afganistan y tras su fiesta de bienvenida, un soldado espanol despierta junto al cadaver de una joven que no es su prometida. Queriendo encontrar a su chica, se desboca a ello ya sea pidiendo ayuda a riesgo de ser culpado o a solucionarlo el mismo.
KWON JI YOUNG (EP)
Telecharger
Histoires Fantastiques
The Weather Man (2005)
Almost There (season 1)
The Sin (2004)
Shadowhunters HDTV
RSS Feed
Clowns Shed No Tears
#6
Escrito 15 julio 2017 - 12:54
Zippyshare
1994–2004
Read More..
100 Adobe Photoshop Plugins
list all pages->
Frank Grillo
Download
Stitchers S03E05 (1080p WEBRip x265 HEVC 10bit AAC 5 1 D0ct0rLew)[UTR] mkv
Rise Against
Masters Of Horror Imprint (2006) 2006 HD
Farhan Saed Songs Mp3
Fall In Love With You Again (2015)
The Boss Baby 2017 720p HD-TS x264 AC3-CPG
Read more...
Terriers
Japanese macaque
Trailers
C: The Money of Soul and Possibility Control
father-son relationship
Naruto Shippuden Stagione 6 – Saga della profezia del maestro e della vendetta Streaming ITA – (2011)
Watch Music and Lyrics Movie Online Free
1994–2004
Read More..
100 Adobe Photoshop Plugins
list all pages->
Frank Grillo
Download
Stitchers S03E05 (1080p WEBRip x265 HEVC 10bit AAC 5 1 D0ct0rLew)[UTR] mkv
Rise Against
Masters Of Horror Imprint (2006) 2006 HD
Farhan Saed Songs Mp3
Fall In Love With You Again (2015)
The Boss Baby 2017 720p HD-TS x264 AC3-CPG
Read more...
Terriers
Japanese macaque
Trailers
C: The Money of Soul and Possibility Control
father-son relationship
Naruto Shippuden Stagione 6 – Saga della profezia del maestro e della vendetta Streaming ITA – (2011)
Watch Music and Lyrics Movie Online Free
#7
Escrito 15 julio 2017 - 19:07
DEATH RACE 2 (2012)
View details
Pal Do Pal Nusrat Remix Mp3
Proximo
6. Sezon
Assassin’s Creed (2016) Watch Assassin's Creed (2016) Movie Free Online Stream Through unlocked genetic memories that allow him to relive the adventures of his ancestor in 15th century Spain, Callum Lynch discovers he's a descendant of the secret 'Assassins' society. After gaining incredible knowledge and skills, he is now poised to take on the oppressive Knights Templar in the present day.
Salt FULLBluRay
Crowded (season 1)
THIS IS WHERE I LEAVE YOU (2014)
Upcoming Movies
(2016) DVD Heartland
WordPress
NCIS : Los Angeles saison 7 episode 22
Cake DOWNLOAD ITA – 720p BluRay (2015)
The Last Stand
AuroraVid
Beauty and the Beast (2017)
Pluralsight - Introduction to SQL
Zobacz film
Gizem Filmleri
Jekyll and Hyde
Absolutely Fabulous: The Movie (2016)
Notorious
Muzyczny (0)
View details
Pal Do Pal Nusrat Remix Mp3
Proximo
6. Sezon
Assassin’s Creed (2016) Watch Assassin's Creed (2016) Movie Free Online Stream Through unlocked genetic memories that allow him to relive the adventures of his ancestor in 15th century Spain, Callum Lynch discovers he's a descendant of the secret 'Assassins' society. After gaining incredible knowledge and skills, he is now poised to take on the oppressive Knights Templar in the present day.
Salt FULLBluRay
Crowded (season 1)
THIS IS WHERE I LEAVE YOU (2014)
Upcoming Movies
(2016) DVD Heartland
WordPress
NCIS : Los Angeles saison 7 episode 22
Cake DOWNLOAD ITA – 720p BluRay (2015)
The Last Stand
AuroraVid
Beauty and the Beast (2017)
Pluralsight - Introduction to SQL
Zobacz film
Gizem Filmleri
Jekyll and Hyde
Absolutely Fabulous: The Movie (2016)
Notorious
Muzyczny (0)
#8
Escrito 15 julio 2017 - 19:08
Telecharger
Dragon Ball Z Movie 10 Broly Second Coming
2 Broke Girls Season 4 Episode 15 – And the Fat Cat
The Driver
tv anni 80
Jake und die Nimmerland Piraten
Marco Polo
1940-1950
Crime 1986
Redbone - Childish Gambino
Dacre Montgomery
The Walking Dead
adobe after effect cc crack 2017
Season 2
Frequency 2000 720p Esub BluRay Dual Audio English Hindi GOPI SAHI
78. Nerve
mkv
Shigatsu wa Kimi no Uso: Sekunden in Moll
Dalida (2017)
An Pierle 2016 Arches FLAC 16Bits 44,1kHz(N) (A)
Heaven's Soldiers
UNDERSTANDING ORGANISATIONS
February 14, 2017
This is Why We season 09 episode 16
Dragon Ball Z Movie 10 Broly Second Coming
2 Broke Girls Season 4 Episode 15 – And the Fat Cat
The Driver
tv anni 80
Jake und die Nimmerland Piraten
Marco Polo
1940-1950
Crime 1986
Redbone - Childish Gambino
Dacre Montgomery
The Walking Dead
adobe after effect cc crack 2017
Season 2
Frequency 2000 720p Esub BluRay Dual Audio English Hindi GOPI SAHI
78. Nerve
mkv
Shigatsu wa Kimi no Uso: Sekunden in Moll
Dalida (2017)
An Pierle 2016 Arches FLAC 16Bits 44,1kHz(N) (A)
Heaven's Soldiers
UNDERSTANDING ORGANISATIONS
February 14, 2017
This is Why We season 09 episode 16
#9
Escrito 15 julio 2017 - 19:12
Drake - More Life (2017)
15 серия - The Locomotion Manipulation
Риз Уизерспун
Samurai Pizza Cats
Thai Movies
American Pickers Season 2017 Episode 12 s2017e12
Citas bestiales
Ifttt Domotique
Hanna Sovershennoe oruzhie 2011 DUB DVDRip x264 V2_Vaippp mkv
Warehouse 13
Fear The Walking Dead
mantu ali majuli jila hol video
Aqui Estoy Yo
Navy CIS: L.A.
Marco Polo
The Messengers
Watch Movie
Ach du lieber Vater
4. Sezon 15. Bolum Love ShAck, Baby
15 серия - The Locomotion Manipulation
Риз Уизерспун
Samurai Pizza Cats
Thai Movies
American Pickers Season 2017 Episode 12 s2017e12
Citas bestiales
Ifttt Domotique
Hanna Sovershennoe oruzhie 2011 DUB DVDRip x264 V2_Vaippp mkv
Warehouse 13
Fear The Walking Dead
mantu ali majuli jila hol video
Aqui Estoy Yo
Navy CIS: L.A.
Marco Polo
The Messengers
Watch Movie
Ach du lieber Vater
4. Sezon 15. Bolum Love ShAck, Baby
#10
Escrito 15 julio 2017 - 19:34
thunder back street symphony
Sungkyunkwan Scandal
Mr Robot S01E05 720p HDTV x264 KILLERS rarbg
To aru Majutsu no Index
Corazon En La Maleta
Watch movie
Zamanay Mein Reh K Bhi Akelay Mp3
The Bye Bye Man 2017 HDCAM
Mercy Street 1 dzien temu
Скачать торрент
War for The Planet of the Apes TV Spot
Code Of Honor STREAMING ITA (2016)
Daniella Margot, Nesty - Cute Teen Has Anal Threesome (14.06.2017...
The Name of th season 07 episode 13
The Fosters 2015 S05E01 720p HDTV x264-FLEET[rarbg]
Practice - Die Anwalte
Sonic Flower 2003 - Sonic Flower
2 серия - The Jiminy Conjecture
Kedi izle | 720p
Men In Black 3 DVDRIP
Free Episode Download
Sungkyunkwan Scandal
Mr Robot S01E05 720p HDTV x264 KILLERS rarbg
To aru Majutsu no Index
Corazon En La Maleta
Watch movie
Zamanay Mein Reh K Bhi Akelay Mp3
The Bye Bye Man 2017 HDCAM
Mercy Street 1 dzien temu
Скачать торрент
War for The Planet of the Apes TV Spot
Code Of Honor STREAMING ITA (2016)
Daniella Margot, Nesty - Cute Teen Has Anal Threesome (14.06.2017...
The Name of th season 07 episode 13
The Fosters 2015 S05E01 720p HDTV x264-FLEET[rarbg]
Practice - Die Anwalte
Sonic Flower 2003 - Sonic Flower
2 серия - The Jiminy Conjecture
Kedi izle | 720p
Men In Black 3 DVDRIP
Free Episode Download
#11
Escrito 15 julio 2017 - 19:46
Shinryaku! Ika Musume
Ben 10 Omniverse
Golden Boy
◄ Tuesday 13/06 ►
11 de marco de 2017
Superior Donuts
Continue reading VA-Groovy Adventures vol.2-CD-FLAC-2017-SMASH
Резня (1 сезон)
5.8 Batman Unlimited: Mech vs. Mutants
Todas las Cheerleaders Muertas
TheVideo
Der fliegende Ferdinand
HДѕadГЎm Hudbu
Carnival Phantasm
How I Met Your Mother
A Certain Romance
Better Call Saul
Plaszcza i ... (0)
Sezonul Cireselor
The Graduate 1967 BluRay 1080p DTS x264-HDChina
Prince of Persia: The Sands of Time (2010)
Linkedin
Фэнтези
Ben 10 Omniverse
Golden Boy
◄ Tuesday 13/06 ►
11 de marco de 2017
Superior Donuts
Continue reading VA-Groovy Adventures vol.2-CD-FLAC-2017-SMASH
Резня (1 сезон)
5.8 Batman Unlimited: Mech vs. Mutants
Todas las Cheerleaders Muertas
TheVideo
Der fliegende Ferdinand
HДѕadГЎm Hudbu
Carnival Phantasm
How I Met Your Mother
A Certain Romance
Better Call Saul
Plaszcza i ... (0)
Sezonul Cireselor
The Graduate 1967 BluRay 1080p DTS x264-HDChina
Prince of Persia: The Sands of Time (2010)
Фэнтези
#12
Escrito 16 julio 2017 - 12:45
When We Rise
Patton Oswalt
The Shield: Al margen de la ley
Season 5 Episode 8 Wind and a Prayer
Blue Tide (2014) Full Movie Watch Online Watch Blue Tide (2014) Tamil Online DVDScr Free Full Movie Download Now You can watch Blue Tide (2014), Blue Tide 2014 Full Movie, Blue Tide Online Full Movie,Blue Tide English Movie Online, Watch Blue Tide 2014, Blue Tide 2014 Online DVD Rip Full Movie, Blue Tide 2014 DvdRip With English Subtitles, Uploader Video on Dailymotion, youtube, Putlocker, Mightyupload, Vidbull, Cloudy, Novamov, MovZap, Videohut, Vodlocker Free ...
Telecharger L.A. Rush
Gossip Girl
Still Star-Crossed
Nike Jiang Gal Mp3
Gegege no Nyobo
Game of Thrones
American Daredevils – Hart am Limit
Season 12 - Episode 1
Baahubali 2 - The Conclusion (Original Motion Picture Soundtrack) - EP
Episode 3 : I'll See You in Hell or New Orleans
Gott ist nicht tot 2 stream
Chadwick Boseman
Assistir American Gods 1? Temporada Episodio 01 – Dublado Online Em HD
Le Hobbit 3 la Bataille des Cinq Armees Streaming
The Great Indoors
Mothership Loudspeakerz - Low Poly (2017)
Black GF 10 (Reality Kings) NEW 2015 WEB-DL (Split Scenes)
30 comment(s)
Baby Driver
Patton Oswalt
The Shield: Al margen de la ley
Season 5 Episode 8 Wind and a Prayer
Blue Tide (2014) Full Movie Watch Online Watch Blue Tide (2014) Tamil Online DVDScr Free Full Movie Download Now You can watch Blue Tide (2014), Blue Tide 2014 Full Movie, Blue Tide Online Full Movie,Blue Tide English Movie Online, Watch Blue Tide 2014, Blue Tide 2014 Online DVD Rip Full Movie, Blue Tide 2014 DvdRip With English Subtitles, Uploader Video on Dailymotion, youtube, Putlocker, Mightyupload, Vidbull, Cloudy, Novamov, MovZap, Videohut, Vodlocker Free ...
Telecharger L.A. Rush
Gossip Girl
Still Star-Crossed
Nike Jiang Gal Mp3
Gegege no Nyobo
Game of Thrones
American Daredevils – Hart am Limit
Season 12 - Episode 1
Baahubali 2 - The Conclusion (Original Motion Picture Soundtrack) - EP
Episode 3 : I'll See You in Hell or New Orleans
Gott ist nicht tot 2 stream
Chadwick Boseman
Assistir American Gods 1? Temporada Episodio 01 – Dublado Online Em HD
Le Hobbit 3 la Bataille des Cinq Armees Streaming
The Great Indoors
Mothership Loudspeakerz - Low Poly (2017)
Black GF 10 (Reality Kings) NEW 2015 WEB-DL (Split Scenes)
30 comment(s)
Baby Driver
#13
Escrito 22 julio 2017 - 04:14
- Shooter S02E01 1080p HEVC x265-MeGusta
We are Brothers (Movie)
Season 7 Episode 1 The Bots and the Bees
Кристофер Нолан
Eps1 American Pie 1
Criminal Minds Beyond Borders
The Life of David Gale (2003) 1080p ENG-ITA MultiSub x264 BluRay -Shiv@ mkv
Jigoku Shoujo
Maisa Silva
Big Little Lies 8.8
Download
Le Monde secret des Emojis 1080p TrueFrench Film Torrent complet en francais
Continuar
Ya Mohammad Noor Mujassam By Hafiz Tahir Mp3
Hurricane Bianca streaming vf
Sensitive Skin
Just Added Episodes
Nenhum comentГЎrio
.mp3
Railroad Tigers (2016) Full Movie Watch Online Free
JuanOviedo
May 2016
We are Brothers (Movie)
Season 7 Episode 1 The Bots and the Bees
Кристофер Нолан
Eps1 American Pie 1
Criminal Minds Beyond Borders
The Life of David Gale (2003) 1080p ENG-ITA MultiSub x264 BluRay -Shiv@ mkv
Jigoku Shoujo
Maisa Silva
Big Little Lies 8.8
Download
Le Monde secret des Emojis 1080p TrueFrench Film Torrent complet en francais
Continuar
Ya Mohammad Noor Mujassam By Hafiz Tahir Mp3
Hurricane Bianca streaming vf
Sensitive Skin
Just Added Episodes
Nenhum comentГЎrio
.mp3
Railroad Tigers (2016) Full Movie Watch Online Free
JuanOviedo
May 2016
0 usuarios están leyendo este tema
0 miembro/s, 0 invitado/s, 0 usuario/s anónimo/s