Help us in understanding your workload

Hi everyone. We need your help to have more understanding of your workloads to have better planning of future product enhancements. As a part of this exercise, we are sharing a script with you to collect some important information. This script will not collect any Personally identifiable information (PII) and will generate a readable CSV file containing just the counts of different objects in your database. This process will take only a few minutes and you can easily review generated output file (and delete any portion, if needed) and can verify it before sharing results with us.

How to collect & share the data?

 

  1. Download the package from here and extract (or copy the extracted files) it on your SM CMDB server (SM's SQL server).

 Before extracting, you might will need to Unblock the package from Properties -> General -> Security.

 

2.       Now run the file name "RunMe.bat" with admin privileges. It will automatically trigger the SQL script and will generate the results at same location in a file called "Output.csv". 

Please note: If your SM database is installed on a named SQL instance or you are remotely running this script, then edit the "RunMe.bat" and update the "@ConnectionString" variable in first line of the "RunMe.bat" file. Set the variable as <ServerName>\<InstanceName> for named instances and just <ServerName> for default instance.
 
3.       Now if you want, then you can read the generated output file (Output.csv) in any CSV viewer like Microsoft Excel. The generated output will not collect any Personally identifiable information (PII) and will just contain the counts of different objects in your database. If you want, then you can also delete any part of information before sharing those results with us.
 
4.       After this, please share the generated "Output.csv" file with us at veharshv@microsoft.com

 

What all Information will be collected?

 

This script will not collect any Personally identifiable information (PII) and will just collect the following data-

  • Information of installed URs (KB, Version, Date when applied)
  • Count of Management servers
  • Count of Work Items as per their status
  • Average Age of work items as per status
  • Inflow rate – Count of work items created in last 7 days (for each day) along with source
  • Count of runbook activities and runbooks
  • Count of type DCM & SCOM Incidents
  • Work Item Retention Setting values (In minutes)
  • Count of Announcements as per their status
  • Count of Knowledge Articles as per their status
  • Count of Request Offering as per their status
  • Count of Service Offering as per their status
  • Count of Notification Subscriptions with Status
  • Count of different Config Items
  • Count of Workflows with status
  • Count of Queues
  • Count of Groups
  • Count of Catalog Groups
  • Count of SLA objects
  • General stats
    • BME table row Count
    • TME table row Count
    • Relationship table row Count
    • ECL table row Count
    • RecursiveMembership table row Count
    • JobStatus table row Count
    • WindowsWorkflowTaskJobStatus table row Count
    • Rules Count table row Count
  • Count of top 50 instance type that contributes the most to the ECL table
  • Count of top 50 relationship type contributes the most to the ECL table

 

We really appreciate your help for the growth of the product. Please feel free to reach us at veharshv@microsoft.com for any queries or concerns.