Before doing any activity (Example :Applying Patches) on prod servers, we are MANUALLY
doing pre/post verifications on servers. The verifications checklist includes following items:
1. SQL INSTANCE NAME
2. NO OF DATABASES
3. DATABASE STATUS (ONLINE/OFFLINE)
4. Online Physical Server Name
5. SQL START TIME
6. SERVER UP TIME
7. SQL PRODUCT VERSION/PRODUCT LEVEL/PRODUCT EDITION
Now, we want to do this activity as automated (With Centralized)
through Poweshell scripting & TSQL CODE and results/output should be in the form of CSV file
I have created stored proc with TSQL and we have to integrate this code with powershell.
I am totally new to Powershell technology, so need help from Powershell Exprts.
Please give your suggestions on above requirement (how to integrate attached stored proc with powershell).
Thanks in Advance.