how do I make sure that all alerts on a specific server/object (one to several servers) in the alert tile is displayed?
Hi MHW
Perhaps I don´t understand the question correctly.
You create an Alert Tile - List and in the scope you define which objects should be displayed.
Hi Tom79
Thanks for your reply.
It’s because I have experienced that when I select the individual object in the alert tile, all alerts do not appear in the list.
I have therefore made a SQL query from the Operations Manager database, where I must define the following, in order to display all alerts for a specific object:
MonitoringObjectPath LIKE ‘Server1%’ OR MonitoringObjectDisplayName LIKE ‘Server1%’
I have just checked it.
The following SQL query:
SELECT TOP (1000) [Name]
,[MonitoringObjectDisplayName]
,[MonitoringObjectName]
,[MonitoringObjectPath]
,[MonitoringObjectFullName]
,[IsMonitorAlert]
,[ResolutionState]
,[Priority]
,[Severity]
,[Category]
,[Owner]
,[ResolvedBy]
,[TimeRaised]
,[TimeAdded]
,[LastModified]
,[LastModifiedBy]
,[TimeResolved]
,[TimeResolutionStateLastModified]
,[StateLastModified]
,[RepeatCount]
,[AlertStringName]
,[AlertStringDescription]
,[AlertParams]
FROM [OperationsManager].[dbo].[AlertView]
Then the comparison with the alerts that are displayed in SquaredUp.
Yes, there is a discrepancy. However, if I filter out the alerts that are already resolved in the query, then the number is correct.
That means SquaredUp actually shows all active alerts, not those that have already been resolved.
One way to get Alerts in all states is to edit the Alert tile JSON…
…and replace the states property with this:
"states": [
"0",
"1",
"2",
"3",
"4",
"5",
"6",
"7",
"8",
"9",
"10",
"11",
"12",
"13",
"14",
"15",
"16",
"17",
"18",
"19",
"20",
"21",
"22",
"23",
"24",
"25",
"26",
"27",
"28",
"29",
"30",
"31",
"32",
"33",
"34",
"35",
"36",
"37",
"38",
"39",
"40",
"41",
"42",
"43",
"44",
"45",
"46",
"47",
"48",
"49",
"50",
"51",
"52",
"53",
"54",
"55",
"56",
"57",
"58",
"59",
"60",
"61",
"62",
"63",
"64",
"65",
"66",
"67",
"68",
"69",
"70",
"71",
"72",
"73",
"74",
"75",
"76",
"77",
"78",
"79",
"80",
"81",
"82",
"83",
"84",
"85",
"86",
"87",
"88",
"89",
"90",
"91",
"92",
"93",
"94",
"95",
"96",
"97",
"98",
"99",
"100",
"101",
"102",
"103",
"104",
"105",
"106",
"107",
"108",
"109",
"110",
"111",
"112",
"113",
"114",
"115",
"116",
"117",
"118",
"119",
"120",
"121",
"122",
"123",
"124",
"125",
"126",
"127",
"128",
"129",
"130",
"131",
"132",
"133",
"134",
"135",
"136",
"137",
"138",
"139",
"140",
"141",
"142",
"143",
"144",
"145",
"146",
"147",
"148",
"149",
"150",
"151",
"152",
"153",
"154",
"155",
"156",
"157",
"158",
"159",
"160",
"161",
"162",
"163",
"164",
"165",
"166",
"167",
"168",
"169",
"170",
"171",
"172",
"173",
"174",
"175",
"176",
"177",
"178",
"179",
"180",
"181",
"182",
"183",
"184",
"185",
"186",
"187",
"188",
"189",
"190",
"191",
"192",
"193",
"194",
"195",
"196",
"197",
"198",
"199",
"200",
"201",
"202",
"203",
"204",
"205",
"206",
"207",
"208",
"209",
"210",
"211",
"212",
"213",
"214",
"215",
"216",
"217",
"218",
"219",
"220",
"221",
"222",
"223",
"224",
"225",
"226",
"227",
"228",
"229",
"230",
"231",
"232",
"233",
"234",
"235",
"236",
"237",
"238",
"239",
"240",
"241",
"242",
"243",
"244",
"245",
"246",
"247",
"248",
"249",
"250",
"251",
"252",
"253",
"254",
"255"
]
After clicking the Apply Changes button on the JSON editor it should show you active and closed alerts.
