Hey.

Interested in what metrics from the database can be displayed in graphan for monitoring?

I found in the Kryon view sys.databases database in which there are fields with online, i.e. this is the real status of the database, which will change when

offline database?

Also interested in the number of connections to the database at the moment?

How much memory does the database need?

So far, I am just pulling out the following options on a dashboard: :Kryon]. .Dbo]. .LeoScriptsLibraries]

pKryon]. .Dbo]. .View_AutomationClients]

SELECT LeoUsers.UserName

, LeoUserRoles.HasStudioPermission

, LeoUserRoles.HasPlayerPermission

, LeoUserRoles.HasConsoleUserPermission

, LeoUserRoles.HasConsoleAdminPermission

, LeoUserRoles.HasUnattendedRobotPermission

, LeoUserRoles.HasAutomationApiPermission

 FROM RKryon]. nDbo]. oLeoUsers] INNER JOIN OKryon]. nDbo]. oLeoUserRoles]

 ON LeoUsers.UserID = LeoUserRoles.UserID

But this table is not informative with 0 and 1.

SELECT Count (UserName) as 'count_users'

 FROM >Kryon]. KDbo]. LeoUsers]