1 of 1 people found this helpful
Overall number of managed servers - distinct by name
Duplicates from multiple ETLs are reduced. You only get charged for a single entities regardless of how many ETLs populate the data for the entity.
To clarify the question a bit.
This is the report that is being asked about. Many others in this same area. Worth taking a look about.
Probably in your TSCO application tree | Click Works | Add | Add Report
Next | Advanced Report | Next | Select Diagnostic then 'Auditing - Managed Servers | next
Take the defaults | Next | Finish.
Run the report
Open the Excel sheet. Sheet1 is the result that prompted the question.
The first sheet might be different for each various releases. Below is an example from 11.5.01 w/ latest patches. The column labeled Number of managed servers - distinct by name is expected to match the total licenses after removing duplicates.
In some earlier versions, this was reported as a single row at the end of the table with the row labeled Number of managed servers - distinct by name.
If you back to 10.x releases distinct by name information is only present with the latest CHF for each release.
Servers Count Summary at April 2, 2020 16:07:59 Product name Number of managed servers Number of managed servers - distinct by name TrueSight Capacity Optimizer for Servers 332098 225519 TrueSight Capacity Optimizer for Servers [Capacity Agents] 1098 908
My Favorite Mr. Mike West,
Yes I stand corrected.
Still the navigation to those reports are not well known and sometimes helpful.
And my, what a large environment you have!
Is 47% of the environment (33k/22k) a typical delta between managed servers and distinct by name managed servers?
While my counts are much smaller, our environment has a 40% delta.
Thanks for sharing the navigation to create the reports. The report is useful and can be overlooked in the documentation.
In more recent releases, 11.3.xx+, we added the detailed data from that report to the Administration | Maintenance | License Tracking utility so that the details are now present with the official report. There is also a summary report provided by the utility that is now in a human readable format.
The delta between the managed servers and distinct by name is interesting topic and from what I have seen it varies in range. Usually, I see the delta in the less than 20% range. For the numbers I presented, the environment is similar to a performance and scale testing environment and has duplicates because we are not sharing catalogs and we are trying to simulate heavy load conditions treating each record as a separate entity regardless of the name.
Michael D. West
This is a very interesting topic for a customer of ours -- they'd like to understand how the numbers in the summary page of the "Auditing - Manager Servers" report are calculated?
Just today, we have been looking at the SQL in the audit_managed_server.rptdesign file, and also directly at the AUDIT_LIC table, and none of the numbers exactly match those in the report (over 10% difference). This customer is trying really hard to keep their #servers under the BMC licensed value, and are running very close to their limit, so want a way to track it accurately via SQL.. Can you help?
What is the "most valid" way to get the actual licensed server number out with SQL?
I suggest reviewing the detailed list which has the actual servers counted.