Need power shell script for database and SQL instance inventory.
$30-250 USD
Completed
Posted over 4 years ago
$30-250 USD
Paid on delivery
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]
hello. I hope you're doing well. im an expert in sql and powershell and have written many scripts similar to this one. I am ready to get started right away, so send me a message when you're ready so we can chat about it.
what version if powershell do you need to target?
thanks.
Kenneth Garza
$150 USD in 2 days
5.0 (5 reviews)
4.4
4.4
5 freelancers are bidding on average $172 USD for this job
Hello?
How are you?
I am excited to work with you on this project.
I have good skills in those.
So I think I can help you if you want.
So i hope to discuss your project vis chat deeply.
Thanks. Best regards.
I CAN COMPLETE YOUR PROJECT EASILY
Hello, I am software developer with enough experiences on C# for 13 years.
I can work by full time for your project and trying to satisfy the requirements.
I am designing the project from scratch and structure it well.
I am following the project's design process exactly, and if any error is found, fix it within 24 hours and provide maintenance free of charge for a month.
Client's idea + Programmer's good coding is the perfect result, this is my idea.
I want to keep long-term relationship for customer so I want to give the nice result.
C#/.Net is very powerful programming language and I am majoring on it for long years.
If you want the perfect result, please contact with me.
Greetings,
I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert.
--
Best regards,
Davit Dartsimelia
Senior BI & SQL Developer
Hi Hiring manager
I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you.
1* I can do Data RESEARCH from any platform for certain subjects.
2* I can create the accurate DATABASE (EMAIL/CONTACTS/PERSONAL INFO etc*.
2* I can properly fill a Google Sheet/EXCEL/WORD. Have good working skills of Excel/PDF.
4* I am Expert in DATA ENTRY and do any kind of that work.
5* I can Find data from INTERNET RESEARCH/ WEB SCRAPING.
6* I can Work as a VIRTUAL ASSISTANT for daily any kind of task.
7* I can work as per client TIME ZONE if they want and provideS 15hrs services in a day.
8* I have 3YRS of good experience of as a VIRTUAL ASSISTANT and done various type of task.
9* I have the excellent skill of SEO/DIGITAL MARKETING/SOCIAL MEDIA MARKETING/MANAGEMENT.
10* I can create MEMES/posting,strategy for increasing likes,followers of social media.
11* I have expertise in WORDPRESS sites creating/product Uploading/WOOCOMMERCE.
12* I have Good skills in SHOPIFY, PRESTASHOP, MAGENTO etc for DROPSHIPPING.
13* I Can Write Optimized SEO friendly impressive articles for BLOG and get 1 rank.
14* I am fast Learner. Grab The instructions from client instantly and implement.
15* I can get 100% results and Give Guaranteed work satisfaction from client instructions.
for work i am always available and take the challenges and never say no to work always be ready and be professional in work.
thanks