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.
Before extracting, you might will need to Unblock the package from Properties -> General -> Security.
2. Now run the file name "
" with admin privileges. It will automatically trigger the SQL script and will generate the results at same location in a file called "
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
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
BME table row
TME table row
Relationship table row
ECL table row
RecursiveMembership table row
JobStatus table row
WindowsWorkflowTaskJobStatus table row
Rules Count table row
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 firstname.lastname@example.org for any queries or concerns.