Druva Tables

Tables

DruvaInsyncCloudUsers

Name	Type	Description
UserID	integer	The unique id of the user in inSync.
UserName	string	The username of the user in inSync.
EmailID	string	The email address of the user.
Status	string	The status of the user account - either active or preserved.
ProfileID	integer	The profile ID of the profile associated with the user.
StorageID	integer	The storage ID of the storage associated with the user.
CacheID	integer	The CloudCache Server ID associated with the user.
Quota	string	The storage quota assigned to the user in inSync.
QuoataInBytes	integer	The storage quota assigned to the user (in bytes) in inSync.
AddedOn	datetime	The date on which the user was added in inSync.
PrivacySettingsEnabled	string	Displays the status of the privacy setting of the user. If the value returned is True, privacy setting is enabled by the user. If the value returned is False, privacy settings is not set or user has allowed admin access to their data.
IdapGUID	boolean	The AD or LDAP object GUID of the user in a hex string format.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaInsyncDevices

Name	Type	Description
DeviceID	integer	The unique id of the device in inSync.
DeviceName	string	The device name in inSync.
SerialNumber	string	A unique, identifying number assigned to an individual piece of hardware by the manufacturer.
DeviceOS	string	The operating system of the device.
DeviceOSVersion	string	The version of the operating system of the device.
PlatformOS	string	The operating system platform of the device. Options: `win32`, `linux2`, `android`, `ios`
UUID	string	A 128-bit number used to uniquely identify device in internet.
ClientVersion	string	The inSync Client version installed on the device.
DeviceStatus	string	The status of the device - either enabled or disabled.
UpgradeStatus	string	The upgrade state of the device. Options: `NOT UPGRADABLE`, `UPGRADABLE`, `UPTODATE`, `SCHEDULED`, `UNKNOWN`
UserID	integer	A unique id of the user in inSync.
TotalBackupData	string	The storage quota consumbed by the user.
TotalBackupDataInBytes	integer	The storage quota consumbed by the user.
AddedOn	Datetime	The date and time on which the device was added to inSync.
LastUpgradedOn	datetime	The date on which the inSync Client was last updated for the user.
LastConnected	datetime	The date and time on which the inSync Client last connected with inSync Cloud.
DeviceMarkedInactive	boolean	Devices marked as inactive.
DisabledMode	string	The mode via which the device was disabled. Options: `Manual`, `API`, `User Preserved`, `Decommission`
DisabledOn	datetime	The date and time when the device was disabled.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaInsyncEndpointBackups

Name	Type	Description
DeviceID	integer	It is unique positive integer id associated with device.
BackupStatus	string	Backup status of the device.
FilesBackedUp	integer	The number of files backed up in the last successful backup.
BytesTransferred	integer	The number of bytes transferred in the last successful backup.
FilesMissed	integer	The number of files missed on the device in the last successful backup.
SnapshotSize	string	The size of the snapshot generated in the last successsful backup in MBs.
StartTime	datetime	The start time of the last successfuly backup.
EndTime	datetime	The end time of the last successful backup.
SystemSettingsBackedUp	boolean	Specifies whether the system settings were backed up as part of the backup.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DurvaInsyncRestoreActivities

Name	Type	Description
DeviceID	integer	The unique ID of the device from which the restore activity was triggered.
TargetDeviceID	integer	The device ID of the device to which the data was restored.
RestoreLocation	string	The location on the device to which the data was restored. The possible locations are: Original (If the data was restored to the original location); Desktop (If the data was restored to desktop); Custom location (If data was restored to a custom location); Unknown (If the restore was performed from a mobile device to a mobile device).
UserID	integer	The unique ID of the user who triggered the restore activity.
RestoreID	integer	The unique ID of the restore activity. This value is 'null' in case of restore was initiated from a mobile device.
StartTime	datetime	The start time of the restore activity.
EndTime	datetime	The end time of the restore activity. This value is empty if the restore activity is ongoing.
Status	string	Status of the restore activity. Options: `Successful`: If the restore activity was completed successfully; `Ongoing`: If the restore activity is ongoing; `Failed`: If the restore activity was failed; `Cancelled`: If the restore activity was cancelled manually; `Completed with Errors`: If some files were missed during the restore activity.
RestoreSize	string	This value is 'Unknown' for restores that failed to start.
NumberOfFilesRestored	integer	The total number of files that were restored in the restore activity.
NumberOfFilesMissed	integer	The total number of files that were missed from the restore activity.
RestoreMode	string	The persona who initiated the restore. Personas are: Self: inSync user himself; Admin: Administrator.
SystemSettingsRestore	boolean	This returns 'true' if system setting were restored else returns 'false'.
FailureReason	string	This returns the failure reason if the status is 'failed' else returns 'empty.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaInsyncStorages

Name	Type	Description
StorageID	integer	The unique identifier of the storage in Druva inSync.
StorageName	string	The name of the storage in Druva inSync.
StorageUsage	string	The storage space consumed on the storage.
TotalSyzeOfBackedUpFiles	string	The total size of the files backed up on this storage.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaEnterpriseWorkloadAlerts

Name	Type	Description
ID	integer	Alert ID.
Type	string	Alert type, for example, jobs, storage, and cloudcache.
Subtype	string	Alert subtype, for example, backupFailures, and restoreFailures.
GeneratedOn	string	Alert generation timestamp. The format is YYYY-MM-DDTHH:MM:SSZ.
OrgID	integer	Organization ID.
WorkloadType	string	Type of the workload. The value can be fs, sql, nas, vmware, hyperv, or oracle.
TargetID	string	Target ID of the alert. In the case of job alerts, targetID is same as the jobID of the job.
ResourceType	integer	Type of resource. The value can be `physicalServer`, `vmwareVM`, `hyperVM`, `nasShare`, `sqlAvailabilityGroup`, `sqlStandaloneInstance`, or `oracle`.
ResourceName	string	Name of the resource.
Status	string	The status of the alert. The value can be resolved or active.
ResolutionTime	string	Alert resolution timestamp. The format is YYYY-MM-DDTHH:MM:SSZ.
Severity	string	Severity of the alert. The value can be `critical`, `warning`, or `info`.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaPlatformAdminLogEvents

Name	Type	Description
AdminName	string	Name of the administrator.
IPAddress	string	IP address of the administrator.
Location	string	The location of the administrator.
LoginResult	string	The result of the login attempt.
LoginTime	datetime	The time of the login attempt.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

DruvaInsyncEvents

Name	Type	Description
EventID	bigint	The unique id of the event in inSync.
Initiator	string	The initiator of the event. In case of a user generated event or an administrator generated event the corresponding email address is displayed. In case of System event, the initiator will always be the name of the system.
InSyncDataSourceID	integer	The inSync assigned identifier of the user device on which the event occurred.
InSyncDataSourceName	string	The device name on which the event occurred.
ClientVersion	string	The inSync Client version on the user device.
ClientOS	string	The OS on which the inSync Client is installed.
InSyncUserID	integer	inSync assigned identifier of the user associated with the event.
InSyncUserName	string	The name of the inSync user associated with the event.
InSyncUserEmail	string	The email of the inSync user associated with the event.
ProfileID	string	inSync assigned identifier of the inSync profile to which the user, associated with the occurred event is linked to.
ProfileName	string	The name of the inSync profile to which the user, associated with the occurred event is linked to.
EventType	string	Type of event.
EventState	string	State of event.
TimeStamp	datetime	The date and time when the event was generated. Format - YYYY-MM-DDTHH:MM:SSZ
Severity	integer	The severity level of the event as defined in Druva inSync.
Ip	string	The IP address of the device on which the event occurred. In case of an admin event, IP address of the device on which the administrator logged on to perform inSync activity is displayed.
Facility	integer	The facility number as defined in inSync Management Console Events API settings. Default value is 23.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.
EventDetails	string	Displays the details of multiple events within a single activity. For instance, a backup activity provides details such as the number of files backed up, number of files missed, total time taken for the backup activity. And for auto-delete user or user device, it provides the userIdentifierCustomAttribute and userIdentifierCustomAttributeValue, if the User-Identifier Custom Attribute feature is enabled for the account and the administrator has opted to display it on the inSync UI.

Tables

DruvaInsyncCloudUsers

DruvaInsyncDevices

DruvaInsyncEndpointBackups

DurvaInsyncRestoreActivities

DruvaInsyncStorages

DruvaEnterpriseWorkloadAlerts

DruvaPlatformAdminLogEvents

DruvaInsyncEvents

Learn more...