Alphabetic Connector List > ServiceNow > Extracted Data

This section lists the tables and fields extracted by the License task type. Field names are provided in lowerCamelCase format as they appear in the output files.

sys_user

Field Name	Type
active	Boolean
email	String
firstName	String
lastLogin	String
lastLoginTime	String
lastName	String
name	String
roles	String
sysCreatedOn	String
sysId	String
sysUpdatedBy	String
sysUpdatedOn	String
userName	String
vip	Boolean
webServiceAccessOnly	Boolean

sys_user_has_license

Field Name	Type
active	Boolean
attributorId	String
entlSubscriptionMap	String
license	String
licenseDeleted	String
roles	String
source	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysModCount	Integer
sysTags	String
sysUpdatedBy	String
sysUpdatedOn	String
user	String

ua_app_usage

Field Name	Type
accessCount	Integer
appId	String
appName	String
appType	String
deleteCount	Integer
deleteOtherCount	Integer
deleteOwnCount	Integer
fulfillCount	Integer
insertCount	Integer
insertOtherCount	Integer
insertOwnCount	Integer
lineageId	String
produceCount	Integer
sysCreatedOn	String
sysId	String
sysModCount	Integer
timeStamp	String
updateCount	Integer
updateOtherCount	Integer
updateOwnCount	Integer
user	String

license_details

Field Name	Type
allocated	String
allocatedStatus	String
autoSync	Boolean
category	Integer
count	String
displayOnly	Boolean
endDate	String
expired	Boolean
isCapped	Boolean
lastAllocationCalOn	String
lastTablesUsedCalOn	String
licenseType	Integer
licenseWeight	Integer
measuredRoleTypes	String
name	String
productCode	String
productCost	Integer
quotaDefn	String
quotaDefnId	String
startDate	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysModCount	Integer
tableCount	String

license_has_app

Field Name	Type
app	String
license	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysModCount	Integer
sysTags	String
sysUpdatedBy	String
sysUpdatedOn	String

licensable_app

Field Name	Type
appFamilyId	String
appId	String
appName	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysModCount	Integer
sysTags	String
sysUpdatedBy	String
sysUpdatedOn	String

sys_user_has_role

Field Name	Type
inherited	String
role	String
state	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysUpdatedBy	String
sysUpdatedOn	String
user	String

sys_user_role

Field Name	Type
assignableBy	String
canDelegate	Boolean
description	String
elevatedPrivilege	Boolean
grantable	Boolean
includesRoles	String
name	String
requiresSubscription	String
scopedAdmin	Boolean
suffix	String
sysClassName	String
sysCreatedBy	String
sysCreatedOn	String
sysId	String
sysModCount	Integer
sysName	String
sysPackage	String
sysPolicy	String
sysScope	String
sysTags	String
sysUpdateName	String
sysUpdatedBy	String
sysUpdatedOn	String

Additional Tables

The following tables are also retrieved by the License task type. The output schema for each table mirrors the fields available in the ServiceNow instance at the time of extraction.

•licensed_app_usage

•license_details_assoc_roles

•license_role

•ua_ih_usage