Get database count, database name & database creation date from SQL Servers using Powershell

Hi Folks,

I want some automation, I need consolidated information in .csv for all SQL Servers which are in different domain.

I need below four information only:

1) Instance name

2) database count for that instance

3) databases name for that instance

4) database creation date for that instance

I have no idea how to connect to servers of different domains and how to achieve this task.

Parents
  • Community forums are really not free code writing services, that is what consultants are for, 8^}, yea, I know, they cost money.  8^} … and all of us like free stuff.

    However, We are more than happy to help you with code you've written and having issue / confusion with.

    In order to do that, you have to show your work.

    You have already outlined what you'd like to do and a quick web search using the 'powershell' + 'your specific info point', would return many hits and samples.

    All-in-all, this is just and, 'How can I inventory my DB servers' kind of question and there are lots of web sites with step by step instructions on how to do that. Even pre-built scripts that you can user as they are (after you review them and make sure you know what they do / are doing), that you can tweak as needed via the MS powershellgallery.com

    ----

        PowerShell - SQL Inventory - Automatic - Excel File - EMAIL

        Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of the servers you manage.Download

        'gallery.technet.microsoft.com/scriptcenter/PowerShell-SQL-Inventory-e9b92dac'


        powershell for sql server inventory

        Inventory of sql servers and databases from a csv list of servers.Original Script downloaded from here, alterations and additions made to Create an inventory of datababes and database propertiesIterates throught the List of servers  Outputting to an Excel Sheet.  It then iterate

        'gallery.technet.microsoft.com/scriptcenter/powershell-for-sql-server-a9af7b91'


        PowerShell Server Inventory
        Part 1: SQL Database Build
        'learn-powershell.net/2017/02/27/powershell-server-inventory-part-1-sql-database-build'

        Part 2: Collecting and Sending Data
        'learn-powershell.net/2017/04/02/powershell-server-inventory-part-2-collecting-and-sending-data'

        Part 3: Viewing the Inventory using a UI
        'learn-powershell.net/2017/05/09/powershell-server-inventory-part-3-viewing-the-inventory-using-a-ui'

        Let PowerShell do an Inventory of your Servers
        '.red-gate.com/simple-talk/sql/database-administration/let-powershell-do-an-inventory-of-your-servers'

    ----

Reply Children
No Data