Database Tables

  1.  


    2. access_approvers
    3. access_approvers_arch
    4. access_class
    5. access_objects
    6. accessrulesexception
    7. account_attributes
    8. account_entitlement_history
    9. account_entitlements1
    10. account_entitlements1_bcp
    11. account_entitlements_privilege
    12. account_entitlements_rollback
    13. account_role_saviyntrfc
    14. accountowners
    15. accounts
    16. accounts_bcp
    17. accounts_owners
    18. accountsloadfromacl
    19. analyticconflictaccept
    20. analytics_analyticshistory
    21. analytics_history_report
    22. analytics_history_report_backup
    23. analyticsconfig
    24. analyticsconfig_attributes
    25. analyticsconfig_clean
    26. analyticsconfig_history
    27. analyticsconfiges
    28. analyticsconfiges_analyticsconfig_...
    29. analyticsconfiges_attributes
    30. analyticsconfiges_history
    31. analyticses_analyticshistory
    32. analyticshistory
    33. analyticshistoryes
    34. answer
    35. ao_metadata_action
    36. appdataarchive
    37. applicationonboarding
    38. applicationonboarding_history
    39. applicationtype
    40. applicense
    41. apponboardingquestionaire
    42. apponboardingsection
    43. apponboardingvalidation
    44. ars_requests
    45. ars_requests_arch
    46. arsrequest_attachments
    47. arstasks
    48. arstasks_arch
    49. arstasks_exec
    50. associatedentitlements
    51. assoentexceptions
    52. att_acc_entitlements1_status
    53. att_access_objects
    54. att_account_entitlements_privilege
    55. att_account_entitlements_privilege...
    56. att_accounts
    57. att_certifiers
    58. att_child_roles_status
    59. att_childroles
    60. att_ent2_status
    61. att_ent_accounts_status
    62. att_ent_object_status
    63. att_ent_values_status
    64. att_entitlement_values
    65. att_role_entitlements
    66. att_role_entitlements_status
    67. att_role_objects
    68. att_role_user_account
    69. att_role_user_account_status
    70. att_roles
    71. att_roles_status
    72. att_user_accounts_status
    73. att_user_status
    74. att_users
    75. attestations
    76. auditrules
    77. aws_credreport
    78. backup_endpoint_attributes_09_04_2...
    79. bp_attributes
    80. bp_attributeshistory
    81. bp_functions
    82. bp_owners
    83. bp_roles
    84. busprocs
    85. campaign
    86. campaign_template
    87. campaign_template_history
    88. campaign_usernotification_history
    89. cdhdr
    90. cdpos
    91. cdposnew
    92. cert_child_roles_status
    93. cert_childroles
    94. cert_ent_values_status
    95. cert_role_entitlements
    96. cert_role_entitlements_status
    97. cert_role_user_account
    98. cert_roles_status
    99. cert_service_account_status
    100. certification
    101. certification_account
    102. certification_account_entitlement1...
    103. certification_account_entitlements...
    104. certification_account_entitlements...
    105. certification_certifier
    106. certification_child_customer_status
    107. certification_customer
    108. certification_customer_status
    109. certification_customer_user_status
    110. certification_entitlement2_status
    111. certification_entitlement_value
    112. certification_role
    113. certification_role_user_account_st...
    114. certification_service_account_enti...
    115. certification_service_account_stat...
    116. certification_service_accounts
    117. certification_service_entitlement_...
    118. certification_user
    119. certification_user_account_status
    120. certification_user_status
    121. childfunctions
    122. childquestion
    123. childroles
    124. childroles_history
    125. configuration
    126. control_center_analytics_run_detai...
    127. control_center_analytics_run_histo...
    128. control_center_book
    129. control_center_book_kpi_map
    130. control_center_book_menu_map
    131. control_center_kpi
    132. control_center_kpi_criticality
    133. control_center_menu
    134. control_center_topic
    135. corealtionruleshistory
    136. correlation_rules
    137. correlationrules
    138. correlationrules_history
    139. customer
    140. customer_associatedentitlements_hi...
    141. customer_attribute
    142. customer_attribute_history
    143. customer_attributevalues
    144. customer_attributevalues_history
    145. customer_endpoint
    146. customer_endpoint_history
    147. customer_entitlementvalues
    148. customer_entitlementvalueshistory
    149. customer_history
    150. customer_historychangelog
    151. customer_roles
    152. customer_roles_history
    153. customer_rule
    154. customer_rule_history
    155. customer_users
    156. customerrulerundata
    157. customerrulerundata_archive
    158. dashboard_analytics_config
    159. dashboard_savroles
    160. dashboard_savroles_temp
    161. dashboards
    162. dataset
    163. dataset_values
    164. default_policy
    165. delegates
    166. distinct_temproletotcode
    167. document_usage_logs
    168. dormant_acc_flag
    169. dormant_acc_flag_history
    170. ecmemailtemplate
    171. ecmimportjob
    172. ecmimportjob_arch
    173. ecmsmstemplate
    174. emailhistory
    175. emailhistory_archive
    176. emailhistoryprocess
    177. endpoint_attributes
    178. endpoint_certifier
    179. endpointmap
    180. endpoints
    181. endpoints_properties
    182. ent_content_events
    183. ent_export_email_sent
    184. ent_user_events
    185. entitlement_changelog
    186. entitlement_map
    187. entitlement_objects
    188. entitlement_objects_history
    189. entitlement_owners
    190. entitlement_owners_bkp06262020
    191. entitlement_type
    192. entitlement_types
    193. entitlement_types_backup_07232020
    194. entitlement_usage
    195. entitlement_value_attrs
    196. entitlement_values
    197. entitlement_values_history
    198. entitlementmap
    199. entitlements2
    200. entitlements2_bkp_06272020
    201. entitlements2_history
    202. entitlements2_privilege
    203. entitlements3
    204. entitlements3_history
    205. entitlements4
    206. entitlements4_history
    207. entitlements5
    208. entitlements5_history
    209. entitlementtype_privilege
    210. execution_trail
    211. execution_trail_archive
    212. externalconnattvalue
    213. externalconnection
    214. externalconnection_history
    215. externalconnection_template
    216. externalconnectiontype
    217. externalconnectiontype_history
    218. externalcustomers
    219. feature
    220. feature_details
    221. ff_usage
    222. ffid_sessions
    223. ffid_users
    224. field_values
    225. fields
    226. function_entitlements
    227. function_entitlementshistory
    228. function_history
    229. function_history_details
    230. function_objects
    231. function_objects_group
    232. function_objects_group_history
    233. function_regex
    234. functionobjects_history
    235. functions
    236. hana_audit_log
    237. hanarule
    238. hanaruleaction
    239. hanaruleattribute
    240. hanarulehistory
    241. hanarulesexception
    242. identityconnector
    243. identityconnector_endpoint
    244. importlog
    245. importlog_arch
    246. incomingmail
    247. incomingmail_arch
    248. instance
    249. jbpm4_deployment
    250. jbpm4_deployprop
    251. jbpm4_execution
    252. jbpm4_hist_actinst
    253. jbpm4_hist_detail
    254. jbpm4_hist_procinst
    255. jbpm4_hist_task
    256. jbpm4_hist_var
    257. jbpm4_id_group
    258. jbpm4_id_membership
    259. jbpm4_id_user
    260. jbpm4_job
    261. jbpm4_job_bkp_20230102
    262. jbpm4_lob
    263. jbpm4_participation
    264. jbpm4_property
    265. jbpm4_swimlane
    266. jbpm4_task
    267. jbpm4_variable
    268. jbpmretry
    269. jrmrules
    270. jrmrules_history
    271. legalrequirement
    272. logdata
    273. logheader
    274. mc_risk_account
    275. message_properties
    276. mitigatingcontrols
    277. nodemac
    278. notifications
    279. numbers
    280. organization_owners
    281. organization_owners_history
    282. organization_policy
    283. organizations
    284. p_history
    285. patternmatches
    286. policy_ui_configuration
    287. policyrule
    288. policytemplate
    289. possibleanswer
    290. proposed_accountowners
    291. proposedowners
    292. qrtz_blob_triggers
    293. qrtz_calendars
    294. qrtz_cron_triggers
    295. qrtz_fired_triggers
    296. qrtz_job_details
    297. qrtz_job_listeners
    298. qrtz_locks
    299. qrtz_paused_trigger_grps
    300. qrtz_scheduler_state
    301. qrtz_simple_triggers
    302. qrtz_trigger_listeners
    303. qrtz_triggers
    304. question
    305. questionnaire
    306. rc_account_entitlements1
    307. rc_accounts
    308. rc_entitlement_types
    309. rc_entitlement_values
    310. rc_entitlements2
    311. rc_equalroles
    312. rc_results
    313. rc_user_accounts
    314. rc_users
    315. reactdynamicvalues
    316. regulation
    317. report_attributes
    318. reportdetail
    319. reports
    320. request_access
    321. request_access_arch
    322. request_access_attrs
    323. request_access_attrs_arch
    324. request_exceptions
    325. request_exceptions_access
    326. request_exceptions_access_arch
    327. request_exceptions_arch
    328. request_template
    329. request_template_access
    330. requestmap
    331. requestmap_09232022
    332. requestmap_6_x
    333. risk_history_details
    334. riskowners
    335. risks
    336. riskshistory
    337. role_attributes
    338. role_bp_history
    339. role_ent_privilege
    340. role_ent_privilege_history
    341. role_entitlements
    342. role_entitlements_history
    343. role_objects
    344. role_objects_history
    345. role_owners
    346. role_owners_history
    347. role_reference
    348. role_user_account
    349. role_user_account_history
    350. rolecomparisions
    351. rolehierarchy
    352. roles
    353. roles_history
    354. roles_historychangelog
    355. roletype_attributes
    356. rule
    357. rule_owners
    358. ruleset_risks
    359. rulesets
    360. sav_file_audit
    361. sav_sslcert
    362. sav_sync_file_version
    363. saviyntconnectdata
    364. saviyntconnectdts
    365. savrole_features_mapping
    366. savrole_permission
    367. savrole_permission_temp
    368. savroles
    369. scanrules
    370. scanrules_entitlements
    371. securitysystems
    372. session_launch_detail
    373. simulationdata
    374. simulationdatapoc
    375. simulationdetail
    376. simulationsummary
    377. sodrecommendation
    378. sodrisk_entitlement
    379. sodrisk_objects
    380. sodrisks
    381. ssminlp.recon_summary
    382. sysparams
    383. t2sodfinal
    384. t2sodrisk_ent
    385. t2sodrisk_objects
    386. tasks
    387. temp1251
    388. temp1252
    389. temp_role_change
    390. tempaccess_object_field_values
    391. tempaccount
    392. tempaccount_entitlements1
    393. tempagrtime
    394. tempentitlement_objects
    395. tempentitlement_values
    396. tempfield_values
    397. tempfieldvalue
    398. temproletotcode
    399. tempsapusage
    400. tempsod
    401. tempsodrisks
    402. tempusage
    403. tempusers
    404. terminatesession
    405. tilesconfig
    406. uploads
    407. user_accounts
    408. user_accounts_bcp
    409. user_attributes
    410. user_groups
    411. user_savroles
    412. useraccesstrace
    413. usergroup_entitlements
    414. usergroup_owners
    415. usergroup_users
    416. usergroups_history
    417. userlogin_access
    418. userlogins
    419. userrulerundata
    420. userrulerundata_archive
    421. users
    422. usershistory
    423. vendorattribute
    424. workflowhistory
    425. workflowupdatehistory
    426. wsfallback

    Comments

    Post a Comment

    Popular posts from this blog

    Enhanced Query - To Update Account Status and Name

    select accountkey as accounts__primarykey, 'SUSPENDED FROM IMPORT SERVICE' as accounts__status, CONCAT(name,'-Deleted on-', DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s'))as accounts__name from accounts where endpointkey=527 and name='CN=INRVCH,OU=User Accounts Vista,OU=User Accounts,OU=User Directory,DC=asia-pac,DC=xx,DC=com'  and status not in ('SUSPENDED FROM IMPORT SERVICE') limit 1;
    Read more

    Connection Config - STATUS_THRESHOLD_CONFIG

     {   "statusAndThresholdConfig": {    "inactivateAccountsNotInFile": true    "statusColumn":"userlock",    "activeStatus":["0","128","192"],     "accountThresholdValue": 500,     "deleteLinks": false,     "correlateInactiveAccounts": true,        } } ----------------------------------------------------------------------------- When account import run above STATUS_THRESHOLD_CONFIG is used to check. ----------------------------------- inactivateAccountsNotInFile  ==> True/false true ---> Account status 1/2 ( Active/Inactive) Day 1 --> 100 Accounts import Day 2 --> 90 Diff= 10  ( 90= Active , 10 Inactive)  ------------------------------------------------------------------------------ ----------------------------------- inactivateAccountsNotInFile  ==> True/false false ---> Account status 1/SFIS ( Active/SUSPENDED FROM IMPORT SERVICE.) Day 1 --> 100 Ac...
    Read more

    Email variables _ Register User

    ServiceAccountOwnerMap ------- [:] entitlements ------- [] accessapprovers ------- com.saviynt.ecm.workflow.Access_Approvers : 812 jbpm_activity_name ------- Third Party Registration Approvers allApproversComments ------- null fullrowhtmltablerows ------- listofallrolesinrequest ------- [] approvedEntitlementsOwners ------- [] entitlementshtmltablerowsv2 ------- entitlementshtmltablerowsv3 ------- ServiceAccountType ------- requestlink ------- null/jbpmworkflowmanagement/showrequestdetails/TP Registration Approvals.553050?reqid=433 allRejectorsComments ------- null rolesApprovedOrRejected ------- [] rolename ------- request_access ------- com.saviynt.ecm.workflow.Request_Access : 456 users ------- XXXX allRejectors ------- [] requestid ------- 553050 rolemap ------- [:] baseUrlForEmail ------- https://dev.saviyntcloud.com/ECM assignee ------- XXXX activityname ------- Third Party Registration Approvers ServiceAccountFlag ------- false request ------- com.saviynt.ecm.workflow.ARS_Reques...
    Read more