|
<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 u1 > Connectors > Alphabetic Connector List > ServiceNow License Data > Extracted Data Tables |
Table |
Column |
Type |
|---|---|---|
sys_user |
•active •firstName •lastLogin •lastLoginTime •lastName •name •roles •sysCreatedOn •sysId •sysUpdatedBy •sysUpdatedOn •userName •vip •webServiceAccessOnly |
•Boolean •String •String •String •String •string •String •String •String •String •String •String •String •Boolean •Boolean |
sys_user_has_license |
•active •attributeId •entlSubscriptionMap •license •licenseDeleted •roles •source •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysTags •sysUpdatedBy •sysUpdateOn •user |
•Boolean •String •String •String •String •String •String •String •String •String •Integer •String •String •String •String |
ua_app_usage |
•accessCount •appId •appName •appType •deleteCount •deleteOtherCount •deleteOwnCount •fulfillCount •insertCount •insertOtherCount •insertOwnCount •lineageId •produceCount •sysCreatedOn •sysId •sysModCount •timeStamp •updateCount •updateOtherCount •updateOwnCount •user |
•Integer •String •String •String •Integer •Integer •Integer •Integer •Integer •Integer •Integer •String •Integer •String •String •Integer •String •Integer •Integer •Integer •String |
license_details |
•allocated •allocatedStatus •autoSync •category •count •displayOnly •endDate •expired •isCapped •lastAllocationCalOn •lastTablesUsedCalOn •licenseType •licenseWeight •measuredRoleTypes •name •procuctCode •quotaDefn •quotaDefnId •StartDate •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysTags •sysUpdatedBy •sysUpdatedOn •tableCount •tablesUsed |
•String •String •Boolean •Integer •String •Boolean •String •Boolean •Boolean •String •String •Integer •Integer •String •String •Integer •String •String •String •String •String •String •Integer •String •String •String •String •String |
license_has_app |
•app •license •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysTags •sysUpdatedBy •sysUpdatedOn |
•String •String •String •String •String •Integer •String •String •String |
licensable_app |
•appFamilyId •appId •appName •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysTags •sysUpdatedBy •sysUpdatedOn |
•String •String •String •String •String •String •Integer •String •String •String |
licensed_app_usage |
•appSysModCount •usagAccessCount •usagAppId •usagAppName •usagAppType •usagDeleteCount •usagDeleteOtherCount •usagDeleteOwnCount •usagFulfillCount •usagInsertCount •usagInsertOtherCount •usagInsertOwnCount •usagLineageId •usagProduceCount •usagSysCreatedOn •usagSysModCount •usagTimeStamp •usagUpdateCount •usagUpdateOtherCount •usagUpdateOwnCount •usagUser |
•Integer •Integer •String •String •String •Integer •Integer •Integer •Integer •Integer •Integer •Integer •String •Integer •String •Integer •String •Integer •Integer •Integer •String |
license_details_assoc_roles |
•ctiAllotmentType •ctiAppName •ctiAppScope •ctiIsPlatformRuntime •ctiLicense •ctiSysCreatedBy •ctiSysCreatedOn •ctiSysId •ctiSysModCount •ctiSysTags •ctiSysUpdatedBy •stiSysUpdatedOn •ctiTableCreatedOn •ctiTableName •ctiTableRef •ctiTableRefId •lfFamilyId •lfFamilyName •lfSysCreatedBy •lfSysCreatedOn •lfSysId •lfSysModCount •lfSysTags •lfSysUpdatedBy •lfSysUpdatedOn •lhfLicense •lhfLicenseDetailsItem •lhfLicenseDetailsItemRef •lhfLicenseFamily •lhfSysCreatedBy •lhfSysCreatedOn •lhfSysId •lhfSysModCount •lhfSysTags •lhfSysUpdatedBy •lhfSysUpdatedOn •lhfTypeId •lhfTypeName •lrActive •lrApplication •lrCategory •lrExternalNote •lrLicenseRoleType •lrName •lrOverrideen •lrSysCreatedBy •lrSysCreatedOn •lrSysId •lrSysModCount •lrSysTags •lrSysUpdatedBy •lrSysUpdatedOn •lrSysUserRole •ractActive •ractLicneseRoleType •ractRoleName •ractSysCreatedBy •ractSysCreatedOn •ractSysId •ractSysModCount •ractSysTags •ractSysUpdatedBy •ractSysUpdatedOn •ractSysUserRole •ractTableName •ractTableRef |
•Integer •String •String •Boolean •String •String •String •String •Integer •String •String •String •String •String •String •String •String •String •String •String •String •Integer •String •String •String •String •String •String •String •String •String •String •Integer •String •String •String •String •String •Boolean •String •Integer •String •String •String •Boolean •String •String •String •Integer •String •String •String •String •Boolean •String •String •String •String •String •Integer •String •String •String •String •String •String |
license_role |
•application •category •externalNote •licenseRoleType •name •overridden •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysTags •sysUpdatedBy •sysUpdatedOn •sysUserRole |
•String •Integer •String •String •String •Boolean •String •String •String •Integer •String •String •String •String |
sys_user_has_role |
•inherited •role •state •sysCreatedBy •sysCreatedOn •sysId •sysUpdatedBy •sysUpdatedOn •user |
•String •String •String •String •String •String •String •String •String |
sys_user_role |
•assignableBy •canDelegate •description •elevatedPrivilege •grantable •includesRoles •name •requiresSubscription •scopedAdmin •suffix •sysClassName •sysCreatedBy •sysCreatedOn •sysId •sysModCount •sysName •sysPackage •sysPolicy •sysScope •sysTags •sysUpdateName •sysUpdatedBy •sysUpdatedOn |
•String •Boolean •String •Boolean •Boolean •String •String •String •Boolean •String •String •String •String •String •Integer •String •String •String •String •String •String •String •String |