Sophos Reporting Interface data sources

These data sources are available for Sophos Reporting Interface. Each data source is listed with its data fields and data types.

The following data sources are available for Reporting Interface.

Letter of the alphabet listed beside a data source is used to represent the data source in the matrix below.

A. vComputerHostData

B. vThreatInstances

C. vEventsCommonData

D. vEventsApplicationControlData

E. vEventsDataControlData

F. vEventsDeviceControlData

G. vEventsFirewallData

H. vEventsTamperProtectionData

I. vEventsWebData

J. vThreatEventData

K. vComputerGroupMapping

L. vGroupPathAndNameData

M. vComputerPackageMapping

N. vPackageData

O. vPolicyComplianceData

P. vComputerStatusData

The following matrix shows which data fields are available in which data sources. All date-time columns are returned in UTC in the format "yyyy-mm-dd hh:mi:ss" (24 hours).


	Data source
Data field Data type	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
`EventID` `integer`			•	•	•	•	•	•	•	•
`ThreatID` `integer`		•								•
`ComputerID` `integer`	•	•	•	•	•	•	•	•	•		•		•		•	•
`Name` `nvarchar`	•		•	•	•	•	•	•	•
`EventTime` `datetime`			•	•	•	•	•	•	•	•
`EventTypeID` `integer`			•	•	•	•	•	•	•	•
`EventTypeName` `nvarchar`			•	•	•	•	•	•	•	•
`ReportingName` `nvarchar`			•	•	•	•	•	•	•	•
`UserName` `nvarchar`			•	•	•	•	•	•	•	•	•
`ActionID` `integer`			•	•	•	•	•	•	•	•
`ActionName` `nvarchar`			•	•	•	•	•	•	•	•
`ScanTypeID` `integer`			•	•
`ScanTypeName` `nvarchar`			•	•
`SubTypeID` `integer`			•	•		•	•	•	•
`SubTypeName` `nvarchar`			•	•		•	•	•	•
`InsertedAt` `datetime`		•	•	•	•	•	•	•	•	•
`Domain` `nvarchar`	•
`IPAddress` `nvarchar`	•
`Description` `nvarchar`	•
`LastMessageReceivedTime` `nvarchar`	•
`DNSName` `nvarchar`	•
`OperatingSystemID` `integer`	•
`OperatingSystemName` `nvarchar`	•
`ServicePack` `nvarchar`	•
`ThreatTypeID` `integer`		•
`ThreatTypeName` `nvarchar`		•
`ThreatSubTypeID` `integer`		•
`ThreatSubTypeName` `nvarchar`		•
`Priority` `integer`		•
`ThreatName` `nvarchar`		•
`FullFilePath` `nvarchar`		•
`FileVersion` `nvarchar`		•
`CheckSum` `nvarchar`		•
`FirstDetectedAt` `datetime`		•
`RuleName` `nvarchar`					•
`TrueFileType` `nvarchar`					•
`DestinationPath` `nvarchar`					•
`DestinationTypeID` `integer`					•
`DestinationTypeName` `nvarchar`					•
`SourcePath` `nvarchar`					•
`FileName` `nvarchar`					•
`DestinationValue` `nvarchar`					•
`FileSize` `long`					•
`DeviceTypeID` `integer`							•
`DeviceTypeName` `nvarchar`							•
`Model` `nvarchar`							•
`DeviceID` `integer`							•
`Role` `nvarchar`								•
`FileName` `nvarchar`								•
`FilePath` `nvarchar`								•
`FileVersion` `nvarchar`								•
`FileChecksum` `nvarchar`								•
`CommandLine` `nvarchar`								•
`Session` `nvarchar`								•
`Desktop` `nvarchar`								•
`Location` `nvarchar`								•
`ProtocolID` `integer`								•
`ProtocolText` `nvarchar`								•
`DirectionID` `integer`								•
`DirectionText` `nvarchar`								•
`LocalAddress` `nvarchar`								•
`RemoteAddress` `nvarchar`								•
`LocalPort` `integer`								•
`RemotePort` `integer`								•
`TargetTypeID` `integer`									•
`TargetTypeText` `nvarchar`									•
`Target` `nvarchar`									•
`RuleID` `integer`									•
`BlockedSite` `nvarchar`										•
`ReferringURL` `nvarchar`										•
`ReasonID` `integer`										•
`ReasonName` `nvarchar`										•
`CategoryID` `integer`										•
`CategoryName` `nvarchar`										•
`ActionTakenID` `integer`											•
`ActionTakenName` `nvarchar`											•
`ScannerTypeID` `integer`											•
`ScannerTypeName` `nvarchar`											•
`StatusID` `integer`											•
`StatusName` `nvarchar`											•
`GroupID` `integer`												•	•
`PathAndName` `nvarchar`													•
`Depth` `integer`													•
`PackageID` `integer`														•	•
`Product` `nvarchar`															•
`SAVVersion` `nvarchar`															•
`EngineVersion` `nvarchar`															•
`VirusDataVersion` `nvarchar`															•
`ExpiryTime` `datetime`															•
`NotificationTime` `datetime`															•
`Expired` `bit`															•
`PolicyTypeID` `integer`															•
`PolicyTypeName` `nvarchar`															•
`ComplianceID` `integer`															•
`ComplianceName` `nvarchar`															•
`Connected` `bit`																•
`Managed` `bit`																•
`OnAccessState` `bit`																•
`TamperProtectionState` `bit`																•
`SedState` `integer`																•
`HmpaState` `integer`																•
`PatchState` `bit`																•
`FirewallState` `integer`																•
`AppControlState` `bit`																•
`DeviceControlState` `bit`																•
`WebControlState` `bit`																•

Sophos Reporting Interface data sources

Machine translation disclaimer