Support Center

Automatic Collections and Alerts

Last Updated: Aug 03, 2016 12:12PM CDT

Minion Enterprise gathers data from all managed servers into tables in the Collector schema. The moment you configure an instance in the dbo.Servers table, Minion Enterprise begins pulling in a stunning array of service status, disk space, backups, database properties, logins and users, table sizes, and on and on. All of this data from across your enterprise is now updated and available in one central repository, ready for alerts, and reporting, and planning for the future.

Collections

Like we said in the Quick Tour of the Modules, Minion Enterprise gathers data from all managed servers into tables in the Collector schema. It does this via a set of jobs that come pre-configured when you install ME.
Note that each collector is divided into one or more jobs based on SLA. GOLD level servers receive all of the collctions; and, collections run the most frequently for GOLD level servers. Collectors run less frequently for SILVER servers, and less frequently (or not at all) for BRONZE.
Module JobName Occurs Frequency
Database CollectorDBFilePropertiesGet-GOLD Every 1 day Every 2 Hours between 00:00:00 and 23:59:59
Database CollectorDBFilePropertiesGet-SILVER Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
Database CollectorDBFilePropertiesGet-BRONZE Every 1 day Once at 00:00:00
Database CollectorDBScript-GOLD Every 1 day Once at 01:00:00
Database CollectorDBScript-SILVER Every 3 days Once at 09:00:00
Database CollectorDBScript-BRONZE Every 4 weeks on Sunday Once at 07:00:00
Database CollectorDBUsersGet-GOLD Every 1 day Once at 01:00:00
Database CollectorDBUsersGet-SILVER Every 1 week on Monday, Wednesday, Friday Once at 03:00:00
Database CollectorDBUsersGet-BRONZE Every 1 week on Sunday Once at 03:00:00
Database CollectorIndexStats-GOLD Every 1 week on Saturday Once at 07:00:00
Database CollectorIndexStats-SILVER Every 2 weeks on Sunday Once at 07:00:00
Database CollectorIndexStats-BRONZE Every 4 weeks on Sunday Once at 07:00:00
Database CollectorSysObjectsGet-GOLD Every 1 day Once at 00:00:00
Database CollectorSysObjectsGet-SILVER Every 1 week on Sunday Once at 03:00:00
Database CollectorSysObjectsGet-BRONZE Every 2 weeks on Sunday Once at 00:00:00
Database CollectorTableColumns-GOLD Every 1 day Every 6 Hours between 00:00:00 and 23:59:59
Database CollectorTableColumns-SILVER Every 1 day Once at 21:00:00
Database CollectorTableColumns-BRONZE Every 1 week on Saturday Once at 21:00:00
Database CollectorTableProperties-GOLD Every 1 day Once at 03:00:00
Database CollectorTableProperties-SILVER Every 1 week on Sunday Once at 03:00:00
Database CollectorTableProperties-BRONZE Day 1 of every 1 months Once at 00:00:00
Drive CollectorDriveSpace-GOLD Every 1 day Every 15 Minutes between 00:00:00 and 23:59:59
Drive CollectorDriveSpace-SILVER Every 1 day Every 4 Hours between 00:00:00 and 23:59:59
Drive CollectorDriveSpace-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
Security CollectorADGroupsGet Every 1 week on Sunday Once at 03:00:00
Security CollectorLoginsGet-GOLD Every 1 day Every 6 Hours between 00:00:00 and 23:59:59
Security CollectorLoginsGet-SILVER Every 1 day Once at 05:00:00
Security CollectorLoginsGet-BRONZE Every 1 week on Sunday Once at 03:00:00
Server CollectorOSDetailsGet-GOLD Every 1 day Every 30 Minutes between 00:00:00 and 23:59:59
Server CollectorOSDetailsGet-SILVER Every 1 day Every 4 Hours between 07:00:00 and 16:00:59
Server CollectorOSDetailsGet-BRONZE Every 1 day Once at 11:00:00
Server CollectorServerInfoGet-GOLD Every 1 day Once at 00:00:00
Server CollectorServerInfoGet-SILVER Every 3 days Once at 09:00:00
Server CollectorServerInfoGet-BRONZE Every 1 week on Sunday Once at 03:00:00
Server CollectorServicePropertiesGet-GOLD Every 1 day Every 15 Minutes between 00:00:00 and 23:59:59
Server CollectorServicePropertiesGet-SILVER Every 1 day Every 6 Hours between 00:00:00 and 23:59:59
Server CollectorServicePropertiesGet-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
Server CollectorSMBShare-GOLD Every 1 day Once at 01:00:00
Server CollectorSMBShare-SILVER Every 1 week on Saturday Once at 02:00:00
Server CollectorSMBShare-BRONZE Day 1 of every 1 months Once at 00:00:00
SQL Server CollectorErrorLog-GOLD Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
SQL Server CollectorErrorLog-SILVER Every 1 day Once at 23:00:00
SQL Server CollectorErrorLog-BRONZE Every 1 week on Sunday Every 48 Hours between 00:00:00 and 23:59:59
SQL Server CollectorInstanceConfigGet-GOLD Every 1 day Every 15 Minutes between 00:00:00 and 23:59:59
SQL Server CollectorInstanceConfigGet-SILVER Every 1 day Every 1 Hours between 00:00:00 and 23:59:59
SQL Server CollectorInstanceConfigGet-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
SQL Server CollectorSQLJobScript-GOLD Every 1 day Once at 01:00:00
SQL Server CollectorSQLJobScript-SILVER Every 3 days Once at 09:00:00
SQL Server CollectorSQLJobScript-BRONZE Every 4 weeks on Sunday Once at 07:00:00
SQL Server CollectorWaitStatsGet-GOLD Every 1 day Every 30 Minutes between 00:00:00 and 23:59:59
SQL Server CollectorWaitStatsGet-SILVER Every 1 day Every 4 Hours between 00:00:00 and 23:59:59
SQL Server CollectorWaitStatsGet-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59

Alerts

As you become familiar with Minion Enterprise, we recommend you adjust existing alerts, and create new alerts, to suit your particular enterprise. ME is meant to be highly customizable, which is why all of the collected data is stored accessibly in SQL Server tables.

Two of the default alert types are disk space usage, and backups. When you first install Minion Enterprise, you might start receiving (for example) disk space alerts if you have some disks that are running low on free space. You have several options for handling these alerts: 

Fix the problem, if there is one.

Change the drive space alert threshold, if the drive in question is a known issue:
EXEC Setup.DiskSpaceThreshold
@ServerName = 'MyServer',
@DriveName = 'C:\',
@AlertMethod = 'Percent',
@AlertValue = 15;
Exclude the drive from alerting, if the drive isn’t your responsibility or should otherwise not be alerted on:
EXEC Setup.DiskSpaceException
@ServerName = 'MyServer',
@DriveName = 'C:\';
Defer the drive in question from alerts for a specific period of time, if the resolution is coming (and you don’t want alerts in the meantime):
EXEC Setup.DiskSpaceDefer
@ServerName = 'MyServer',
@DriveName = 'C:\',
@DeferDate = '08/20/2015',
@DeferEndDate = '08/20/2015',
@DeferEndTime = '06:00';
You can perform similar actions for backup alerts using the stored procedures Setup.BackupDefer,
Setup.BackupReportThreshold, and Setup.BackupReportException.
Here are the alerts that ship automatically with Minion Enterprise, and their schedules: 
 
Module JobName Occurs Frequency
Backup AlertBackupsMissingDiff-GOLD Every 1 day Every 1 Hours between 08:00:00 and 17:00:00
Backup AlertBackupsMissingDiff-SILVER Every 1 day Every 6 Hours between 08:00:00 and 17:00:00
Backup AlertBackupsMissingDiff-BRONZE Every 1 day Once at 11:00:00
Backup AlertBackupsMissingFull-GOLD Every 1 day Every 1 Hours between 08:00:00 and 17:00:00
Backup AlertBackupsMissingFull-SILVER Every 1 day Every 6 Hours between 08:00:00 and 17:00:00
Backup AlertBackupsMissingFull-BRONZE Every 1 day Once at 11:00:00
Backup AlertBackupsMissingLog-GOLD Every 1 day Every 15 Minutes between 00:00:00 and 23:59:59
Backup AlertBackupsMissingLog-SILVER Every 1 day Every 4 Hours between 00:00:00 and 23:59:59
Backup AlertBackupsMissingLog-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
Database AlertDBsNewRetired-GOLD Every 1 day Once at 09:00:00
Database AlertDBsNewRetired-SILVER Every 3 days Once at 09:00:00
Database AlertDBsNewRetired-BRONZE Every 1 week on Monday Once at 09:00:00
Drive AlertDriveSpace-GOLD Every 1 day Every 30 Minutes between 00:00:00 and 23:59:59
Drive AlertDriveSpace-SILVER Every 1 day Every 4 Hours between 07:00:00 and 16:00:59
Drive AlertDriveSpace-BRONZE Every 1 day Once at 07:00:00
Server AlertInstanceConfig-GOLD Every 1 day Every 10 Minutes between 00:00:00 and 23:59:59
Server AlertInstanceConfig-SILVER Every 1 day Every 1 Hours between 00:00:00 and 23:59:59
Server AlertInstanceConfig-BRONZE Every 1 day Once at 08:00:00
Server AlertServiceStatus-GOLD Every 1 day Every 15 Minutes between 00:00:00 and 23:59:59
Server AlertServiceStatus-SILVER Every 1 day Every 4 Hours between 00:00:00 and 23:59:59
Server AlertServiceStatus-BRONZE Every 1 day Every 12 Hours between 00:00:00 and 23:59:59
Security AlertWeakSQLPasswords Every 1 week on Monday Once at 10:00:00
556ca399015f31edc97a62de2771be1a@minionware.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete