OneScript Team Blog

A world of automation script samples based on IT Pros' real-world tasks

[Script Of July 24] How to get detailed information of a SQL Server (T-SQL)

[Script Of July 24] How to get detailed information of a SQL Server (T-SQL)

  • Comments 1
  • Likes
image image
July
24
image

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-get-detailed-ac767add.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

This T-SQL script will demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

As many people ask how to get general information of SQL Server, this script will demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment