I have an automation requirement below, Could you please help if this is feasible using AAV11 ?
1.I need to open SSMS in a server/machine and click on connect icon ,enter the details to connect with server
2.Run SQL Script and take the screen shot of the results window.(Note: If we have multiple results need to scroll down the window/page and take the screenshot)
3.Right click on one of the tables and go to properties and take the screenshot of results window.
4.Now whatever the screenshots took above ,come back to an excel sheet and paste it one by one.
5.Disconnect from the server and connect to another server and perform the same steps again for multiple servers.
As per the commands available in v11 I believe we can connect to database and perform some operations in the backend. Just wondering if we can perform the foreground operations which I mentioned above with SQL .