Need power shell script for database and SQL instance inventory.

Need 2 powershell script: Purpose: Create an inventory of SQL databases and SQL instances ( instance and Windows machine) and store in two different table 1) I will run the [login to view URL] script from my machine. 2) It will read a textfile from C:\Jamil\[login to view URL] where one server name per row (Sample file attached) 3) It will insert the values in SQL table called [dbo].[Databases] similar to SQLDatabaseInfo tab in the attached EXCEL 4) I will run the second script [login to view URL] it will read the same file as before c:\Jamil\[login to view URL] and insert the values in [login to view URL] table similar to SQLServerInfo tab in the attached EXCEL 5) In one of my SQL instance, I will create DBA database which will have 2 tables [login to view URL] and [login to view URL] For your reference here is the template for Databases table -- Create table [login to view URL] CREATE TABLE [dbo].[Databases]( [DatabaseID] [int] IDENTITY(1,1) NOT NULL, [InstanceName] [varchar](50) NOT NULL, [DatabaseName] [varchar](200) NOT NULL, [CreateDate] [varchar](10) NOT NULL, [Status] [varchar](10) NOT NULL, [UPdatebility] [varchar](20) NOT NULL, [db_size] varchar [varchar](20) NOT NULL, [DatafileSize] varchar [varchar](20) NOT NULL, [LogFileSize] varchar [varchar](20) NOT NULL, [Owner] [varchar](100) NOT NULL, [RecoveryModel] [varchar](10) NOT NULL, [LoadDate] [date] NOT NULL, CONSTRAINT [PK_Databases__DatabaseID] PRIMARY KEY CLUSTERED ( [DatabaseID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ** You need to write the script in such a way that once I execute the script it will insert the values in [login to view URL] and [login to view URL] table. SQL instance name where DBA database resides can be given hard coded. -- Create table [login to view URL] CREATE TABLE [dbo].[Databases]( [DatabaseID] [int] IDENTITY(1,1) NOT NULL, [InstanceName] [varchar](50) NOT NULL, [DatabaseName] [varchar](200) NOT NULL, [CreateDate] [varchar](10) NOT NULL, [Status] [varchar](10) NOT NULL, [UPdatebility] [varchar](20) NOT NULL, [db_size] varchar [varchar](20) NOT NULL, [DatafileSize] varchar [varchar](20) NOT NULL, [LogFileSize] varchar [varchar](20) NOT NULL, [Owner] [varchar](100) NOT NULL, [RecoveryModel] [varchar](10) NOT NULL, [LoadDate] [date] NOT NULL, CONSTRAINT [PK_Databases__DatabaseID] PRIMARY KEY CLUSTERED ( [DatabaseID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]