1
00:00:00,450 --> 00:00:08,070
So now will create a table that uses the information from these drop downs Kyprianou panel to choose

2
00:00:08,070 --> 00:00:09,370
a visualization.

3
00:00:09,780 --> 00:00:12,490
It's going to be a table go into queries.

4
00:00:12,510 --> 00:00:15,120
Now I want to select Influx DBE.

5
00:00:16,140 --> 00:00:22,170
And I'm going to select interface where ancient host.

6
00:00:24,030 --> 00:00:31,070
ECLSS host, that is the dashboard variable we recreated already and noticed this little tilt there,

7
00:00:31,350 --> 00:00:38,700
that means it's now using a rejects, whereas there that's just Nagle's saw and put that back.

8
00:00:39,270 --> 00:00:40,920
OK, so let's continue.

9
00:00:41,220 --> 00:00:43,230
My format is going to be table.

10
00:00:43,320 --> 00:00:48,480
My first selection is going to be operational status.

11
00:00:48,760 --> 00:00:50,040
I'm going to get rid of that.

12
00:00:50,230 --> 00:00:55,410
I'm going to use the last value.

13
00:00:55,530 --> 00:01:04,769
And I'm also going to change the ileus column header here to be operational.

14
00:01:06,420 --> 00:01:07,620
Status.

15
00:01:08,930 --> 00:01:18,530
So I'm going to remove these group boys because there are many rows I want one row interface group by

16
00:01:18,530 --> 00:01:19,490
description.

17
00:01:21,890 --> 00:01:24,290
And limit.

18
00:01:27,400 --> 00:01:28,150
One.

19
00:01:31,220 --> 00:01:33,060
It gets one row per.

20
00:01:34,140 --> 00:01:35,160
Interface.

21
00:01:37,560 --> 00:01:38,280
Here we go.

22
00:01:38,910 --> 00:01:41,670
When I change the host, we get different information.

23
00:01:42,750 --> 00:01:44,100
Save the progress.

24
00:01:46,110 --> 00:01:54,450
And add some more columns, add a field for if interface discards.

25
00:01:55,860 --> 00:02:04,050
It would go remove that one or another one beats face errors and errors to add another one.

26
00:02:05,520 --> 00:02:06,720
You know, that's.

27
00:02:08,580 --> 00:02:18,990
Unicast packets empty, you look out, discards out, errors, interface speed, also the physical address

28
00:02:19,140 --> 00:02:22,650
and last change, it says a lot of information.

29
00:02:22,650 --> 00:02:24,120
They now say that.

30
00:02:25,720 --> 00:02:26,530
Prevue.

31
00:02:31,340 --> 00:02:32,810
So change the host.

32
00:02:33,020 --> 00:02:33,620
There we go.

33
00:02:34,010 --> 00:02:36,920
Okay, so let's just add some formatting to this table.

34
00:02:37,160 --> 00:02:38,810
Let's go into edited.

35
00:02:38,930 --> 00:02:40,820
The title is going to be Interface Summary.

36
00:02:41,980 --> 00:02:46,600
The visualisations going to remove all existing rules.

37
00:02:49,220 --> 00:02:50,960
I want to remove the time column.

38
00:02:53,780 --> 00:02:58,290
Are hidden, and that will be time and time is gone.

39
00:02:58,980 --> 00:03:04,290
I also want to highlight operational status, whether up or down, so.

40
00:03:05,230 --> 00:03:06,250
So choose one.

41
00:03:06,280 --> 00:03:09,740
So one means up and two means down.

42
00:03:10,240 --> 00:03:21,220
So it's quite a new rule type will be string o, apply it to the operational status column and the value

43
00:03:21,940 --> 00:03:23,380
one will be up.

44
00:03:25,350 --> 00:03:27,420
And two will be down.

45
00:03:29,620 --> 00:03:38,230
OK, so good, they're up and down also, Colacello, so threshold one to sell.

46
00:03:40,030 --> 00:03:43,500
So and the callers I want.

47
00:03:45,190 --> 00:03:46,450
That to be read.

48
00:03:48,970 --> 00:03:51,070
And I went up to be green.

49
00:03:52,600 --> 00:03:53,320
Excellent.

50
00:03:53,630 --> 00:03:56,770
I can see now I can change the filters.

51
00:03:59,280 --> 00:04:01,480
OK, so I'm getting some missing data.

52
00:04:02,040 --> 00:04:06,480
Let's see, see, I just got to fix this.

53
00:04:09,060 --> 00:04:12,540
Lost and then ileus.

54
00:04:15,080 --> 00:04:18,800
Operational status, if I say sailor.

55
00:04:20,339 --> 00:04:20,820
Excellent.

56
00:04:20,850 --> 00:04:24,030
Now let's preview a very good.

57
00:04:29,070 --> 00:04:30,540
That's a very nice table.