Monthly Archives: May 2014

PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL

Posted on May 21, 2014 by Prashanth Jayaram

This script is used to discover all the server information and captures disk drive utilization details. The drive details are aggregated based on the status of free space. The aggregated data is pictorially represented usingΒ pie chart. The excel sheet is … Continue reading →

Posted in Uncategorized | Tagged , , , , , | 4 Comments

SQL – List All Tables, Space Usage Info & Other Details

Posted on May 1, 2014 by Prashanth Jayaram

One of the OP requested in the forum to find all table details of any database.Β The details which includes Number of Rows,table size, index size etc:-.Β Even I frequently writing queries to list all such details. I’ve used SQLCMD mode to … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment