列举MOM所有报警的SQL查询语句
[color=green]该贴转自合作社区——[url=http://www.systemcenter.com.cn/bbs/]SC中文社区[/url]，请大家支持国内最专业的SystemCenter中文社区！[/color][color=green][/color]
[color=green]SQL Query:[/color]
[color=blue]Select[/color]
Comp[color=gray].[/color][color=blue]Name[/color][color=gray],[/color]
Alert[color=gray].[/color][color=blue]Name[/color][color=gray],[/color]
Alert[color=gray].[/color]Culprit[color=gray],[/color]
[color=red]'Alter Level'[/color] [color=gray]=[/color] [color=blue]Case[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 10 [color=blue]Then[/color] [color=red]'Success'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 1 [color=blue]Then[/color] [color=red]'Windows NT Workstation'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 20 [color=blue]Then[/color] [color=red]'Information'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 30 [color=blue]Then[/color] [color=red]'Warning'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 40 [color=blue]Then[/color] [color=red]'Error'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 50 [color=blue]Then[/color] [color=red]'Critical Error'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 60 [color=blue]Then[/color] [color=red]'Security Breach'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]AlertLevel [color=gray]=[/color] 70 [color=blue]Then[/color] [color=red]'Service Unavailable'[/color]
[color=blue]Else[/color] [color=red]'Undetermined'[/color]
[color=blue]End[/color][color=gray],[/color]
[color=red]'Resolution State'[/color] [color=gray]=[/color] [color=blue]Case[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 0 [color=blue]Then[/color] [color=red]'New'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 85 [color=blue]Then[/color] [color=red]'Acknowledged'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 170 [color=blue]Then[/color] [color=red]'Assigned to a help desk or local support'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 180 [color=blue]Then[/color] [color=red]'Assigned to a subject matter expert'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 190 [color=blue]Then[/color] [color=red]'Requires scheduled maintenance'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 200 [color=blue]Then[/color] [color=red]'Assigned to an external group or vendor'[/color]
[color=blue]When[/color] Alert[color=gray].[/color]ResolutionState [color=gray]=[/color] 255 [color=blue]Then[/color] [color=red]'Resolved'[/color]
[color=blue]Else[/color] [color=red]'Undetermined'[/color]
[color=blue]End[/color][color=gray],[/color]
Alert[color=gray].[/color]RepeatCount [color=red]'Alert Count'[/color][color=gray],[/color]
[color=fuchsia]Convert[/color][color=gray]([/color][color=blue]VarChar[/color][color=gray]([/color]10[color=gray]),[/color] Alert[color=gray].[/color]TimeRaised[color=gray],[/color] 101[color=gray])[/color]
[color=red]'Time Raised'[/color][color=gray],[/color]
[color=fuchsia]Convert[/color][color=gray]([/color][color=blue]VarChar[/color][color=gray]([/color]10[color=gray]),[/color] Alert[color=gray].[/color]TimeOfLastEvent[color=gray],[/color] 101[color=gray])[/color]
[color=red]'Last Event'[/color]
[color=blue]From[/color] Computer Comp
[color=gray]Join[/color] Alert [color=blue]on[/color] Comp[color=gray].[/color]IDComputer [color=gray]=[/color] Alert[color=gray].[/color]IDComputer
[color=blue]Order[/color] [color=blue]By[/color] Comp[color=gray].[/color][color=blue]Name[/color]
页:
[1]