To fetch the DN Table details in your database, use the getdnSchema API. Executing the getdnSchema api will give you all the Table details available in the Database for reporting.
To fetch the DN Table schema details, perform the following steps:
Steps
Copy the Token generated without the comma or quotes.
Go to Postman or any other API tool.
Specify the URL as https://<novatech.com>/api_report/API/getdnSchema?=
Click on Authorization tab and select Bearer and paste the Token.
Click Send.
Response
[
{
"text": "mart_adm_customer_master",
"value": "mart_adm_customer_master"
},
{
"text": "mart_adm_evaluation_details",
"value": "mart_adm_evaluation_details"
},
{
"text": "mart_adm_evaluation_task_details",
"value": "mart_adm_evaluation_task_details"
},
{
"text": "mart_adm_location_master",
"value": "mart_adm_location_master"
},
{
"text": "mart_adm_user_achievements_earned",
"value": "mart_adm_user_achievements_earned"
},
{
"text": "mart_adm_user_gamification_points",
"value": "mart_adm_user_gamification_points"
},
{
"text": "mart_adm_user_master",
"value": "mart_adm_user_master"
},
{
"text": "mart_adm_vendor_master",
"value": "mart_adm_vendor_master"
},
{
"text": "mart_am_allocation_customattributes_sv",
"value": "mart_am_allocation_customattributes_sv"
},
{
"text": "mart_am_asset_master",
"value": "mart_am_asset_master"
},
{
"text": "mart_am_asset_master_allocation",
"value": "mart_am_asset_master_allocation"
},
{
"text": "mart_am_customattributes_sv",
"value": "mart_am_customattributes_sv"
},
{
"text": "mart_am_ld_active_installs_category_summary",
"value": "mart_am_ld_active_installs_category_summary"
},
{
"text": "mart_am_ld_assets_with_no_audit_data",
"value": "mart_am_ld_assets_with_no_audit_data"
},
{
"text": "mart_am_ld_audit_partner_non_standard_allocations",
"value": "mart_am_ld_audit_partner_non_standard_allocations"
},
{
"text": "mart_am_ld_baselicenses_allocation",
"value": "mart_am_ld_baselicenses_allocation"
},
{
"text": "mart_am_ld_baseline_installs_products_by_category",
"value": "mart_am_ld_baseline_installs_products_by_category"
},
{
"text": "mart_am_ld_categories_sum",
"value": "mart_am_ld_categories_sum"
},
{
"text": "mart_am_ld_cleansing_all_users",
"value": "mart_am_ld_cleansing_all_users"
},
{
"text": "mart_am_ld_cleansing_application_instances",
"value": "mart_am_ld_cleansing_application_instances"
},
{
"text": "mart_am_ld_cleansing_hardware_template",
"value": "mart_am_ld_cleansing_hardware_template"
},
{
"text": "mart_am_ld_cleansing_primary_users_with_subscription",
"value": "mart_am_ld_cleansing_primary_users_with_subscription"
},
{
"text": "mart_am_ld_cleansing_subscribers_not_primary_users",
"value": "mart_am_ld_cleansing_subscribers_not_primary_users"
},
{
"text": "mart_am_ld_cleansing_unmatched_executable",
"value": "mart_am_ld_cleansing_unmatched_executable"
},
{
"text": "mart_am_ld_contract_records_entitlement_summary",
"value": "mart_am_ld_contract_records_entitlement_summary"
},
{
"text": "mart_am_ld_contract_records_notes",
"value": "mart_am_ld_contract_records_notes"
},
{
"text": "mart_am_ld_cpupvu_based_installs_on_virtual_devices_with_no_host",
"value": "mart_am_ld_cpupvu_based_installs_on_virtual_devices_with_no_host"
},
{
"text": "mart_am_ld_custom_category_summary",
"value": "mart_am_ld_custom_category_summary"
},
{
"text": "mart_am_ld_data_assets",
"value": "mart_am_ld_data_assets"
},
{
"text": "mart_am_ld_data_origins_device_origins",
"value": "mart_am_ld_data_origins_device_origins"
},
{
"text": "mart_am_ld_data_origins_user_origins",
"value": "mart_am_ld_data_origins_user_origins"
},
{
"text": "mart_am_ld_device_summary",
"value": "mart_am_ld_device_summary"
},
{
"text": "mart_am_ld_devices_with_multiple_product_versions",
"value": "mart_am_ld_devices_with_multiple_product_versions"
},
{
"text": "mart_am_ld_dra_exclusions",
"value": "mart_am_ld_dra_exclusions"
},
{
"text": "mart_am_ld_effective_lic_by_country",
"value": "mart_am_ld_effective_lic_by_country"
},
{
"text": "mart_am_ld_effective_lic_by_env",
"value": "mart_am_ld_effective_lic_by_env"
},
{
"text": "mart_am_ld_effective_license_position_detail",
"value": "mart_am_ld_effective_license_position_detail"
},
{
"text": "mart_am_ld_effective_license_position_downgrades",
"value": "mart_am_ld_effective_license_position_downgrades"
},
{
"text": "mart_am_ld_effective_license_position_history",
"value": "mart_am_ld_effective_license_position_history"
},
{
"text": "mart_am_ld_effective_position",
"value": "mart_am_ld_effective_position"
},
{
"text": "mart_am_ld_effectivelicenseposition_by_bu",
"value": "mart_am_ld_effectivelicenseposition_by_bu"
},
{
"text": "mart_am_ld_estate_change_by_asset_detail",
"value": "mart_am_ld_estate_change_by_asset_detail"
},
{
"text": "mart_am_ld_estate_change_by_asset_summary",
"value": "mart_am_ld_estate_change_by_asset_summary"
},
{
"text": "mart_am_ld_estate_change_by_assetssummary",
"value": "mart_am_ld_estate_change_by_assetssummary"
},
{
"text": "mart_am_ld_estate_change_by_hardware_detail",
"value": "mart_am_ld_estate_change_by_hardware_detail"
},
{
"text": "mart_am_ld_estate_change_by_hardware_summary",
"value": "mart_am_ld_estate_change_by_hardware_summary"
},
{
"text": "mart_am_ld_estate_change_by_installation_summary",
"value": "mart_am_ld_estate_change_by_installation_summary"
},
{
"text": "mart_am_ld_estate_change_by_vendor",
"value": "mart_am_ld_estate_change_by_vendor"
},
{
"text": "mart_am_ld_generic_installs_rule_template",
"value": "mart_am_ld_generic_installs_rule_template"
},
{
"text": "mart_am_ld_host_license_assignments_with_surplus_guest_allowance",
"value": "mart_am_ld_host_license_assignments_with_surplus_guest_allowance"
},
{
"text": "mart_am_ld_import_asset_history",
"value": "mart_am_ld_import_asset_history"
},
{
"text": "mart_am_ld_imports_data_feed_summary",
"value": "mart_am_ld_imports_data_feed_summary"
},
{
"text": "mart_am_ld_inactive_assets_with_manual_usage",
"value": "mart_am_ld_inactive_assets_with_manual_usage"
},
{
"text": "mart_am_ld_license_entitlement",
"value": "mart_am_ld_license_entitlement"
},
{
"text": "mart_am_ld_license_optimization_value",
"value": "mart_am_ld_license_optimization_value"
},
{
"text": "mart_am_ld_manage_vendors",
"value": "mart_am_ld_manage_vendors"
},
{
"text": "mart_am_ld_managed_coverage_detail",
"value": "mart_am_ld_managed_coverage_detail"
},
{
"text": "mart_am_ld_master_server_template_virtual_machines",
"value": "mart_am_ld_master_server_template_virtual_machines"
},
{
"text": "mart_am_ld_microsoft_ea_eligible_devices",
"value": "mart_am_ld_microsoft_ea_eligible_devices"
},
{
"text": "mart_am_ld_physical_to_virtual_software_mapping",
"value": "mart_am_ld_physical_to_virtual_software_mapping"
},
{
"text": "mart_am_ld_prd_categories",
"value": "mart_am_ld_prd_categories"
},
{
"text": "mart_am_ld_product_metering_sum",
"value": "mart_am_ld_product_metering_sum"
},
{
"text": "mart_am_ld_product_transitions",
"value": "mart_am_ld_product_transitions"
},
{
"text": "mart_am_ld_software_by_asset_licensable",
"value": "mart_am_ld_software_by_asset_licensable"
},
{
"text": "mart_am_ld_software_inventory",
"value": "mart_am_ld_software_inventory"
},
{
"text": "mart_am_ld_software_inventory_summary_all",
"value": "mart_am_ld_software_inventory_summary_all"
},
{
"text": "mart_am_ld_software_per_asset",
"value": "mart_am_ld_software_per_asset"
},
{
"text": "mart_am_ld_software_usage",
"value": "mart_am_ld_software_usage"
},
{
"text": "mart_am_ld_spla_details",
"value": "mart_am_ld_spla_details"
},
{
"text": "mart_am_ld_system_logs_event_log",
"value": "mart_am_ld_system_logs_event_log"
},
{
"text": "mart_am_ld_true_up_req",
"value": "mart_am_ld_true_up_req"
},
{
"text": "mart_am_ld_unmapped_guest_software_usage",
"value": "mart_am_ld_unmapped_guest_software_usage"
},
{
"text": "mart_am_ld_vendors_with_downgrades_permitted",
"value": "mart_am_ld_vendors_with_downgrades_permitted"
},
{
"text": "mart_am_ld_virtual_to_physical_device_relationships",
"value": "mart_am_ld_virtual_to_physical_device_relationships"
},
{
"text": "mart_am_location_heirarchy",
"value": "mart_am_location_heirarchy"
},
{
"text": "mart_am_mc_asset_transaction_customattributes_sv",
"value": "mart_am_mc_asset_transaction_customattributes_sv"
},
{
"text": "mart_am_nf_asset_allocation_details",
"value": "mart_am_nf_asset_allocation_details"
},
{
"text": "mart_am_nf_asset_master",
"value": "mart_am_nf_asset_master"
},
{
"text": "mart_am_nf_asset_sw_allocation_details",
"value": "mart_am_nf_asset_sw_allocation_details"
},
{
"text": "mart_am_nf_customattributes_sv",
"value": "mart_am_nf_customattributes_sv"
},
{
"text": "mart_am_reconciliation_status",
"value": "mart_am_reconciliation_status"
},
{
"text": "mart_am_software_inventory",
"value": "mart_am_software_inventory"
},
{
"text": "mart_am_widget_scan_details",
"value": "mart_am_widget_scan_details"
},
{
"text": "mart_cm_approval_action_details",
"value": "mart_cm_approval_action_details"
},
{
"text": "mart_cm_change_checklist_history",
"value": "mart_cm_change_checklist_history"
},
{
"text": "mart_cm_change_request_history",
"value": "mart_cm_change_request_history"
},
{
"text": "mart_cm_change_request_master",
"value": "mart_cm_change_request_master"
},
{
"text": "mart_cm_change_task_master",
"value": "mart_cm_change_task_master"
},
{
"text": "mart_cmdb_configuration_item_history",
"value": "mart_cmdb_configuration_item_history"
},
{
"text": "mart_cmdb_configuration_item_master",
"value": "mart_cmdb_configuration_item_master"
},
{
"text": "mart_cmdb_configuration_item_relations",
"value": "mart_cmdb_configuration_item_relations"
},
{
"text": "mart_cmdb_configuration_service_mapping",
"value": "mart_cmdb_configuration_service_mapping"
},
{
"text": "mart_cmdb_customattributes_sv",
"value": "mart_cmdb_customattributes_sv"
},
{
"text": "mart_im_approval_action_details",
"value": "mart_im_approval_action_details"
},
{
"text": "mart_im_auto_escalated_etr_tracking",
"value": "mart_im_auto_escalated_etr_tracking"
},
{
"text": "mart_im_auto_escalated_pending_tasks",
"value": "mart_im_auto_escalated_pending_tasks"
},
{
"text": "mart_im_auto_escalated_resolution_records",
"value": "mart_im_auto_escalated_resolution_records"
},
{
"text": "mart_im_auto_escalated_response_records",
"value": "mart_im_auto_escalated_response_records"
},
{
"text": "mart_im_category_level_records",
"value": "mart_im_category_level_records"
},
{
"text": "mart_im_classification_level_records",
"value": "mart_im_classification_level_records"
},
{
"text": "mart_im_incident_change_checklist_history",
"value": "mart_im_incident_change_checklist_history"
},
{
"text": "mart_im_incident_effort_summary",
"value": "mart_im_incident_effort_summary"
},
{
"text": "mart_im_manual_escalation_records",
"value": "mart_im_manual_escalation_records"
},
{
"text": "mart_im_ticket_feedback",
"value": "mart_im_ticket_feedback"
},
{
"text": "mart_im_ticket_feedback_details",
"value": "mart_im_ticket_feedback_details"
},
{
"text": "mart_im_ticket_history",
"value": "mart_im_ticket_history"
},
{
"text": "mart_im_ticket_master",
"value": "mart_im_ticket_master"
},
{
"text": "mart_im_ticket_relationships",
"value": "mart_im_ticket_relationships"
},
{
"text": "mart_im_ticket_reminders",
"value": "mart_im_ticket_reminders"
},
{
"text": "mart_im_workgroup_bounce_details",
"value": "mart_im_workgroup_bounce_details"
},
{
"text": "mart_km_knowledge_base_master",
"value": "mart_km_knowledge_base_master"
},
{
"text": "mart_km_knowledge_feedback_rating",
"value": "mart_km_knowledge_feedback_rating"
},
{
"text": "mart_orc_apidetails",
"value": "mart_orc_apidetails"
},
{
"text": "mart_orc_execution_activities",
"value": "mart_orc_execution_activities"
},
{
"text": "mart_orc_execution_queue",
"value": "mart_orc_execution_queue"
},
{
"text": "mart_orc_scripts",
"value": "mart_orc_scripts"
},
{
"text": "mart_orc_workflow",
"value": "mart_orc_workflow"
},
{
"text": "mart_pm_problem_diagnostic_details",
"value": "mart_pm_problem_diagnostic_details"
},
{
"text": "mart_pm_problem_record_history",
"value": "mart_pm_problem_record_history"
},
{
"text": "mart_pm_problem_record_master",
"value": "mart_pm_problem_record_master"
},
{
"text": "mart_pm_root_cause_analysis_details",
"value": "mart_pm_root_cause_analysis_details"
},
{
"text": "mart_sr_approval_action_details",
"value": "mart_sr_approval_action_details"
},
{
"text": "mart_sr_auto_escalated_pending_tasks",
"value": "mart_sr_auto_escalated_pending_tasks"
},
{
"text": "mart_sr_auto_escalated_pendingapproval",
"value": "mart_sr_auto_escalated_pendingapproval"
},
{
"text": "mart_sr_auto_escalated_reassignments",
"value": "mart_sr_auto_escalated_reassignments"
},
{
"text": "mart_sr_auto_escalated_resolution_records",
"value": "mart_sr_auto_escalated_resolution_records"
},
{
"text": "mart_sr_auto_escalated_response_records",
"value": "mart_sr_auto_escalated_response_records"
},
{
"text": "mart_sr_catalogcustomattributes_sv",
"value": "mart_sr_catalogcustomattributes_sv"
},
{
"text": "mart_sr_category_level_records",
"value": "mart_sr_category_level_records"
},
{
"text": "mart_sr_classification_level_records",
"value": "mart_sr_classification_level_records"
},
{
"text": "mart_sr_manual_escalation_records",
"value": "mart_sr_manual_escalation_records"
},
{
"text": "mart_sr_service_catalog_master",
"value": "mart_sr_service_catalog_master"
},
{
"text": "mart_sr_service_catalog_workflow",
"value": "mart_sr_service_catalog_workflow"
},
{
"text": "mart_sr_service_catalog_workflow_steps",
"value": "mart_sr_service_catalog_workflow_steps"
},
{
"text": "mart_sr_service_change_checklist_history",
"value": "mart_sr_service_change_checklist_history"
},
{
"text": "mart_sr_service_ticket_feedback",
"value": "mart_sr_service_ticket_feedback"
},
{
"text": "mart_sr_service_ticket_feedback_details",
"value": "mart_sr_service_ticket_feedback_details"
},
{
"text": "mart_sr_service_ticket_history",
"value": "mart_sr_service_ticket_history"
},
{
"text": "mart_sr_service_ticket_master",
"value": "mart_sr_service_ticket_master"
},
{
"text": "mart_sr_service_ticket_reminders",
"value": "mart_sr_service_ticket_reminders"
},
{
"text": "mart_sr_workgroup_bounce_details",
"value": "mart_sr_workgroup_bounce_details"
},
{
"text": "mart_wo_incident_workorder_checklist_history",
"value": "mart_wo_incident_workorder_checklist_history"
},
{
"text": "mart_wo_service_workorder_checklist_history",
"value": "mart_wo_service_workorder_checklist_history"
},
{
"text": "mart_wo_work_order_effort_tracking",
"value": "mart_wo_work_order_effort_tracking"
},
{
"text": "mart_wo_work_order_master",
"value": "mart_wo_work_order_master"
}
]