ExFileInstanceGroups

The ExFileInstanceGroups view provides access to the metadata for file instance groups found on your computers.

File instance groups are groups of files associated with one primary root file, usually their installer but sometimes a file from which they were copied.

Table 1. ExFileInstanceGroups

Field Name	Data Type	Special Values	Comments
File_Instance_Group_Id	Int		Primary Key
File_Catalog_Id	Int		Foreign key into ExFileCatalog table for details about root file of this group
Computer_Id	Int		Foreign key into ExComputers table for computer that has this file group
Date_Created	datetime		Date and time (UTC) when this file group was created
Group_Type	int	0 – initialized file 1 – top-level file 2 – file installed by process 3 – file installed by installer and can be found in Add/Remove Programs	How the group was identified by App Control
Path_Name	nvarchar		Path that corresponds to the root file of this group. Paths use the OS-specific delimiter for the agent on which the file is located.
User_Name	nvarchar		User that created this group
File_Name	nvarchar		File name that corresponds to the root file of this group
Installed_Program_Name	nvarchar		If this file was an installer, this will be the installation name
Initialized	varchar	Yes, No	Yes if the files in this group were found during initialization
Top_Level	varchar	Yes, No	Yes if this group represents a top-level file that was not generated through an installer. No if files in this group were part of an installation.