SELECT COUNT(vAlertDetail.AlertGuid) AS TotalAlerts, Alert.vAlert.AlertName, Alert.vAlert.Category, AVG(Alert.vAlert.RepeatCount) AS AverageRepeatCount, vManagedEntity.Path, vManagedEntity.DisplayName, vManagedEntity.ManagedEntityDefaultName, vResolutionState.ResolutionStateName, AVG(Alert.vAlertResolutionState.TimeFromRaisedSeconds) AS AverageOpenTimeSeconds FROM Alert.vAlertDetail INNER JOIN Alert.vAlert ON Alert.vAlertDetail.AlertGuid = Alert.vAlert.AlertGuid INNER JOIN vManagedEntity ON Alert.vAlert.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId INNER JOIN Alert.vAlertResolutionState ON Alert.vAlert.AlertGuid = Alert.vAlertResolutionState.AlertGuid INNER JOIN vResolutionState ON Alert.vAlertResolutionState.ResolutionState = vResolutionState.ResolutionStateId WHERE Alert.vAlert.RaisedDateTime BETWEEN getutcdate()-30 AND getutcdate() AND Alert.vAlert.AlertName <> '' AND Alert.vAlert.AlertName like '%logical disk Free Space%' --AND vResolutionState.ResolutionStateName = 'New'GROUP BY Alert.vAlert.AlertName, Alert.vAlert.Category, vManagedEntity.Path, vManagedEntity.DisplayName, vManagedEntity.ManagedEntityDefaultName, vResolutionState.ResolutionStateName ORDER BY COUNT(vAlertDetail.AlertGuid) DESC, AVG(Alert.vAlertResolutionState.TimeFromRaisedSeconds) DESC

Query para obtener las alertas de la BBDD de DW de Espacio en Disco
Started by Alberto Dominguez, may 21 2014 13:46
3 replies to this topic
#1
Escrito 21 mayo 2014 - 13:46
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






#2
Escrito 16 julio 2017 - 05:37
RUSSOUND
Del Reves 3D HOU BluRay 3D 1080p
Summer Snow
Putlocker in HD
telecharger gratuit Bad Buzz (2017) VOSTFR
Fear The Wal...S03E03
Breathless DVDRIP
Новинки российского кино Всем известно, что А. С. Пушкин — наше всё. Поэтому ученики современного московского лицея хотят во что бы то ни стало спасти великого поэта от неминуемой смерти на дуэли. Школьники с помощью машины времени переносят Александра Сергеевича в XXI век, но и в наши дни его подстерегает немало опасностей.... Раздают: 5 Качают: 0 Размер: 2.86GB
EX-WIVES OF ROCK
Rezidentai 3 Sezonas (2016)
Baron Noir
200 Degrees
Christopher Miller,
Westworld
Az ejszaka kiralynoje
Google +
La double vie d'Eddie McDown S01EP01 Comme un chie...(N) (P)
download
(2016) HDRip Blood Hunters
Documentary
Through Many D season 02 episode 14
Tyler Green
Interstella 5555: The 5tory of the 5ecret 5tar 5ystem Un malvado empresario secuestra y lava el cerebro a un grupo de rock extraterrestre, los convierte en estrellas de rock prefabricadas, los envia a la Tierra y los manipula hasta hacer que sean los numeros uno en todas las listas, dandole a el mas poder.
Del Reves 3D HOU BluRay 3D 1080p
Summer Snow
Putlocker in HD
telecharger gratuit Bad Buzz (2017) VOSTFR
Fear The Wal...S03E03
Breathless DVDRIP
Новинки российского кино Всем известно, что А. С. Пушкин — наше всё. Поэтому ученики современного московского лицея хотят во что бы то ни стало спасти великого поэта от неминуемой смерти на дуэли. Школьники с помощью машины времени переносят Александра Сергеевича в XXI век, но и в наши дни его подстерегает немало опасностей.... Раздают: 5 Качают: 0 Размер: 2.86GB
EX-WIVES OF ROCK
Rezidentai 3 Sezonas (2016)
Baron Noir
200 Degrees
Christopher Miller,
Westworld
Az ejszaka kiralynoje
Google +
La double vie d'Eddie McDown S01EP01 Comme un chie...(N) (P)
download
(2016) HDRip Blood Hunters
Documentary
Through Many D season 02 episode 14
Tyler Green
Interstella 5555: The 5tory of the 5ecret 5tar 5ystem Un malvado empresario secuestra y lava el cerebro a un grupo de rock extraterrestre, los convierte en estrellas de rock prefabricadas, los envia a la Tierra y los manipula hasta hacer que sean los numeros uno en todas las listas, dandole a el mas poder.
#3
Escrito 19 julio 2017 - 04:46
[Sub English]
Lynda – Houdini: Advanced Motion Graphics
Lighters Bad Meets Evil Mp3
lagu dangdut koplo cinta merah jambu download
Zobrazit posledny prispevok
Packt.-.Go.Building.Web.Applications.2016.RETAiL.ePUB.eBOOK-DiSTRiBUTiON[xwarez].torrent [Isohunt.to]
Alcaldesa 2016 hd pelicula .avi
Too Young To Die! (2016)
Scream Queens
The Magnificent Seven (2016) Bluray 720p + Indo Subtitle
Sperling
Microsoft Office Pro Visio-Project Pro 2016 x64 Thai-English
Assistir ? Episodio 02
Sam Greco
Read more
1x02 A Star Is Torn free
► Regarder Californication Saison 4 Г©pisode 5 : Episode 5 gratuit en streaming HD & VO / VF / VOST / VOSTFR
Arturia V Collection 5 v5.3.0 (WiN)
Have I Got a Bit More News for You S53E08. revittony
RobertoWarez
BitLord.com
Lynda – Houdini: Advanced Motion Graphics
Lighters Bad Meets Evil Mp3
lagu dangdut koplo cinta merah jambu download
Zobrazit posledny prispevok
Packt.-.Go.Building.Web.Applications.2016.RETAiL.ePUB.eBOOK-DiSTRiBUTiON[xwarez].torrent [Isohunt.to]
Alcaldesa 2016 hd pelicula .avi
Too Young To Die! (2016)
Scream Queens
The Magnificent Seven (2016) Bluray 720p + Indo Subtitle
Sperling
Microsoft Office Pro Visio-Project Pro 2016 x64 Thai-English
Assistir ? Episodio 02
Sam Greco
Read more
1x02 A Star Is Torn free
► Regarder Californication Saison 4 Г©pisode 5 : Episode 5 gratuit en streaming HD & VO / VF / VOST / VOSTFR
Arturia V Collection 5 v5.3.0 (WiN)
Have I Got a Bit More News for You S53E08. revittony
RobertoWarez
BitLord.com
#4
Escrito 21 julio 2017 - 12:05
Major Lazer - Too Original (feat. Elliphant & Jovi Rockwell) (Official Music Video)
Claude Barras
(ver pelculas)
PVRIS - Heaven (Official Music Video)
Ruler: Master of the Mask
Teen Wolf
Oyuncu Sitemap
office 2013
Series ...
Crash - Usher
Game of Thrones S07E01 WEBRip x264-RARBG
Six (season 1, 2)
Summerland
Banshee 3. Sezon 10. Bolum
Die Scharfschutzen
Party Legends S02E06 HDTV x264-YesTV[rarbg]
Обсуждение вышедших игр для РС
Kevin McNally
selena gomez
Az eroszak volgye Az eroszak volgye:Paul es kutyaja a mexikoi kihalt sivatagon vag keresztul, es eljutnak egy volgybeli varoskaba is. Egykoron itt a banyaszat miatt nyuzsgott az elet, de mostanra alig lakik valaki a telepulesen, es az eroszak lett az ur.
Telugu Movies
Aankhon Sey Mp3
4x07 Moving Targets free
Claude Barras
(ver pelculas)
PVRIS - Heaven (Official Music Video)
Ruler: Master of the Mask
Teen Wolf
Oyuncu Sitemap
office 2013
Series ...
Crash - Usher
Game of Thrones S07E01 WEBRip x264-RARBG
Six (season 1, 2)
Summerland
Banshee 3. Sezon 10. Bolum
Die Scharfschutzen
Party Legends S02E06 HDTV x264-YesTV[rarbg]
Обсуждение вышедших игр для РС
Kevin McNally
selena gomez
Az eroszak volgye Az eroszak volgye:Paul es kutyaja a mexikoi kihalt sivatagon vag keresztul, es eljutnak egy volgybeli varoskaba is. Egykoron itt a banyaszat miatt nyuzsgott az elet, de mostanra alig lakik valaki a telepulesen, es az eroszak lett az ur.
Telugu Movies
Aankhon Sey Mp3
4x07 Moving Targets free
0 usuarios están leyendo este tema
0 miembro/s, 0 invitado/s, 0 usuario/s anónimo/s