# Iceshrimp.NET Grafana Dashboard

## Introduction:

A selection of SQL scripts used in the Iceshrimp.NET Grafana Dashboard

This was very much used as a learning experience and as such may be considered a bit of a 'basic' implementation

I wanted my iceshrimp.NET dashboard to show the following:

### 00. Instance Info:

* Just a Header really

### 01. Overview:

* [Federated Instances]

	Total number of federated instances

* [Blocked Instances]

	Total number of blocked instances

* [Accounts]

	Total number of Accounts (includes the instance.actor)

* [Notes]

	Total number of Notes

* [Blocked Accounts]

	(Total number of blocked Accounts that fall outside of blocked Instances

* [Muted Accounts]

	Total number of muted Accounts

### 02. Jobs:

* [Job Queue by Status]

	Current status of Notes (jobs) being processed

### 03. Notes:

* [Notes Processed by Instance]

	Shows the total number of Notes processed by Instance (i.e. which Instance posted the most Notes)

* [Notes Processed by Account and Instance]

	Shows the total number of Notes processed by Account and Instance (i.e. which single Account posted the most Notes per Instance)

### 04. Sessions:

* [Active sessions by Account and App]

	Shows the currently authorised (App) sessions by Account

* [Active sessions by Account and OAuth Token]

	Shows the currently authorised (OAuth Token) sessions by Account

### 05. Misc:

* [Is Cat ?]

	Whether or not Accounts identify as a cat

* [Note Reactions]

	A list of posted Reactions, ranked by usage

##  Dashboard Snapshot:

The snapshot below is stripped of sensitive data like queries (metric, template and annotation) and panel links, leaving only the visible metric data and series names embedded into the dashboard.

[http://?/viz]