Advertisement
Sky__Black

Pakistanarmy - By Sky_BlaCK

May 21st, 2013
607
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.27 KB | None | 0 0
  1. _ _ _ _ ____
  2. __| || |__ /\ | | (_)/ ___|
  3. \ __ / / \ _ __ | |_ _| (__ ___ ___
  4. | || | / /\ \ | ´_ \| __| |\__ \/ _ \/ __|
  5. /_ ~~ _\ / /__\ \| | | | |_| |___) | __/ (__
  6. |_||_| /_/ \_\_| |_|\__|_|____/\___|\___|
  7. ###############################################
  8. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  9. _ _ _____ _____ _ ______
  10. _| || |__ / ____|_ | __ \| | / ____|_
  11. \ __ /| (___ | |.___ _ | |__) | | __ _! / | | ._
  12. | || | \___ \| |/ / | | | | __ <| |/ _` | ( | |/ /
  13. /_ ~ ~ _\ ____) | || |_| | | |__) | | (_| | \____| |.
  14. |_||_| |_____/|_|\_\.__. | ______ |_____/|_|\__,_|\._____|_|\_\
  15. ___/ ||______|
  16. |___./
  17. #################################################################
  18. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  19.  
  20. #################################### www.pakistanarmy.gov.pk ####################################
  21.  
  22.  
  23. Host's addresses:
  24. __________________
  25.  
  26. pakistanarmy.gov.pk 5 IN A 92.52.113.184
  27.  
  28.  
  29. Name Servers:
  30. ______________
  31.  
  32. ns.rackspace.com 5 IN A 69.20.95.4
  33. ns2.rackspace.com 5 IN A 65.61.188.4
  34.  
  35.  
  36. Mail (MX) Servers:
  37. ___________________
  38.  
  39. mail.pakistanarmy.gov.pk 5 IN A 92.52.113.184
  40.  
  41.  
  42. #################################### www.pakistanarmy.gov.pk ####################################
  43.  
  44.  
  45. Databases :
  46.  
  47. [*] army_portal_live
  48. [*] awp_backup
  49. [*] awp_backup_2
  50. [*] db_common
  51. [*] db_logins
  52. [*] db_online_magazine
  53. [*] db_rate_this_page
  54. [*] db_shuhadas_corner
  55. [*] db_site_counter
  56. [*] ispr
  57. [*] ispr-drupal
  58. [*] ispr_db
  59. [*] master
  60. [*] model
  61. [*] msdb
  62. [*] tempdb
  63.  
  64.  
  65. Database:army_portal_live
  66.  
  67. +---------------------+
  68. | SiteMap |
  69. | sqlmapoutput |
  70. | sysdiagrams |
  71. | tblAds |
  72. | tblAnnouncements |
  73. | tblAudioGallery |
  74. | tblAudios |
  75. | tblContactUsLog |
  76. | tblContentPages |
  77. | tblContentPages_old |
  78. | tblExclusiveLinks |
  79. | tblImageGallery |
  80. | tblImages |
  81. | tblMenuItems |
  82. | tblNews |
  83. | tblPressReleases |
  84. | tblRoles |
  85. | tblTemplates |
  86. | tblThemes |
  87. | tblUsefulLinks |
  88. | tblUsers |
  89. | tblVideoGallery |
  90. | tblVideos |
  91. | tbl_blocked_ips |
  92. | tbl_settings |
  93. +---------------------+
  94.  
  95.  
  96. Table: tblUsefulLinks
  97.  
  98. +------------------+----------+
  99. | Column | Type |
  100. +------------------+----------+
  101. | IsShowHome | bit |
  102. | IsVisible | bit |
  103. | LastUpdated | datetime |
  104. | seq | int |
  105. | TimeCreated | datetime |
  106. | ULinkDescription | varchar |
  107. | ULinkID | int |
  108. | ULinkKeywords | varchar |
  109. | ULinkName | varchar |
  110. | ULinkTitle | varchar |
  111. | ULinkUrl | varchar |
  112. +------------------+----------+
  113.  
  114.  
  115.  
  116. Table: tblUsefulLinks
  117.  
  118. +---------+-----+---------------------------------+--------------------+-----------+----------------------------------------------------+------------+-----------------------------+-----------------------------+-----------------------------------------+-----------------------------------------+
  119. | ULinkID | seq | ULinkUrl | ULinkName | IsVisible | ULinkTitle | IsShowHome | TimeCreated | LastUpdated | ULinkKeywords | ULinkDescription |
  120. +---------+-----+---------------------------------+--------------------+-----------+----------------------------------------------------+------------+-----------------------------+-----------------------------+-----------------------------------------+-----------------------------------------+
  121. | 3 | 0 | http://www.ispr.gov.pk | Useful Links | 1 | Inter Services Public Relations Directorate (ISPR) | 1 | Sep \\?a07 2006 \\?a01:43PM | Sep \\?a07 2006 \\?a01:43PM | Inter Services Public Relation | http://www.ispr.gov.pk |
  122. | 16 | 1 | http://www.paf.gov.pk | a | 1 | Pakistan Air Force | 1 | Jan 24 2009 \\?a09:37AM | Jan 24 2009 \\?a09:37AM | Pakistan Air Force | Official website of Pakistan Air Force |
  123. | 9 | 10 | http://www.fwo.com.pk | Useful Links | 1 | Frontier Works Organization | 1 | Sep \\?a07 2006 \\?a01:45PM | Sep \\?a07 2006 \\?a01:45PM | FWO Frontier Works Organization | http://www.fwo.com.pk |
  124. | 2 | 100 | http://www.joinpakarmy.gov.pk | Join Pakistan Army | 1 | Join Pakistan Army | 0 | Sep \\?a07 2006 \\?a01:43PM | Sep \\?a07 2006 \\?a01:43PM | Join Pakistan Army | http://www.joinpakarmy.gov.pk |
  125. | 20 | 11 | http://www.kite.edu.pk | Useful Links | 1 | Khyber Institute of Technical Education | 1 | Jan 13 2011 10:48AM | Jan 13 2011 10:48AM | Khyber Institute of Technical Education | Khyber Institute of Technical Education |
  126. | 13 | 12 | http://www.pakistan.gov.pk | Useful Links | 1 | Govt of Pakistan | 1 | Dec \\?a01 2006 \\?a04:46PM | Dec \\?a01 2006 \\?a04:46PM | Govt of Pakistan | Official Website of Govt of Pakistan |
  127. | 10 | 2 | http://www.paknavy.gov.pk | Pakistan Navy | 1 | Pakistan Navy | 1 | Sep \\?a07 2006 \\?a01:45PM | Sep \\?a07 2006 \\?a01:45PM | Pakistan Navy | http://www.paknavy.gov.pk |
  128. | 19 | 3 | http://www.ndu.edu.pk/ | Useful Links | 1 | National Defence University | 1 | Sep \\?a01 2009 \\?a07:22AM | Sep \\?a01 2009 \\?a07:22AM | <blank> | <blank> |
  129. | 4 | 4 | http://armystaffcollege.gov.pk/ | Useful Links | 1 | Command and Staff College | 1 | Sep \\?a07 2006 \\?a01:43PM | Sep \\?a07 2006 \\?a01:43PM | Command and Staff College | http://armystaffcollege.gov.pk/ |
  130. | 5 | 5 | http://www.nust.edu.pk | NUST | 1 | NUST | 1 | Sep \\?a07 2006 \\?a01:44PM | Sep \\?a07 2006 \\?a01:44PM | NUST | http://www.nust.edu.pk |
  131. | 18 | 6 | http://mcs.nust.edu.pk | Useful Links | 1 | Military College of Signals | 1 | Apr \\?a01 2009 \\?a09:33PM | Apr \\?a01 2009 \\?a09:33PM | <blank> | <blank> |
  132. | 7 | 7 | http://www.ceme.edu.pk | EME College | 1 | EME College | 1 | Sep \\?a07 2006 \\?a01:45PM | Sep \\?a07 2006 \\?a01:45PM | EME College | http://www.ceme.edu.pk |
  133. | 17 | 8 | http://www.sitquetta.edu.pk | Useful Links | 0 | School of Infantry and Tactics | 1 | Mar 30 2009 \\?a08:23PM | Mar 30 2009 \\?a08:23PM | <blank> | <blank> |
  134. | 8 | 9 | http://www.depo.org.pk | Useful Links | 0 | Defence Export Promotion Organization | 1 | Sep \\?a07 2006 \\?a01:45PM | Sep \\?a07 2006 \\?a01:45PM | Defense Export Promotion Organization | http://www.depo.org.pk |
  135. +---------+-----+---------------------------------+--------------------+-----------+----------------------------------------------------+------------+-----------------------------+-----------------------------+-----------------------------------------+-----------------------------------------+
  136.  
  137.  
  138.  
  139. Table: tblUsers
  140.  
  141. +-------------+----------+
  142. | Column | Type |
  143. +-------------+----------+
  144. | isActive | bit |
  145. | LastUpdated | datetime |
  146. | LoginID | varchar |
  147. | Password | varchar |
  148. | RoleID | int |
  149. | TimeCreated | datetime |
  150. | UserID | int |
  151. | UserName | varchar |
  152. +-------------+----------+
  153.  
  154.  
  155.  
  156. Table: tblUsers
  157.  
  158. +--------+--------+---------+----------+---------------+----------+-------------------------+-------------------------+
  159. | RoleID | UserID | LoginID | UserName | Password | isActive | TimeCreated | LastUpdated |
  160. +--------+--------+---------+----------+---------------+----------+-------------------------+-------------------------+
  161. | 1 | 1 | cms_awp | cms_awp | !@#situation$ | 1 | Aug 15 2006 \\?a02:23PM | Aug 15 2006 \\?a02:23PM |
  162. +--------+--------+---------+----------+---------------+----------+-------------------------+-------------------------+
  163.  
  164.  
  165.  
  166. Table: tblAds
  167.  
  168. +----------------+----------+
  169. | Column | Type |
  170. +----------------+----------+
  171. | AdDescription | varchar |
  172. | AdID | int |
  173. | AdKeywords | varchar |
  174. | AdName | varchar |
  175. | AdThumbnailUrl | varchar |
  176. | AdTitle | varchar |
  177. | AdUrl | varchar |
  178. | IsShowHome | bit |
  179. | IsVisible | bit |
  180. | LastUpdated | datetime |
  181. | TimeCreated | datetime |
  182. +----------------+----------+
  183.  
  184.  
  185.  
  186. Table: tblAds
  187.  
  188. +------+-------------------------------------------------------------------+--------+------------------------------+-----------+-----------------------------------+------------+-----------------------------+-----------------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------+
  189. | AdID | AdUrl | AdName | AdTitle | IsVisible | AdKeywords | IsShowHome | TimeCreated | LastUpdated | AdDescription | AdThumbnailUrl |
  190. +------+-------------------------------------------------------------------+--------+------------------------------+-----------+-----------------------------------+------------+-----------------------------+-----------------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------+
  191. | 21 | http://www.pakistanarmy.gov.pk/AWPReview/TextContent.aspx?pId=378 | Left | Hilal April 2013 Urdu | 1 | Hilal magzine,ISPR | 1 | Dec \\?a05 2006 12:30PM | Dec \\?a05 2006 12:30PM | November 2012 Hilal Urdu | http://www.pakistanarmy.gov.pk/hilal/onlinemagazine/embed_edition_thumbnail.aspx?id_mag_edition=latest&id_magazine=8 |
  192. | 23 | http://www.pakistanarmy.gov.pk/AWPReview/TextContent.aspx?pId=382 | Left | Hilal April 2013 English | 1 | hilal,publication,monthly,magzine | 1 | Dec \\?a05 2006 12:30PM | Dec \\?a05 2006 12:30PM | November 2012 Hilal | http://www.pakistanarmy.gov.pk/hilal/onlinemagazine/embed_edition_thumbnail.aspx?id_mag_edition=latest&id_magazine=7 |
  193. | 24 | http://www.pakistanarmy.gov.pk/AWPReview/TextContent.aspx?pId=354 | Left | Press Review - February 2013 | 1 | Press Review,ISPR,Magzine,Monthly | 0 | Mar 19 2009 \\?a03:01AM | Mar 19 2009 \\?a03:01AM | Press Review | http://www.pakistanarmy.gov.pk/hilal/onlinemagazine/embed_edition_thumbnail.aspx?id_mag_edition=latest&id_magazine=9 |
  194. | 25 | http://www.pakistanarmy.gov.pk/AWPReview/TextContent.aspx?pId=398 | Left | Shuhadas Corner | 1 | Shaheeds Pakistan War | 1 | Apr \\?a09 2010 \\?a08:31AM | Apr \\?a09 2010 \\?a08:31AM | <blank> | tn_shuhadas copy.jpg |
  195. +------+-------------------------------------------------------------------+--------+------------------------------+-----------+-----------------------------------+------------+-----------------------------+-----------------------------+--------------------------+----------------------------------------------------------------------------------------------------------------------+
  196.  
  197.  
  198.  
  199. Database:db_shuhadas_corner
  200.  
  201. +--------------+
  202. | Dist |
  203. | Ops |
  204. | Unit |
  205. | sqlmapoutput |
  206. | tbl_medals |
  207. | tbl_settings |
  208. | tbl_shuhada |
  209. +--------------+
  210.  
  211.  
  212.  
  213.  
  214. Table: tbl_medals
  215.  
  216. +-----------------+---------+
  217. | Column | Type |
  218. +-----------------+---------+
  219. | has_pic | int |
  220. | id | int |
  221. | medal_abbr | varchar |
  222. | medal_full_name | varchar |
  223. | seq | int |
  224. +-----------------+---------+
  225.  
  226.  
  227.  
  228.  
  229. Table: tbl_medals
  230.  
  231. +----+-----+---------+------------+------------------------------+
  232. | id | seq | has_pic | medal_abbr | medal_full_name |
  233. +----+-----+---------+------------+------------------------------+
  234. | 10 | 1 | 1 | NH | Nishan i Haider |
  235. | 11 | 6 | 1 | S BT | Sitara i Basalat |
  236. | 12 | 4 | 1 | SJ | Sitara i Jurrat |
  237. | 13 | 100 | 1 | TI(M) | Tamgha i Imtiaz (Military) |
  238. | 14 | 5 | 1 | TJ | Tamgha i Juraat |
  239. | 15 | 10 | 1 | TK-III | Tamgha i Khidmat (Class III) |
  240. | 16 | 8 | 1 | TK-I | Tamgha i Khidmat (Class I) |
  241. | 17 | 9 | 1 | TK-II | Tamgha i Khidmat (Class II) |
  242. | 18 | 7 | 1 | T BT | Tamgha i Basalat |
  243. | 6 | 200 | 1 | C_CARD | COAS's COMMENDATION CARD |
  244. | 7 | 3 | 1 | HJ | Hilal i Jurrat |
  245. | 8 | 2 | 1 | HK | Hilal i Kashmir |
  246. | 9 | 101 | 1 | NI(M) | Nishan i Imtiaz (Military) |
  247. +----+-----+---------+------------+------------------------------+
  248.  
  249.  
  250.  
  251.  
  252. Table: tbl_shuhada
  253.  
  254. +------------------------+----------+
  255. | Column | Type |
  256. +------------------------+----------+
  257. | arm_for_offr_only | nvarchar |
  258. | army_no | bigint |
  259. | award | nvarchar |
  260. | category_offr_jco_sldr | nvarchar |
  261. | cause_of_shahadat | nvarchar |
  262. | centre | nvarchar |
  263. | date_of_shahadat | datetime |
  264. | district | nvarchar |
  265. | fmn | nvarchar |
  266. | full_name | nvarchar |
  267. | has_pic | int |
  268. | id | int |
  269. | incomplete_entry | tinyint |
  270. | operation | nvarchar |
  271. | place_of_shahadat | nvarchar |
  272. | prefix | nvarchar |
  273. | rank | nvarchar |
  274. | seq | int |
  275. | tehsil | nvarchar |
  276. | visible | tinyint |
  277. +------------------------+----------+
  278.  
  279.  
  280.  
  281.  
  282.  
  283. Table: tbl_shuhada
  284.  
  285. +-------+---------+-----+---------------+-------+--------+---------+---------+---------+---------+---------+----------+------------------------+------------------+------------------+-------------------------+-------------------+-------------------+--------------------------------------+------------------------+
  286. | id | fmn | seq | rank | award | centre | prefix | tehsil | has_pic | army_no | visible | district | operation | full_name | incomplete_entry | date_of_shahadat | arm_for_offr_only | cause_of_shahadat | place_of_shahadat | category_offr_jco_sldr |
  287. +-------+---------+-----+---------------+-------+--------+---------+---------+---------+---------+---------+----------+------------------------+------------------+------------------+-------------------------+-------------------+-------------------+--------------------------------------+------------------------+
  288. | 11232 | FCNA | 11 | Hav | NH | NLI | <blank> | <blank> | 1 | 2841030 | 1 | Ghizer | Koh-e-Paima | Lalak Jan | 0 | Jul \\?a07 1999 12:00AM | <blank> | Enemy action | Kargil Sector | JCOs Sldrs |
  289. | 1313 | <blank> | 4 | Maj | NH | CORO | PA | <blank> | 1 | 2695 | 1 | Gujrat | 1965 | Raja Aziz Bhatti | 0 | Sep 10 1965 12:00AM | Punjab | Killed in action | Lahore Border | Offrs |
  290. | 15180 | PAF | 5 | Pilot Officer | NH | NULL | PAF | <blank> | 1 | 5602 | 1 | <blank> | Training Flight - 1971 | Rashid Minhas | 0 | Aug 20 1971 12:00AM | PAF | Plain crash | 32 miles short of the eastern border | NULL |
  291. | 1668 | <blank> | 8 | Maj | NH | CORO | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> | <blank> |
  292. +-------+---------+-----+---------------+-------+--------+---------+---------+---------+---------+---------+----------+------------------------+------------------+------------------+-------------------------+-------------------+-------------------+--------------------------------------+------------------------+
  293.  
  294.  
  295.  
  296.  
  297.  
  298. Database:master
  299.  
  300. +---------------------------------------------------+
  301. | INFORMATION_SCHEMA.CHECK_CONSTRAINTS |
  302. | INFORMATION_SCHEMA.COLUMNS |
  303. | INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE |
  304. | INFORMATION_SCHEMA.COLUMN_PRIVILEGES |
  305. | INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE |
  306. | INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE |
  307. | INFORMATION_SCHEMA.DOMAINS |
  308. | INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS |
  309. | INFORMATION_SCHEMA.KEY_COLUMN_USAGE |
  310. | INFORMATION_SCHEMA.PARAMETERS |
  311. | INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS |
  312. | INFORMATION_SCHEMA.ROUTINES |
  313. | INFORMATION_SCHEMA.ROUTINE_COLUMNS |
  314. | INFORMATION_SCHEMA.SCHEMATA |
  315. | INFORMATION_SCHEMA.TABLES |
  316. | INFORMATION_SCHEMA.TABLE_CONSTRAINTS |
  317. | INFORMATION_SCHEMA.TABLE_PRIVILEGES |
  318. | INFORMATION_SCHEMA.VIEWS |
  319. | INFORMATION_SCHEMA.VIEW_COLUMN_USAGE |
  320. | INFORMATION_SCHEMA.VIEW_TABLE_USAGE |
  321. | spt_fallback_db |
  322. | spt_fallback_dev |
  323. | spt_fallback_usg |
  324. | spt_monitor |
  325. | spt_values |
  326. | sys.all_columns |
  327. | sys.all_objects |
  328. | sys.all_parameters |
  329. | sys.all_sql_modules |
  330. | sys.all_views |
  331. | sys.allocation_units |
  332. | sys.assemblies |
  333. | sys.assembly_files |
  334. | sys.assembly_modules |
  335. | sys.assembly_references |
  336. | sys.assembly_types |
  337. | sys.asymmetric_keys |
  338. | sys.backup_devices |
  339. | sys.certificates |
  340. | sys.change_tracking_databases |
  341. | sys.change_tracking_tables |
  342. | sys.check_constraints |
  343. | sys.column_type_usages |
  344. | sys.column_xml_schema_collection_usages |
  345. | sys.columns |
  346. | sys.computed_columns |
  347. | sys.configurations |
  348. | sys.conversation_endpoints |
  349. | sys.conversation_groups |
  350. | sys.conversation_priorities |
  351. | sys.credentials |
  352. | sys.crypt_properties |
  353. | sys.cryptographic_providers |
  354. | sys.data_spaces |
  355. | sys.database_audit_specification_details |
  356. | sys.database_audit_specifications |
  357. | sys.database_files |
  358. | sys.database_mirroring |
  359. | sys.database_mirroring_endpoints |
  360. | sys.database_mirroring_witnesses |
  361. | sys.database_permissions |
  362. | sys.database_principal_aliases |
  363. | sys.database_principals |
  364. | sys.database_recovery_status |
  365. | sys.database_role_members |
  366. | sys.databases |
  367. | sys.default_constraints |
  368. | sys.destination_data_spaces |
  369. | sys.dm_audit_actions |
  370. | sys.dm_audit_class_type_map |
  371. | sys.dm_broker_activated_tasks |
  372. | sys.dm_broker_connections |
  373. | sys.dm_broker_forwarded_messages |
  374. | sys.dm_broker_queue_monitors |
  375. | sys.dm_cdc_errors |
  376. | sys.dm_cdc_log_scan_sessions |
  377. | sys.dm_clr_appdomains |
  378. | sys.dm_clr_loaded_assemblies |
  379. | sys.dm_clr_properties |
  380. | sys.dm_clr_tasks |
  381. | sys.dm_cryptographic_provider_properties |
  382. | sys.dm_database_encryption_keys |
  383. | sys.dm_db_file_space_usage |
  384. | sys.dm_db_index_usage_stats |
  385. | sys.dm_db_mirroring_auto_page_repair |
  386. | sys.dm_db_mirroring_connections |
  387. | sys.dm_db_mirroring_past_actions |
  388. | sys.dm_db_missing_index_details |
  389. | sys.dm_db_missing_index_group_stats |
  390. | sys.dm_db_missing_index_groups |
  391. | sys.dm_db_partition_stats |
  392. | sys.dm_db_persisted_sku_features |
  393. | sys.dm_db_script_level |
  394. | sys.dm_db_session_space_usage |
  395. | sys.dm_db_task_space_usage |
  396. | sys.dm_exec_background_job_queue |
  397. | sys.dm_exec_background_job_queue_stats |
  398. | sys.dm_exec_cached_plans |
  399. | sys.dm_exec_connections |
  400. | sys.dm_exec_procedure_stats |
  401. | sys.dm_exec_query_memory_grants |
  402. | sys.dm_exec_query_optimizer_info |
  403. | sys.dm_exec_query_resource_semaphores |
  404. | sys.dm_exec_query_stats |
  405. | sys.dm_exec_query_transformation_stats |
  406. | sys.dm_exec_requests |
  407. | sys.dm_exec_sessions |
  408. | sys.dm_exec_trigger_stats |
  409. | sys.dm_filestream_file_io_handles |
  410. | sys.dm_filestream_file_io_requests |
  411. | sys.dm_fts_active_catalogs |
  412. | sys.dm_fts_fdhosts |
  413. | sys.dm_fts_index_population |
  414. | sys.dm_fts_memory_buffers |
  415. | sys.dm_fts_memory_pools |
  416. | sys.dm_fts_outstanding_batches |
  417. | sys.dm_fts_population_ranges |
  418. | sys.dm_io_backup_tapes |
  419. | sys.dm_io_cluster_shared_drives |
  420. | sys.dm_io_pending_io_requests |
  421. | sys.dm_os_buffer_descriptors |
  422. | sys.dm_os_child_instances |
  423. | sys.dm_os_cluster_nodes |
  424. | sys.dm_os_dispatcher_pools |
  425. | sys.dm_os_dispatchers |
  426. | sys.dm_os_hosts |
  427. | sys.dm_os_latch_stats |
  428. | sys.dm_os_loaded_modules |
  429. | sys.dm_os_memory_allocations |
  430. | sys.dm_os_memory_brokers |
  431. | sys.dm_os_memory_cache_clock_hands |
  432. | sys.dm_os_memory_cache_counters |
  433. | sys.dm_os_memory_cache_entries |
  434. | sys.dm_os_memory_cache_hash_tables |
  435. | sys.dm_os_memory_clerks |
  436. | sys.dm_os_memory_node_access_stats |
  437. | sys.dm_os_memory_nodes |
  438. | sys.dm_os_memory_objects |
  439. | sys.dm_os_memory_pools |
  440. | sys.dm_os_nodes |
  441. | sys.dm_os_performance_counters |
  442. | sys.dm_os_process_memory |
  443. | sys.dm_os_ring_buffers |
  444. | sys.dm_os_schedulers |
  445. | sys.dm_os_spinlock_stats |
  446. | sys.dm_os_stacks |
  447. | sys.dm_os_sublatches |
  448. | sys.dm_os_sys_info |
  449. | sys.dm_os_sys_memory |
  450. | sys.dm_os_tasks |
  451. | sys.dm_os_threads |
  452. | sys.dm_os_virtual_address_dump |
  453. | sys.dm_os_wait_stats |
  454. | sys.dm_os_waiting_tasks |
  455. | sys.dm_os_windows_info |
  456. | sys.dm_os_worker_local_storage |
  457. | sys.dm_os_workers |
  458. | sys.dm_qn_subscriptions |
  459. | sys.dm_repl_articles |
  460. | sys.dm_repl_schemas |
  461. | sys.dm_repl_tranhash |
  462. | sys.dm_repl_traninfo |
  463. | sys.dm_resource_governor_configuration |
  464. | sys.dm_resource_governor_resource_pools |
  465. | sys.dm_resource_governor_workload_groups |
  466. | sys.dm_server_audit_status |
  467. | sys.dm_server_memory_dumps |
  468. | sys.dm_server_registry |
  469. | sys.dm_server_services |
  470. | sys.dm_tran_active_snapshot_database_transactions |
  471. | sys.dm_tran_active_transactions |
  472. | sys.dm_tran_commit_table |
  473. | sys.dm_tran_current_snapshot |
  474. | sys.dm_tran_current_transaction |
  475. | sys.dm_tran_database_transactions |
  476. | sys.dm_tran_locks |
  477. | sys.dm_tran_session_transactions |
  478. | sys.dm_tran_top_version_generators |
  479. | sys.dm_tran_transactions_snapshot |
  480. | sys.dm_tran_version_store |
  481. | sys.dm_xe_map_values |
  482. | sys.dm_xe_object_columns |
  483. | sys.dm_xe_objects |
  484. | sys.dm_xe_packages |
  485. | sys.dm_xe_session_event_actions |
  486. | sys.dm_xe_session_events |
  487. | sys.dm_xe_session_object_columns |
  488. | sys.dm_xe_session_targets |
  489. | sys.dm_xe_sessions |
  490. | sys.endpoint_webmethods |
  491. | sys.endpoints |
  492. | sys.event_notification_event_types |
  493. | sys.event_notifications |
  494. | sys.events |
  495. | sys.extended_procedures |
  496. | sys.extended_properties |
  497. | sys.filegroups |
  498. | sys.foreign_key_columns |
  499. | sys.foreign_keys |
  500. | sys.fulltext_catalogs |
  501. | sys.fulltext_document_types |
  502. | sys.fulltext_index_catalog_usages |
  503. | sys.fulltext_index_columns |
  504. | sys.fulltext_index_fragments |
  505. | sys.fulltext_indexes |
  506. | sys.fulltext_languages |
  507. | sys.fulltext_stoplists |
  508. | sys.fulltext_stopwords |
  509. | sys.fulltext_system_stopwords |
  510. | sys.function_order_columns |
  511. | sys.http_endpoints |
  512. | sys.identity_columns |
  513. | sys.index_columns |
  514. | sys.indexes |
  515. | sys.internal_tables |
  516. | sys.key_constraints |
  517. | sys.key_encryptions |
  518. | sys.linked_logins |
  519. | sys.login_token |
  520. | sys.master_files |
  521. | sys.master_key_passwords |
  522. | sys.message_type_xml_schema_collection_usages |
  523. | sys.messages |
  524. | sys.module_assembly_usages |
  525. | sys.numbered_procedure_parameters |
  526. | sys.numbered_procedures |
  527. | sys.objects |
  528. | sys.openkeys |
  529. | sys.parameter_type_usages |
  530. | sys.parameter_xml_schema_collection_usages |
  531. | sys.parameters |
  532. | sys.partition_functions |
  533. | sys.partition_parameters |
  534. | sys.partition_range_values |
  535. | sys.partition_schemes |
  536. | sys.partitions |
  537. | sys.plan_guides |
  538. | sys.procedures |
  539. | sys.remote_logins |
  540. | sys.remote_service_bindings |
  541. | sys.resource_governor_configuration |
  542. | sys.resource_governor_resource_pools |
  543. | sys.resource_governor_workload_groups |
  544. | sys.routes |
  545. | sys.schemas |
  546. | sys.securable_classes |
  547. | sys.server_assembly_modules |
  548. | sys.server_audit_specification_details |
  549. | sys.server_audit_specifications |
  550. | sys.server_audits |
  551. | sys.server_event_notifications |
  552. | sys.server_event_session_actions |
  553. | sys.server_event_session_events |
  554. | sys.server_event_session_fields |
  555. | sys.server_event_session_targets |
  556. | sys.server_event_sessions |
  557. | sys.server_events |
  558. | sys.server_file_audits |
  559. | sys.server_permissions |
  560. | sys.server_principal_credentials |
  561. | sys.server_principals |
  562. | sys.server_role_members |
  563. | sys.server_sql_modules |
  564. | sys.server_trigger_events |
  565. | sys.server_triggers |
  566. | sys.servers |
  567. | sys.service_broker_endpoints |
  568. | sys.service_contract_message_usages |
  569. | sys.service_contract_usages |
  570. | sys.service_contracts |
  571. | sys.service_message_types |
  572. | sys.service_queue_usages |
  573. | sys.service_queues |
  574. | sys.services |
  575. | sys.soap_endpoints |
  576. | sys.spatial_index_tessellations |
  577. | sys.spatial_indexes |
  578. | sys.spatial_reference_systems |
  579. | sys.sql_dependencies |
  580. | sys.sql_expression_dependencies |
  581. | sys.sql_logins |
  582. | sys.sql_modules |
  583. | sys.stats |
  584. | sys.stats_columns |
  585. | sys.symmetric_keys |
  586. | sys.synonyms |
  587. | sys.sysaltfiles |
  588. | sys.syscacheobjects |
  589. | sys.syscharsets |
  590. | sys.syscolumns |
  591. | sys.syscomments |
  592. | sys.sysconfigures |
  593. | sys.sysconstraints |
  594. | sys.syscurconfigs |
  595. | sys.syscursorcolumns |
  596. | sys.syscursorrefs |
  597. | sys.syscursors |
  598. | sys.syscursortables |
  599. | sys.sysdatabases |
  600. | sys.sysdepends |
  601. | sys.sysdevices |
  602. | sys.sysfilegroups |
  603. | sys.sysfiles |
  604. | sys.sysforeignkeys |
  605. | sys.sysfulltextcatalogs |
  606. | sys.sysindexes |
  607. | sys.sysindexkeys |
  608. | sys.syslanguages |
  609. | sys.syslockinfo |
  610. | sys.syslogins |
  611. | sys.sysmembers |
  612. | sys.sysmessages |
  613. | sys.sysobjects |
  614. | sys.sysoledbusers |
  615. | sys.sysopentapes |
  616. | sys.sysperfinfo |
  617. | sys.syspermissions |
  618. | sys.sysprocesses |
  619. | sys.sysprotects |
  620. | sys.sysreferences |
  621. | sys.sysremotelogins |
  622. | sys.sysservers |
  623. | sys.system_columns |
  624. | sys.system_components_surface_area_configuration |
  625. | sys.system_internals_allocation_units |
  626. | sys.system_internals_partition_columns |
  627. | sys.system_internals_partitions |
  628. | sys.system_objects |
  629. | sys.system_parameters |
  630. | sys.system_sql_modules |
  631. | sys.system_views |
  632. | sys.systypes |
  633. | sys.sysusers |
  634. | sys.table_types |
  635. | sys.tables |
  636. | sys.tcp_endpoints |
  637. | sys.trace_categories |
  638. | sys.trace_columns |
  639. | sys.trace_event_bindings |
  640. | sys.trace_events |
  641. | sys.trace_subclass_values |
  642. | sys.traces |
  643. | sys.transmission_queue |
  644. | sys.trigger_event_types |
  645. | sys.trigger_events |
  646. | sys.triggers |
  647. | sys.type_assembly_usages |
  648. | sys.types |
  649. | sys.user_token |
  650. | sys.via_endpoints |
  651. | sys.views |
  652. | sys.xml_indexes |
  653. | sys.xml_schema_attributes |
  654. | sys.xml_schema_collections |
  655. | sys.xml_schema_component_placements |
  656. | sys.xml_schema_components |
  657. | sys.xml_schema_elements |
  658. | sys.xml_schema_facets |
  659. | sys.xml_schema_model_groups |
  660. | sys.xml_schema_namespaces |
  661. | sys.xml_schema_types |
  662. | sys.xml_schema_wildcard_namespaces |
  663. | sys.xml_schema_wildcards |
  664. +---------------------------------------------------+
  665.  
  666.  
  667.  
  668.  
  669. Table: sys.syslogins
  670.  
  671. +---------------+-----------+
  672. | Column | Type |
  673. +---------------+-----------+
  674. | language | nvarchar |
  675. | accdate | datetime |
  676. | bulkadmin | int |
  677. | createdate | datetime |
  678. | dbcreator | int |
  679. | dbname | nvarchar |
  680. | denylogin | int |
  681. | diskadmin | int |
  682. | hasaccess | int |
  683. | isntgroup | int |
  684. | isntname | int |
  685. | isntuser | int |
  686. | loginname | nvarchar |
  687. | name | nvarchar |
  688. | password | nvarchar |
  689. | processadmin | int |
  690. | resultlimit | int |
  691. | securityadmin | int |
  692. | serveradmin | int |
  693. | setupadmin | int |
  694. | sid | varbinary |
  695. | spacelimit | int |
  696. | status | smallint |
  697. | sysadmin | int |
  698. | timelimit | int |
  699. | totcpu | int |
  700. | totio | int |
  701. | updatedate | datetime |
  702. +---------------+-----------+
  703.  
  704.  
  705.  
  706.  
  707. Table: sys.syslogins
  708.  
  709. +----------+------------+-------+--------+--------+--------+-----------------------------+----------+----------+----------+----------+------------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+------------+-----------------------------+------------+------------+-------------------------+-------------+-------------+--------------+---------------+
  710. | sid | name | totio | totcpu | dbname | status | accdate | sysadmin | isntuser | password | isntname | loginname | dbcreator | denylogin | isntgroup | bulkadmin | hasaccess | diskadmin | timelimit | spacelimit | createdate | setupadmin | [language] | updatedate | resultlimit | serveradmin | processadmin | securityadmin |
  711. +----------+------------+-------+--------+--------+--------+-----------------------------+----------+----------+----------+----------+------------+-----------+-----------+-----------+-----------+-----------+-----------+-----------+------------+-----------------------------+------------+------------+-------------------------+-------------+-------------+--------------+---------------+
  712. | \x01 | sa | 0 | 0 | master | 9 | Apr \\?a08 2003 \\?a09:10AM | 1 | 0 | NULL | 0 | sa | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | Apr \\?a08 2003 \\?a09:10AM | 0 | us_english | Nov 20 2012 \\?a03:43PM | 0 | 0 | 0 | 0 |
  713. | ╓ី鑰䍤䪚ퟆ㸌径 | p_user_pak | 0 | 0 | master | 9 | Nov 15 2012 \\?a05:07AM | 0 | 0 | NULL | 0 | p_user_pak | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | Nov 15 2012 \\?a05:07AM | 0 | us_english | Apr \\?a05 2013 11:13AM | 0 | 0 | 0 | 0 |
  714. +----------+------------+-------+--------+--------+--------+-----------------------------+----------+----------+----------+----------+------------+-----------+-----------+-----------+-----------
  715.  
  716.  
  717.  
  718.  
  719.  
  720. Table: sys.dm_os_memory_cache_hash_tables
  721.  
  722. +------------------------------+-----------+
  723. | Column | Type |
  724. +------------------------------+-----------+
  725. | buckets_avg_length | int |
  726. | buckets_avg_scan_hit_length | int |
  727. | buckets_avg_scan_miss_length | int |
  728. | buckets_count | int |
  729. | buckets_in_use_count | int |
  730. | buckets_max_length_ever | int |
  731. | buckets_min_length | int |
  732. | cache_address | varbinary |
  733. | hits_count | bigint |
  734. | misses_count | bigint |
  735. | name | nvarchar |
  736. | table_level | int |
  737. +------------------------------+-----------+
  738.  
  739.  
  740.  
  741.  
  742.  
  743. Table: sys.credentials
  744.  
  745. +---------------------+----------+
  746. | Column | Type |
  747. +---------------------+----------+
  748. | create_date | datetime |
  749. | credential_id | int |
  750. | credential_identity | nvarchar |
  751. | modify_date | datetime |
  752. | name | nvarchar |
  753. | target_id | int |
  754. | target_type | nvarchar |
  755. +---------------------+----------+
  756.  
  757.  
  758.  
  759.  
  760.  
  761.  
  762. Table: sys.database_role_members
  763.  
  764. +-------------------+---------------------+
  765. | role_principal_id | member_principal_id |
  766. +-------------------+---------------------+
  767. | 16384 | 1 |
  768. +-------------------+---------------------+
  769.  
  770.  
  771.  
  772.  
  773.  
  774. Table: sys.sql_logins
  775.  
  776. +-----------------------+-----------+
  777. | Column | Type |
  778. +-----------------------+-----------+
  779. | create_date | datetime |
  780. | credential_id | int |
  781. | default_database_name | nvarchar |
  782. | default_language_name | nvarchar |
  783. | is_disabled | bit |
  784. | is_expiration_checked | bit |
  785. | is_policy_checked | bit |
  786. | modify_date | datetime |
  787. | name | nvarchar |
  788. | password_hash | varbinary |
  789. | principal_id | int |
  790. | sid | varbinary |
  791. | type_desc | nvarchar |
  792. +-----------------------+-----------+
  793.  
  794.  
  795.  
  796.  
  797.  
  798. Table: sys.user_token
  799.  
  800. +--------------+-----------+
  801. | Column | Type |
  802. +--------------+-----------+
  803. | usage | nvarchar |
  804. | name | nvarchar |
  805. | principal_id | int |
  806. | sid | varbinary |
  807. | type | nvarchar |
  808. +--------------+-----------+
  809.  
  810.  
  811.  
  812.  
  813. Table: sys.user_token
  814.  
  815. +-------------------+--------------+---------+---------+---------+
  816. | sid | principal_id | name | type | [usage] |
  817. +-------------------+--------------+---------+---------+---------+
  818. | ԁ..ऀ\x04.ᩇ걒怮䠕肊㜣�噒 | <blank> | <blank> | <blank> | <blank> |
  819. | ԁ..ऀ\x04.ᩇ걒怮䠕肊㜣�噒 | <blank> | <blank> | <blank> | <blank> |
  820. +-------------------+--------------+---------+---------+---------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement