Ir a contenido


MENSAJE DE BIENVENIDA Foro vínculado con Twitter, más info aquí.

“El secreto para progresar es empezar por algún lugar. El secreto para empezar por algún lugar es fragmentar tus complejas y abrumadoras tareas de tal manera que queden convertidas en pequeñas tareas que puedas realizar y entonces simplemente comenzar por la primera.” - Mark Twain

Foto

Query para Obtener Mensaje de Alerta de Reglas


  • Please log in to reply
No replies to this topic

#1 Alberto Dominguez

Alberto Dominguez

    Gurú

  • Administradores
  • 1.059 Mensajes:
  • LocationMadrid

Escrito 07 junio 2013 - 14:29

Query que nos devuelve información de Reglas (Management Pack, Regla, Regla DisplayName, Nombre Alerta, Clase y Severidad):

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

Saludos,

Alberto Dominguez

Enterprise Architect y Trainer
MCT, MCPD, MCITP, MCITP Dynamics, MCSE, MCSA, MCTS, MCP...
ITIL V3 Foundation Qualification in IT Service Management
Imagen enviadaPerfil Profesional Imagen enviadaTwitter
Imagen enviadaImagen enviadaImagen enviadaImagen enviada

#2 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#3 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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)


#4 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#5 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#6 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#7 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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)


#8 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#9 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#10 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#11 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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
Фэнтези


#12 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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


#13 porsercok

porsercok

    Experto

  • Miembros
  • PipPipPipPip
  • 442 Mensajes:
  • LocationParis

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





0 usuarios están leyendo este tema

0 miembro/s, 0 invitado/s, 0 usuario/s anónimo/s