Getting a quick MPS/HMC statistics...

  • Article

Want to get some quick statistics on your HMC environment, specifically, what's in the MPS database? I have a script to share with you guys,

The script is the following link,

https://blogs.technet.com/cfs-file.ashx/__key/CommunityServer-Blogs-Components-WeblogFiles/00-00-00-69-82-Scripts/8484.QuickStats.ps1.txt

What you need to do is to open up this Powershell script and change the highlighted SQL server and the SQL DB as in the following highlighted portion,

$sqlserver = "MPSSQL01"
$sqldb = "PlanManager"

Then just run it. This script will provide you the following information,

  1. The number of Reseller in your environment
  2. The number of Organization found in each Reseller
  3. Total number of users in the environment
  4. The Organization with the largest number of users
  5. Total number of contacts in the environment
  6. The Organization with the largest number of contacts
  7. Total number of groups in the environment
  8. The Organization with the largest number of groups
  9. Total number of mail enable users in the environment
  10. Number of SMTP domains

Please take note that the above information is based on the MPS database and this is applicable only to HMC 4.x.

The script will dump out 2 CSV files. One with all the SMTP domains in the environment and another with all the quick stats above. You should see the output on the screen as well.

Enjoy and let me know if you have problem with the script.