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.