UCSM doesn't have any built-in mechanisms to do what you are asking.
UCS FI do NOT learn mac addresses upstream (on uplinks). Can use this fact to your advantage.
`show mac address-table` should only show actively in-use endpoints (and the corresponding VLAN).
Could easily write a tiny script to pull mac address tables periodically.
Any VLAN with a MAC entry on the FIs has a VM/server behind that FI actively using the VLAN.
Any VLAN with NO MAC entry on the FIs (over time) can likely be safely removed.
Careful that "silent host" VMs might age out of the mac table over time, so there could be some false negative using this method.
Also be sure to check *both* FIs and not just one FI.
Could maybe do SNMP, but I'd probably write an `expect` script (or ansible or some other new fangled tool) just 'cuz I know I could probably make it work.