How can we help you today? How can we help you today?

Powershell API to pull out sql server version/ build/ server info

hi there:
  just wonder which command below I should use to pull out sql server version/edition/disk size info?  and any sample script I can use? 

Thanks


Huey
  

Huey
1

Comments

2 comments

Sort by
  • Christian Perez
    Official comment

    Hi Huey,

    The information you are looking for should be able to be pulled if you utilize the REST API available with Redgate Monitor Enterprise, if you have the proper license of course. If you are a Standard Monitor Subscriber however, I would give Thomas Bishops sample script above a shot and see if it gets you those details,

    https://documentation.red-gate.com/monitor/rest-api-in-monitor-enterprise-240976357.html

    Christian Perez
  • Gene Baker

    Thank you for providing the additional information and the documentation link. It sounds like the required details can be retrieved through the REST API if the environment is licensed for Redgate Monitor Enterprise. For environments using the Standard Monitor subscription, Thomas Bishop’s sample script appears to be a practical alternative worth testing. The clarification is much appreciated. @ slope 2

    Gene Baker
    -1

Add comment

Please sign in to leave a comment.