The ME Objects module collects sys.objects data from each database. This is extremely useful for determining when objects come and go from databases, and to investigate when an object might be missing from certain servers. Get the most recent collection from the Collector.SysObjectsCurrent view.

Note: The Objects Module does not collect data on system tables.
 

Tables

Collector.SysObjects

Stores the collections of database objects data.

Definitions for many of the Collector.TableProperties columns can be found in the MSDN article for sys.objects: https://msdn.microsoft.com/en-us/library/ms190324.aspx.

 
Column Type Description
ID bigint Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers.
DBName varchar Database name.
ObjectName varchar Object name.
ObjectId int Object ID.
ParentName sysname The object name of the current object’s parent. For example, a row for an index will have ParentName = the name of the owning table.
PrincipalId int The ID number of a principal in the specified database.
SchemaName sysname Schema name.
SchemaId int Schema ID.
ParentObjectId int The object ID of the current object’s parent.
Type char File type.
TypeDesc sysname Type description.
CreateDate datetime Date the object was created.
ModifyDate datetime Date the object was last modified.
IsMSShipped bit Denotes whether the object is a Microsoft-shipped object, or not.
IsPublished bit Denotes whether the object is published or not.
IsSchemaPublished bit Denotes whether only the schema of the object is published, or not.
 

Views

Collector.SysObjectsCurrent

Provides the most recent collection of database objects data.

Each “Current” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Descr
 

Collector.SysObjectsPrevious

Provides the next-to-most recent collection of database objects data.
Each “Previous” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
 
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Descr
 

Jobs

CollectorSysObjectsGet-GOLD

Calls the executable SysObjectsGET.exe for all servers with ServiceLevel = ‘Gold’, to retrieve database object information.
 

CollectorSysObjectsGet-SILVER

Calls the executable SysObjectsGET.exe for all servers with ServiceLevel = ‘Silver’, to retrieve database object information.
 

CollectorSysObjectsGet-BRONZE

Calls the executable SysObjectsGET.exe for all servers with ServiceLevel = ‘Bronze’, to retrieve database object information.
 

Executables

SysObjectsGET.exe

Performs the object data collection for the servers in the specified service level. Logs the results to Collector.SysObjects.

Input parameters:
  • $Query – This parameter refers to the service level that the collector should operate on. Examples: Gold, Silver, Bronze. For more information on this topic, see the article “Executables and Service Levels”.
Example execution:
C:\MinionByMidnightDBA\Collector\SysObjectsGET.exe Gold
 
 
https://minionware.desk.com/customer/portal/articles/2378909-objects-module
http://www.MinionWare.net
​