[go: up one dir, main page]

0% found this document useful (0 votes)
29 views16 pages

Disk Usage by Top Tables

The document provides a report on disk usage by the top 1000 tables within a Safetica database. It lists each table name along with the number of records, reserved disk space, data space used, index space used, and unused space for each table. The safetica.content_detail table uses the most disk space at over 2.6GB reserved.

Uploaded by

est.gnsergio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
29 views16 pages

Disk Usage by Top Tables

The document provides a report on disk usage by the top 1000 tables within a Safetica database. It lists each table name along with the number of records, reserved disk space, data space used, index space used, and unused space for each table. The safetica.content_detail table uses the most disk space at over 2.6GB reserved.

Uploaded by

est.gnsergio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 16

Disk Usage by Top Tables

[safetica_data]
on ORS-SAFETICA\SAFETICA at 30/01/2024 11:34:31
This report provides detailed data on the utilization of disk space by top 1000 tables within the Database. The report does not provide data for memory
optimized tables.

Table Name # Records Reserved (KB) Data (KB)


safetica.content_detail 655.245 2.699.760 2.683.384
safetica.file_operation_log 1.290.603 966.664 617.992
safetica.web_log_url 754.874 734.592 488.760
safetica.app_monitor_log 2.397.504 679.232 227.192
safetica.web_log_title 520.010 444.768 202.840
safetica.path 632.676 357.376 139.640
safetica.binary_data 1 354.456 354.288
safetica.network_traffic_log 690.978 287.296 123.736
safetica.web_monitor_log 1.460.914 254.832 79.488
safetica.path_directory 560.946 253.760 87.016
safetica.activity_log 447.239 186.880 60.392
safetica.setting_effective 316.893 101.728 45.824
safetica.app_runtime_log 281.741 67.504 26.768
safetica.mail_log_receiver 243.256 63.512 14.528
safetica.application_path 636.510 53.536 20.784
safetica.print_log 62.004 42.224 14.496
safetica.mail_monitor_log 25.031 29.648 10.400
safetica.web_categorization_history 116.503 17.200 5.144
safetica.web 119.854 17.048 7.144
safetica.mail_log_content 51.809 16.224 4.912
HangFire.State 5.661 14.928 8.056
safetica.office365_log 18.466 14.696 12.768
HangFire.JobParameter 7.536 14.288 6.880
HangFire.Job 1.887 12.528 6.024
safetica.mail_log_email 47.242 11.104 3.880
safetica.application 9.116 9.768 4.080
safetica.alert_detail 2.140 8.656 2.464
safetica.file_operation_log_print 62.010 6.240 2.344
safetica.alert_log_rule 6.434 6.160 2.128
safetica.file_operation_log_web 28.030 6.056 1.280
safetica.alert 2.140 5.840 2.048
safetica.synchronization_attribute 11.671 4.952 2.032
safetica.device 3.950 4.456 1.296
safetica.diag_report 11.502 3.944 1.552
safetica.web_control_log 1.082 3.904 136
safetica.diag_report_event 28.932 3.616 2.040
eport does not provide data for memory

Indexes (KB) Unused (KB)


14.416 1.960
336.920 11.752
205.432 40.400
441.216 10.824
240.504 1.424
216.896 840
24 144
152.352 11.208
170.168 5.176
165.920 824
88.192 38.296
48.088 7.816
36.312 4.424
46.736 2.248
32.008 744
18.384 9.344
14.072 5.176
10.456 1.600
8.976 928
7.872 3.440
72 6.800
1.552 376
96 7.312
280 6.224
5.648 1.576
4.448 1.240
64 6.128
3.264 632
40 3.992
3.080 1.696
40 3.752
2.160 760
2.072 1.088
2.152 240
928 2.840
1.080 496
safetica.web_detector 6 3.488 3.216
safetica.aport_rule_guid_effective 17.704 2.960 2.272
safetica.db_task_log 33.504 2.776 1.360
safetica.server_health 15.955 2.712 1.816
safetica.path_file 9.487 2.552 640
safetica.device_control_log 2.418 2.552 224
safetica.file_operation_log_dgid 3.997 2.544 192
safetica.file_monitor_rule_guid_effective 15.096 2.528 592
safetica.flags 6.256 2.424 416
safetica.application_rule 8.516 2.280 784
safetica.mail_log_email_domain 14.593 2.264 800
safetica.user_tree 2.908 2.160 752
safetica.printer 6.133 2.080 1.160
safetica.app_control_log 222 1.736 64
Saas.ThreatRuleResults 1.498 1.712 80
safetica.printer_copy 6.807 1.432 536
safetica.app_categorization_history 5.351 1.320 344
safetica.licence_guid 8.729 1.304 440
safetica.console_log 1.711 1.264 112
safetica.console_log_guid 2.276 1.056 88
safetica.category_web 382 872 16
safetica.upn_to_user_tree 594 864 160
safetica.pc_info 771 736 328
safetica.layout 108 728 400
safetica.user_tree_parent 2.936 672 184
safetica.file_operation_log_mail 653 608 32
safetica.disk_encrypted_device_target 3.540 600 224
safetica.pc_user 666 544 72
safetica.disk_encrypted_policy_effective 677 536 240
safetica.file_operation_log_content 3.997 528 160
safetica.disk_encrypted_system_info 655 472 160
safetica.pc_client_info 657 472 128
safetica.device_control_rule_guid_effective 1.642 464 288
safetica.file_info 772 408 192
safetica.ext_categorization_history 673 408 32
safetica.token_use 14 360 8
safetica.category_application 68 360 8
safetica.mail_log_content_detail 78 352 8
safetica.disk_encrypted_gpo_info 1.310 344 120
safetica.disk_encrypted_target 1.656 344 112
safetica.setting 266 344 32
safetica.db_api_request_storage 0 344 8
safetica.cloud_drive_path 1.218 336 120
safetica.device_usb_vendor 1.883 336 136
safetica.cloud_drive_usage 1.304 280 72
24 248
24 664
792 624
384 512
1.312 600
1.256 1.072
632 1.720
1.384 552
1.368 640
880 616
1.016 448
808 600
368 552
568 1.104
280 1.352
664 232
640 336
512 352
304 848
344 624
152 704
192 512
96 312
56 272
224 264
152 424
128 248
296 176
64 232
48 320
64 248
80 264
24 152
56 160
104 272
72 280
72 280
72 272
80 144
88 144
72 240
72 264
80 136
96 104
120 88
safetica.installer_task_guid 481 280 72
safetica.alert_log_category 1.786 272 72
safetica.web_safetica_report_history 487 272 152
safetica.device_last_usage 1.071 272 64
safetica.disk_encrypted_device_status 1.416 272 80
safetica.disk_encrypted_device 708 272 136
safetica.compatibility_list 1.024 264 200
safetica.console_log_detail 9 216 24
safetica.content_rule 4 216 8
safetica.aport_email 8 216 8
safetica.data_category_content_rule 4 216 8
websafetica.policy_guid 149 216 8
safetica.web_log_ip 400 208 48
safetica.pc_online 766 208 104
safetica.printer_network 364 208 48
safetica.deactivation_status 761 208 112
safetica.alert_log_data_category 1.786 208 72
safetica.installer_task_guid_detail 0 176 16
safetica.installer_version 6 144 8
safetica.installer_task 381 144 40
safetica.installer 8 144 8
safetica.db_archive_log 10 144 8
safetica.content_rule_predef 4 144 8
HangFire.AggregatedCounter 90 144 8
safetica.update_file 1 144 8
HangFire.Set 16 144 8
safetica.console_user 7 144 8
safetica.update 3 144 32
safetica.console_user_setting 45 144 8
safetica.token_guid_effective 14 144 8
safetica.console_pc 3 144 8
safetica.file_monitor_rule_guid 8 144 8
safetica.file_monitor_rule 8 144 8
HangFire.Server 1 144 8
safetica.token_guid 25 144 8
safetica.report_option 7 144 8
websafetica.user_tree_flattened 276 144 16
websafetica.appcontrol_category 2 144 8
safetica.cache_timestamp 10 144 8
websafetica.appcontrol_application 32 144 8
safetica.category_productivity 71 144 8
safetica.web_rule 113 144 8
safetica.policy 6 144 8
websafetica.webcontrol_category 14 144 8
websafetica.global_settings 3 144 8
72 136
24 176
24 96
64 144
72 120
24 112
16 48
40 152
40 168
40 168
40 168
40 168
56 104
48 56
80 80
24 72
24 112
48 112
24 112
40 64
24 112
24 112
24 112
24 112
24 112
24 112
24 112
8 104
24 112
24 112
24 112
24 112
24 112
24 112
24 112
24 112
48 80
24 112
24 112
24 112
24 112
24 112
24 112
24 112
24 112
safetica.path_extension 40 144 8
websafetica.webcontrol_url 33 144 8
websafetica.policy_rule 81 144 8
websafetica.policy 18 144 8
safetica.aport_rule_list 171 144 16
safetica.aport_rule 12 144 8
safetica.aport_rule_guid 13 144 8
safetica.aport_rule_email 14 144 16
safetica.zone_item 2.771 136 104
safetica.dump_guid 286 136 80
safetica.update_log 978 136 72
stats.onetime_scripts 0 80 16
HangFire.JobQueue 0 72 8
safetica.token 24 72 8
HangFire.Schema 1 72 8
safetica.dump 126 72 24
safetica.server_health_details 6 72 40
safetica.email 1 72 8
HangFire.Hash 146 72 56
safetica.fileguard_rule_guid 0 72 8
safetica.console_user_layout 85 72 8
HangFire.Counter 6 72 8
safetica.update_available 15 72 8
safetica.console_right 51 72 8
safetica.agent_task 4 72 8
safetica.fileguard_rule 0 72 8
safetica.conversion_log 170 72 32
safetica.fileguard_rule_guid_effective 0 72 8
safetica.update_log_detail 1 72 8
safetica.agent_task_guid 4 72 8
safetica.data_category 5 72 8
safetica.alert_console_user 1.062 72 40
safetica.alert_conversion 215 72 8
safetica.db_task 9 72 8
safetica.agent_task_guid_result 24 72 8
safetica.db_archive 17 72 8
safetica.db_task_guid 6 72 8
safetica.ws_policy 5 72 8
safetica.licence_rule 1 72 8
safetica.licence_number 4 72 8
safetica.ws_policy_user 5 72 8
safetica.web_safetica_partitions_log 36 72 8
safetica.definition_update_history 97 72 8
safetica.definition_update_state 3 72 8
safetica.policy_guid 6 72 8
24 112
24 112
24 112
24 112
24 104
24 112
24 112
24 104
16 16
16 40
16 48
16 48
8 56
8 56
8 56
16 32
8 24
8 56
16 0
8 56
8 56
8 56
8 56
8 56
8 56
8 56
16 24
8 56
8 56
8 56
8 56
16 16
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
safetica.zone 3 72 8
safetica.device_rule 3 72 8
safetica.device_owner 1.236 72 32
stats.script_logs 1 72 8
safetica.aport_rule_list_additional 205 72 8
safetica.network_path 0 72 8
Saas.ThreatRule 21 72 8
safetica.disk_encrypted_protector 4 72 8
safetica.category 86 72 8
safetica.policy_rule_zone 0 72 8
safetica.predef_holidays 22 72 8
safetica.policy_rule 71 72 8
safetica.disk_encrypted 655 72 32
safetica.remote_client 10 72 8
safetica.report_layout 4 72 8
safetica.classi_tagger_result 0 72 16
safetica.classi_tagger_result_rule 0 72 16
safetica.device_control_rule_guid 28 72 8
safetica.licence_rule_module 9 72 8
safetica.device_control_rule 28 72 8
safetica.long_text 23 72 8
safetica.aport_rule_category 0 0 0
safetica.web_control_rule_guid 0 0 0
safetica.web_control_rule_guid_effective 0 0 0
safetica.disk_network_guid 0 0 0
safetica.classi_tagger_result_stats 0 0 0
safetica.disk_network 0 0 0
safetica.classi_tagger_result_category 0 0 0
safetica.disk_guid_effective 0 0 0
safetica.certificate 0 0 0
safetica.printcontrol_rule_guid 0 0 0
safetica.disk_encrypted_task 0 0 0
safetica.exchange_policy_mappings 0 0 0
safetica.channel_control_rule 0 0 0
safetica.printcontrol_rule_guid_effective 0 0 0
safetica.disk_guid 0 0 0
safetica.channel_control_rule_effective 0 0 0
safetica.classi_tagger_rule_content 0 0 0
safetica.disk_task_guid 0 0 0
safetica.classi_tagger_rule_domain 0 0 0
safetica.disk_network_guid_effective 0 0 0
safetica.classi_tagger_rule 0 0 0
safetica.report_interval 0 0 0
safetica.disk_task 0 0 0
safetica.classi_tagger_rule_application 0 0 0
8 56
8 56
16 24
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
8 56
16 24
8 56
8 56
0 56
0 56
8 56
8 56
8 56
8 56
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
safetica.classi_tagger_rule_extension 0 0 0
safetica.screenshot 0 0 0
safetica.disk_task_guid_effective 0 0 0
safetica.classi_tagger_rule_filter 0 0 0
safetica.policy_to_exchange_policy_group 0 0 0
safetica.classi_tagger_rule_path 0 0 0
safetica.screenshot_monitor_log 0 0 0
safetica.domain 0 0 0
safetica.classi_tagger_rule_pc 0 0 0
safetica.classi_tagger_task 0 0 0
safetica.auditor_rule_guid 0 0 0
safetica.policy_rule_access 0 0 0
safetica.auditor_rule 0 0 0
safetica.auditor_rule_guid_effective 0 0 0
safetica.policy_rule_extension 0 0 0
safetica.policy_rule_tagging 0 0 0
safetica.user_tree_to_aad_group 0 0 0
safetica.policy_rule_local_path 0 0 0
safetica.category_extension 0 0 0
safetica.disk_encrypted_policy 0 0 0
safetica.printcontrol_rule 0 0 0
safetica.printcontrol_rule_dev 0 0 0
safetica.app_control_metro_rule_guid_effective 0 0 0
safetica.web_control_rule_url_guid_effective 0 0 0
safetica.device_guid 0 0 0
safetica.app_control_metro_rule_guid 0 0 0
safetica.ws_policy_mobile_ios_app_setting 0 0 0
safetica.web_control_rule_url 0 0 0
safetica.device_encrypted_protector 0 0 0
safetica.app_control_metro_rule 0 0 0
safetica.web_control_rule_ip_guid_effective 0 0 0
safetica.device_encrypted 0 0 0
safetica.web_control_rule_ip 0 0 0
safetica.web_control_rule_keyword 0 0 0
safetica.device_encrypted_guid 0 0 0
safetica.aport_rule_syslog 0 0 0
safetica.web_control_rule_keyword_guid_effective 0 0 0
safetica.device_encrypted_guid_effective 0 0 0
safetica.mobile_device_intune 0 0 0
safetica.app_control_rule 0 0 0
safetica.app_control_rule_guid 0 0 0
safetica.web_mail_monitor_log 0 0 0
safetica.path_long 0 0 0
safetica.device_usb 0 0 0
safetica.app_control_rule_guid_effective 0 0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
safetica.diag_report_status 0 0 0
safetica.disk 0 0 0
safetica.file_operation_log_mobile 0 0 0
safetica.alert_setting_bind 0 0 0
safetica.alert_setting 0 0 0
safetica.web_control_rule 0 0 0
safetica.web_control_rule_category 0 0 0
safetica.ws_policy_wifi 0 0 0
safetica.web_control_rule_category_guid_effective 0 0 0
safetica.alert_trigger 0 0 0
safetica.web_safetica_insert_log 0 0 0
safetica.web_control_port_guid_effective 0 0 0
safetica.file_properties_extension 0 0 0
safetica.wifi 0 0 0
safetica.web_control_port_guid 0 0 0
safetica.web_control_log_detail 0 0 0
safetica.ip 0 0 0
safetica.web_control_port 0 0 0
safetica.image 0 0 0
safetica.health_care_log 0 0 0
safetica.holidays 0 0 0
safetica.mobile_device_operation 0 0 0
websafetica.security_issue_setting 0 0 0
safetica.user_pc_info 0 0 0
safetica.mobile_operation 0 0 0
safetica.flag 0 0 0
safetica.content_rule_keyword 0 0 0
safetica.user_email 0 0 0
safetica.file_monitor_rule_path 0 0 0
HangFire.List 0 0 0
safetica.token_log 0 0 0
safetica.mobile_device_location 0 0 0
safetica.file_operation_log_path_usb 0 0 0
safetica.file_operation_log_path 0 0 0
safetica.mobile_android_emm_user 0 0 0
safetica.content_rule_guid_effective 0 0 0
safetica.mobile_invitation 0 0 0
safetica.content_rule_guid 0 0 0
safetica.update_guid 0 0 0
safetica.ws_policy_mobile_android_emm_app_setting 0 0 0
safetica.content_rule_dictionary 0 0 0
safetica.content_dictionary 0 0 0
safetica.mobile_device_user 0 0 0
safetica.mobile_application 0 0 0
safetica.excluded_path 0 0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
safetica.classi_tagger_task_guid_effective 0 0 0
safetica.classi_tagger_task_guid 0 0 0
safetica.classi_tagger_task_path 0 0 0
safetica.test_group 0 0 0
safetica.extension 0 0 0
safetica.mobile_device 0 0 0
safetica.syslog_address 0 0 0
safetica.file_monitor_rule_extension 0 0 0
safetica.mobile_device_application 0 0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0

You might also like