{"id":4774,"date":"2015-05-18T14:43:15","date_gmt":"2015-05-18T12:43:15","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/"},"modified":"2015-05-18T14:43:15","modified_gmt":"2015-05-18T12:43:15","slug":"get-the-main-information-from-sql-server-databases-with-powershell","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/","title":{"rendered":"Get the main information from SQL Server databases with PowerShell"},"content":{"rendered":"

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell<\/a>, I will present you this time how to retrieve the SQL Server databases information with PowerShell.
\nDisclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will be glad to read your comments!<\/p>\n

Retrieve SQL Server databases information<\/h3>\n

I use the SMO objects to access the instance information. In my previous blog, I explaind how to initialize the SMO object from a specific instance.
\nMoreover, I also described how to list all installed SQL Server instances on Windows Server.
\nSo, I assume the SMO object from the SQL Server instance has already been initialized, referring to this blog<\/a>.<\/p>\n

To display the main information of your databases, proceed as follows:<\/p>\n

\"databases_main_information.png\"<\/a><\/p>\n

You can also obtain the data files information details about your databases. However, be aware that the data files are organized in File Groups. Here is the code which shows how to proceed:<\/p>\n

\"datafiles_information.png\"<\/a><\/p>\n

To obtain the log files information, it is a little bit faster. Indeed, log files are not hierarchized in File Groups.<\/p>\n

\"logfiles_information.png\"<\/a><\/p>\n

There are some important configuration options in SQL Server for the databases. These options are important to know. I show you how to retrieve them:<\/p>\n

\"database_main_options.png\"<\/a><\/p>\n

If you format your output, you can obtain report, dashboards, aso\u2026 Here is a capture of an existing dashboard from our Database Management Kit (DMK)<\/a>.<\/p>\n

\"database_dmk.png\"<\/a><\/p>\n

Next steps<\/h3>\n

If you want to learn more about the methods and properties included in the database SMO object, you should use the \u201cGet-Member\u201d command:<\/p>\n

\"smo_object_database_properties_methods.png\"<\/a><\/p>\n

I hope this blog will help you. Of course, the SMO object is not the only approach. It can easily be done with the “sqlcmd” command for example.<\/p>\n","protected":false},"excerpt":{"rendered":"

As I promised in my previous blog Get the main Administration Information from SQL Server with PowerShell, I will present you this time how to retrieve the SQL Server databases information with PowerShell. Disclaimer: I am not a developer but a SQL Server dba. If you find errors or some ways of improvement, I will […]<\/p>\n","protected":false},"author":14,"featured_media":4775,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[559,272,51],"type_dbi":[],"class_list":["post-4774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-dmk","tag-powershell","tag-sql-server"],"acf":[],"yoast_head":"\nGet the main information from SQL Server databases with PowerShell - dbi Blog<\/title>\n<meta name=\"description\" content=\"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get the main information from SQL Server databases with PowerShell\" \/>\n<meta property=\"og:description\" content=\"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-18T12:43:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"448\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"Get the main information from SQL Server databases with PowerShell\",\"datePublished\":\"2015-05-18T12:43:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/\"},\"wordCount\":304,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/databases_main_information.png\",\"keywords\":[\"DMK\",\"PowerShell\",\"SQL Server\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/\",\"name\":\"Get the main information from SQL Server databases with PowerShell - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/databases_main_information.png\",\"datePublished\":\"2015-05-18T12:43:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/databases_main_information.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/databases_main_information.png\",\"width\":360,\"height\":448},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/get-the-main-information-from-sql-server-databases-with-powershell\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get the main information from SQL Server databases with PowerShell\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \\\/ Banking, etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/nathan-courtine\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Get the main information from SQL Server databases with PowerShell - dbi Blog","description":"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/","og_locale":"en_US","og_type":"article","og_title":"Get the main information from SQL Server databases with PowerShell","og_description":"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.","og_url":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/","og_site_name":"dbi Blog","article_published_time":"2015-05-18T12:43:15+00:00","og_image":[{"width":360,"height":448,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"Get the main information from SQL Server databases with PowerShell","datePublished":"2015-05-18T12:43:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/"},"wordCount":304,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png","keywords":["DMK","PowerShell","SQL Server"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/","url":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/","name":"Get the main information from SQL Server databases with PowerShell - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png","datePublished":"2015-05-18T12:43:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"Tihs blog presents how to retrieve the SQL Server databases information with PowerShell.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/databases_main_information.png","width":360,"height":448},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/get-the-main-information-from-sql-server-databases-with-powershell\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Get the main information from SQL Server databases with PowerShell"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4774"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4774\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4775"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4774"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}