Jump to content
Jagjeet

Remote Monitoring Overview

Recommended Posts

Hi,

 

I have created a Dataview that might find it useful while viewing remote monitoring configuration on groups.

 

 

 

 

INSERT INTO `labtech`.`dataviewfolders`	(`FolderID`, `Name`)VALUES('12001','Overviews', );

insert into `labtech`.`dataviews` (`Name`, `FieldList`, `ColumnList`, `HiddenList`, `SQLBody`, `IDColumn`, `SQLWhere`, `FolderID`, `ClientLink`, `ComputerLink`, `SortField`, `GroupField`, `SortOrder`, `FilterControl`, `FormatControl`, `LocationLink`, `IconControl`, `SystemPermission`, `UserClassName`, `GUID`, `SystemPermissionHigh`) values('Remote Monitoring Overview','`mastergroups`.`GroupID`,\r\n`mastergroups`.`FullName` as `Group Full Name`,\r\n`mastergroups`.`Name` as `Group`,\r\n`groupagents`.`Name` as `Remote Monitor`,\r\n`groupagents`.`What` as `Remote Type`,\r\n`sensorchecks`.`SensID` as `SearchID`,\r\n`sensorchecks`.`Name`  as `Search`,\r\n`alerttemplate`.`AlertActionID` as `Alert TemplateID`,\r\n`alerttemplate`.`Name` as `Alert Template`','GroupID,Group Full Name,Group,Remote Monitor,SearchID,Search,Alert TemplateID,Alert Template,Remote Type','','FROM (((`groupagents` JOIN `mastergroups` ON ((`groupagents`.`GroupID` = `mastergroups`.`GroupID`))) JOIN `sensorchecks` ON ((`sensorchecks`.`SensID` = `groupagents`.`SearchID`))) JOIN `alerttemplate` ON ((`alerttemplate`.`AlertActionID` = `groupagents`.`AlertAction`)))','mastergroups.GroupID','','12001','','','','','0','','','','107|','0','','','0');

 

Installation Instructions

 

1. Download the SQL File linked above

2. Open your preferred SQL interfaces (SQLYog, HeidiSQL, etc).

3. Copy Sql query and execute it against labtech database.

4. The Dataview will be available under Navigation Tree -> Operations -> Dataviews -> Overviews -> Remote Monitoring Overview

remotemonitoring.PNG.035e3de9cd92031f2de7625e1995c687.PNG

Share this post


Link to post
Share on other sites

Jagjeet,

 

This has been very useful in doing a high level overview to ensure I have things set. Great contribution. Thank you.

 

I think I will see about duplicating this for the benefit of review of internal monitors as well.

 

Jeff

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...