I will discuss here how performance data for VMs are populated in SCOM when SCOM and VMM integration are in place.

 

I have an issue where we are not able to see any performance data for VMs. There is a SCOM and SCVMM integration in place.

 

– Checked the performance view and we could see that view if blank for virtual machines.

– Checked the rules and found that all are enabled.

– Checked the status of “Virtual Machine Manager Management Group” and found that it is healthy.

– Checked the event logs of VMM server and found that there are many login failure for the account “VMMMon”

– Checked the run as account for VMM “Virtual Machine Manager Connection Account”

– Found that we are using the account “VMMMon”

– So now we have granted the permission to VMM database

– Now the error is not coming.

– Also checked the configuration of the workflow which is collecting the data for VMs

– Found that there is a PowerShell script which is running to capture the data from VMM.

GetAllVMUsage.PS1

 

https://systemcenter.wiki/?GetElement=Microsoft.SystemCenter.VirtualMachineManager.2012.Report.TimedPowerShell.VMUsagePerformanceProvider&Type=DataSourceModuleType&ManagementPack=Microsoft.SystemCenter.VirtualMachineManager.2012.Reports&Version=3.2.8002.0

 

– So thought of running the script manually.

– Found that data is still not come in OperationsManager database.

– Run the script manually and it is returning the data.

– Run the following query to check.

 

USE OperationsManager
SELECT [Path], ObjectName, CounterName, InstanceName, SampleValue, TimeSampled
FROM PerformanceDataAllView pdv with (NOLOCK)
inner join PerformanceCounterView pcv on pdv.performancesourceinternalid = pcv.performancesourceinternalid
inner join BaseManagedEntity bme on pcv.ManagedEntityId = bme.BaseManagedEntityId
where --CounterName like 'CPU' and
ObjectName like 'VM'
ORDER BY TimeSampled DESC

 

– Now found that data was available for 04th of April when integration between VMM and SCOM was done.

– Also observed few account related issues for the account scomuser

– So we have removed the object from the run as profiles.

– Found that there was a change in run as account and run as profile for VMM.

– Found that under run as profile “Virtual Machine Manager Connection Account” it is targeted to windows computer for each objects.

– So decided to replicate the same in my lab and will check.

– Before doing that took a ETL trace from my Lab SCOM server and found that the workflow is running from SCOM servers.

– Now we have change the run as account as like your infra and found the below error.

Error :

Log Name:      Operations Manager
Source:        Health Service Script
Date:          4/25/2019 8:45:22 PM
Event ID:      108
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:       server.domain.root
Description:
StorageObjectsDiscovery.DS.ps1 :
[20:45:22:491]Storage Discovery: Got errors creating a PS session to VMM.Cannot process argument transformation on parameter ‘Credential’. PromptForCredential

 

– Observed the same error in customer infra as well.

 

– So now we have removed all the windows computer association and added “All target Objects” in run as profile “Virtual Machine Manager Connection Account”

 

– Now after few minutes, we could see the following events.

 

Log Name:      Operations Manager
Source:        Health Service Script
Date:          4/25/2019 8:24:31 PM
Event ID:      108
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:       server.domain.root
Description:
StorageObjectsDiscovery.DS.ps1 :
[20:24:31:921]Storage Discovery: Got VMMServer. Module imported.

Log Name:      Operations Manager
Source:        Health Service Script
Date:          4/25/2019 8:24:31 PM
Event ID:      108
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:       server.domain.root
Description:
StorageObjectsDiscovery.DS.ps1 :
[20:24:31:931]  -VMMServerPropertyID “{430A9F15-4036-6443-C339-8FD93511422D}”  -StoragePoolMSSupportedProvisioningTypesPropertyID “{6C0AA40A-068E-620F-8C49-350D1A359867}”  -StoragePoolSupportedProvisioningTypesPropertyID “{176EF8AA-9B6A-5422-2127-0AF7D97BEB9E}”  -StoragePoolMSClassID “{A2DC226F-42B4-3582-7CDF-75A1853B2BBB}”  -StorageVolumeMSUniqueIDPropertyID “{9F1E39DD-2B39-9E36-F27D-664D07947D3B}”  -StorageLogicalUnitRemainingCapacityPropertyID “{7BEBCF1A-C683-D446-4872-C1AB8EE5000B}”  -FileServerClusterNamePropertyID “{EF23D445-3F5C-7338-DDD3-076E0F1D8FAE}”  -StorageArrayClusterNamePropertyID “{09A73AE0-808C-49AE-A719-0B28BE5319B0}”  -FileShareSharePathPropertyID “{79AF555E-0AE6-AF2E-4801-06D8359E3595}”  -StoragePoolMSStorageClassificationPropertyID “{F05D4253-1D0C-4941-80A6-9682775EE89D}”  -HostVolumeClassID “{1D1EF761-03B4-558A-7FB6-F2358A9DD0FA}”  -FileServerStorageNodesPropertyID “{77DED6AE-A2C2-1D0C-DD3E-CCD6FB005928}”  -FileShareSMBShareNamePropertyID “{623A67F3-A43A-CE9A-B4B7-8DA8C47344DC}”  -StorageLogicalUnitPrimordialPropertyID “{B69F8B2C-B4E3-DEB4-756D-AA0B8385DC47}”  -HostVolumeCapacityPropertyID “{DE9ED1D2-F9FB-8574-FCA3-57828AB84370}”  -StoragePoolMSPrimordialPropertyID “{8CA5B9E3-E55A-F8B3-B667-85520FD4338A}”  -StoragePoolSpacesResiliencySettingNameDefaultPropertyID “{4BCCA34A-01AC-BAAC-8B2D-679D12672508}”  -StoragePoolSpacesClassID “{30DF16CD-F3AE-BDF7-DABD-F7B29B342053}”  -StoragePoolStorageOverProvisionPercentID “{3C7EB19D-A034-0939-2B85-175F66CA71F2}”  -VHDVHDTypePropertyID “{A772F82B-05F5-4AC9-1CA1-BAF49A241DC5}”  -StorageLogicalUnitTotalCapacityPropertyID “{4DD43A03-7933-F09D-60E4-B0365931FBA6}”  -VMHostDiskLocationPropertyID “{78FCB9D8-AFF4-785C-CAC3-1C9B8BAAA561}”  -EnclosureModelPropertyID “{F852D874-A4D1-467B-85BE-C0D5B8DBDE57}”  -FileShareMSVMMServerPropertyID “{170E3B72-EEF0-1845-A719-194C3FD43675}”  -FileServerModelPropertyID “{531CD8CC-5287-9122-0870-49B6F02BF952}”  -StoragePoolSpacesIsReadOnlyPropertyID “{5F9F21BD-DE99-0ABD-C75C-E2FF89F6DB63}”  -TargetID “{1AD28B22-A8D7-85A8-631E-51EE5B8090FE}”  -FileShareSMBClassID “{465DE962-14D6-BAE6-D6E5-A71BBB4E0749}”  -StoragePoolClassID “{80E5028A-5EAB-6128-AC3D-ADF5B94BF5F3}”  -FileShareMSClusterNamePropertyID “{ED33E698-1486-BE56-3E8D-65064E6C5646}”  -ElementID “{81DF1014-4A6D-025D-3FAE-D1937A605CBF}”  -VMHostDiskIsSanAttachedPropertyID “{95DC3AD5-5C56-DC97-A5FB-0363EBE7A7D9}”  -EntityDisplayNameKey “{AFB4F9E6-BF48-1737-76AD-C9B3EC325B97}”  -VMHostDiskCapacityPropertyID “{6DADCFC5-9016-6E77-3DA3-50737F45D2DA}”  -ComputerPrincipalNameKey “{5C324096-D928-76DB-E9E7-E629DCC261B1}”  -FileShareMSContainsFileShareVMMRelationID “{42332D34-C876-1E2F-32EB-C018ACA18F31}”  -FileShareMSContainsVirtualMachineRelationID “{1860B841-D377-ECE0-C6E6-C465D6109697}”  -HostVolumeIsClusteredPropertyID “{25C5EABC-1CEA-0CA6-F5FC-BB6754140098}”  -HostAssociationsPropertyID “{8CF28E4A-31A0-D0A1-EE5C-FE5E0324F2F2}”  -FileServerClassID “{04BE9C8B-D738-BF63-5406-AE1FF74F51FE}”  -VMHostDiskDiskIDPropertyID “{3C5BBC6A-415B-DCA2-910E-2C30DC43770C}”  -FileShareMSIsManagedPropertyID “{77511AAD-6616-6DF3-FD58-001B97669C28}”  -StorageProviderTypePropertyID “{3B386FD1-9F00-F27D-2F6C-8E5DE14DD0DE}”  -StoragePoolMSContainsEnclosureRelationID “{2414A8A8-6AE2-D402-2DB5-84D9B4559BDB}”  -FileShareMSSharePathPropertyID “{4CBB3076-F943-0DF5-597E-10AB5B9EDF64}”  -FileServerTypePropertyID “{B1CA61B5-DAF0-A8F6-B76C-49515834C573}”  -VHDReferencesHostVolumeClassID “{9EE41E40-75BB-6544-2896-8679FD171B11}”  -StoragePoolSpacesDescriptionPropertyID “{E66737D6-3C61-0836-A489-3AE517015667}”  -StoragePoolMSDescriptionPropertyID “{5378D06A-3763-031F-5704-717DA4B25676}”  -StoragePoolStorageClassificationPropertyID “{0CF6EB4F-2615-C0FB-FC29-345C12BCCF71}”  -EnclosureNumberOfSlotsPropertyID “{B0A6B214-0752-2C46-4A8E-6708B05D6AFD}”  -StoragePoolDescriptionPropertyID “{C442A655-6963-08F7-D87B-744434509732}”  -HostVolumeClassificationPropertyID “{9F51B895-0EE2-6F75-39E1-8C5957ED58D1}”  -FileShareMSStorageClassificationPropertyID “{C2B6D23C-994B-69A5-1EBD-F005154858D0}”  -StoragePoolSpacesProvisioningTypeDefaultPropertyID “{56A55FCD-C474-9E4A-FBF6-320A8F12BF2C}”  -VMHostDiskIsClusteredPropertyID “{310F8D7A-FC09-FD78-D562-A4DB5B45C7FA}”  -StorageVolumeMSIDPropertyID “{4E97CF9A-8F47-C9FC-259C-18C1D16741CE}”  -ArrayReferencesFileServerClassID “{F78DA0B9-61B7-50AF-96B0-4DC7FEF14277}”  -FileShareStorageClassificationPropertyID “{CEF026D2-CED2-A077-5D16-36F69EBC494F}”  -FileServerFreeSpacePropertyID “{3E3D21B5-2ED2-7164-D804-0CB9395A6328}”  -StoragePoolMSIDPropertyID “{3AAD69A5-DCA0-6B6B-6B13-EA2BB150FF4B}”  -StoragePoolMSProvisioningTypeDefaultPropertyID “{D0C267E3-1B46-45AD-D182-1D3CFE5FFCD6}”  -VMHostDiskClassID “{DB870EF9-4D41-22E9-FEF8-53DD903FFF6D}”  -StorageArrayModelPropertyID “{01A8F98F-BBB5-88E9-C2C9-92E900CB7D1A}”  -FileShareSMBIDPropertyID “{49FCF1E7-5584-87B3-27A3-6C43BEC9B01F}”  -FileShareMSUniqueIDPropertyID “{77CF8BD4-802F-BE3A-434F-D3C18FED2F2B}”  -StorageLogicalUnitThinlyProvisionedPropertyID “{3F44A8BC-434A-FD9E-E32B-01EA16D92BD9}”  -HostVolumeIsClusterSharedVolumePropertyID “{3733193C-C4B8-F95F-0C9F-F5C9E99D0E27}”  -FileShareFreeSpacePropertyID “{952F5A62-725E-A8C3-5C47-E1D073ADEF81}”  -StorageLogicalUnitNumberOfBlocksPropertyID “{2A930015-8A9E-4D03-3271-094378431418}”  -StoragePoolPrimordialPropertyID “{40EE41C8-E509-C48D-9EAD-5C00FD256098}”  -FileShareSMBSharePathPropertyID “{810F36DD-9825-C463-F709-8EA58B462F5F}”  -FileShareSMBStorageFileServerPropertyID “{3E37B52F-0FAC-300B-76B2-0A3CED41569C}”  -StoragePoolMSStorageOverProvisionPercentID “{4E49ADCD-2D33-BB3E-6114-730D7CAB1565}”  -EnclosureFirmwareVersionPropertyID “{6DF7A70E-FA1C-5943-0FFC-272208B17E79}”  -StorageLogicalUnitContainsVMHostDiskClassID “{C46F3522-684F-723E-2342-437DC29B0447}”  -FileShareMSDescriptionPropertyID “{65F3867D-5AB9-06AC-C908-938B4ECAACA4}”  -StoragePoolMSContainsStoragePoolRelationID “{D83D1432-F974-2827-9D3B-774505DEB5D7}”  -VirtualDiskDriveReferencesVMHostDiskClassID “{F6CE57EB-70E0-510E-316A-A5B154C2150A}”  -HostVolumeIsAvailableForPlacementPropertyID “{58F21312-51DA-6430-2A06-4EF0E069DAB1}”  -FileShareSMBDescriptionPropertyID “{607BB23C-BF45-5E83-F84F-EA0AD44D7675}”  -StorageVolumeMSIsCSVPropertyID “{03D4F9A9-9391-303E-EC2A-4FF40B78D4CB}”  -EnclosureUniqueIDPropertyID “{1A406B1C-7B4B-B6E3-5EE8-0297A94B35B1}”  -StoragePoolSpacesUniqueIDPropertyID “{446DAFC2-10E0-C5AF-F8A1-C0F197256409}”  -StorageArrayIDPropertyID “{05AD9297-3F6A-2B29-1253-AA6EA6AE76BC}”  -FileServerManufacturerPropertyID “{E5599323-C79C-5554-A6B0-B3A4A10E12CF}”  -VHDCurrentSizePropertyID “{7D613F56-EA2F-B179-AC79-560D4F58B8E6}”  -ComputerName “VMM2016.Mscloud07.com”  -StoragePoolIDPropertyID “{6CBB9E47-1426-CB15-014C-871A225154AD}”  -FileShareStorageVolumeIDPropertyID “{B3918023-2867-7C59-1967-5586E7E6F5C6}”  -HostVolumeVolumeLabelPropertyID “{DD05B160-9CAF-84F9-02D3-664DAE43A145}”  -VHDLocationPropertyID “{C40B3931-0A04-6A0A-7222-1CD4E87248D1}”  -FileShareSMBCapacityPropertyID “{B652683E-2E37-CEB7-01AB-FBDE5253F60F}”  -HostVolumeIDPropertyID “{36F3650D-CCA0-660D-EBBE-F922AEBB4C12}”  -EnclosureManufacturerPropertyID “{696075A7-A9EB-D269-31B8-399BB051044B}”  -EnclosureClassID “{8A33906D-F676-AD23-8666-3DEB8D16EB57}”  -FileShareIsAvailableForPlacementPropertyID “{73C4A61E-E82E-E381-4972-DBB7549FB115}”  -VHDVirtualizationPlatformPropertyID “{31BD37E5-6B7C-93D7-ACA5-8F66E42F06E5}”  -StorageArraySerialNumberPropertyID “{06D04F82-F3A3-6CC5-E66C-DE4BB82FD283}”  -StorageArrayClassID “{3969A08A-5F47-F612-4E07-577893F8BC7B}”  -VDDIDPropertyID “{8F10AE65-C2A3-7D5C-E438-5B5C2399330C}”  -VirtualDiskDriveReferencesVHDClassID “{A9070338-2015-721C-747C-78125C88C385}”  -VDDClassID “{05DDBAA7-9A4E-0591-8E34-C80E2F69037F}”  -FileShareSMBFreeSpacePropertyID “{8FD64579-5181-ABD7-706A-3158C40FE365}”  -VHDClassID “{F3B1ACDD-E924-1391-50AD-EC9C705E4F80}”  -StoragePoolProvisioningTypeDefaultPropertyID “{357F3EF6-3FE1-79F5-9C3C-EBF3D117BFFE}”  -StorageLogicalUnitIDPropertyID “{0CBA594F-70E4-26A6-73BC-C098816323E3}”  -FileShareIsManagedPropertyID “{CF747BB5-5650-66C2-0F2B-305124363CEB}”  -StorageVolumeMSFreeSpacePropertyID “{D1CEF1B8-8398-D8B8-4109-A901A53B4756}”  -StoragePoolSpacesIsClusteredPropertyID “{592228B5-5124-0643-2564-80EA3A1A79E0}”  -EnclosureDeviceIDPropertyID “{50C15B25-5A84-B1FA-5C1A-841CCB0B7FFD}”  -StorageProviderClassID “{8D104DE4-A760-A8FE-DB84-1835B12A6803}”  -StorageVolumeMSCapacityPropertyID “{C3E48595-D796-D6C4-0DF0-851EFDFF9305}”  -StorageLogicalUnitVirtualDiskUniqueIDPropertyID “{DC4F6E92-6EE4-82BF-B28E-F869FC6C22B5}”  -FileServerSerialNumberPropertyID “{28D13C23-E3C4-49D2-9AC0-DFA6A939074D}”  -FileShareCapacityPropertyID “{701235F1-4F12-579F-3717-1D64737D74EB}”  -FileServerVMMServerPropertyID “{7DE6EF05-8845-A632-7C14-10CF9DECBE61}”  -StoragePoolTotalManagedSpacePropertyID “{5BE28DB0-F372-DFF0-3E3F-DDE0A5003312}”  -HostVolumeFreeSpacePropertyID “{1F5E9D2A-5AA3-6280-ED26-FF4C0797BEC7}”  -StoragePoolMSContainsStoragePoolSpacesRelationID “{9CCB2F8A-E2CF-4178-AAF2-4CCE5A48ED18}”  -FileServerIDPropertyID “{41D3187A-D472-E8F7-B26A-E3482501A705}”  -StoragePoolGroupContainsStoragePoolMSClassID “{64CABB65-1EC9-ED46-80CD-5CBC41DC0D78}”  -StorageLogicalUnitStorageClassificationPropertyID “{94280528-C04C-68D5-AACB-D8912F09CDA8}”  -StorageLogicalUnitDescriptionPropertyID “{0C02E523-57DD-E2DD-7E96-2399F4ACA4EA}”  -FileShareClassID “{4797C5E4-509F-63ED-BAA1-9C6C0DBA264E}”  -EnclosureSerialNumberPropertyID “{6B862AE4-080D-D211-3D05-7710D89919FF}”  -VMHostDiskIDPropertyID “{1EBEDEB1-84F0-C0BF-85CA-BCD3421A2EB4}”  -StorageSubsystemUniqueIDPropertyID “{17CC75E9-C8DF-2478-C8F5-D6C08BFF792D}”  -StoragePoolMSTotalManagedSpacePropertyID “{805353C2-3E0E-8628-5B38-9D7781027CD6}”  -FileServerCapacityPropertyID “{2E90ECBF-5E95-8BED-5E0D-88C2861E20E6}”  -FileShareMSContainsFileShareBaseRelationID “{896AC21B-A2F9-BF78-2612-C3F307B5F815}”  -StorageVolumeMSVolumeLabelPropertyID “{9EC8F995-0B81-B929-42F8-6D9DBDBFD73C}”  -FileShareDescriptionPropertyID “{91CAAC3E-2D3A-1660-6EEC-82942F64C3B5}”  -VHDIDPropertyID “{2323BF6C-7713-5C49-4A88-ED981D121522}”  -VMHostDiskSMLunIDPropertyID “{85EB2674-EC30-B294-5D0D-4054519F6FB1}”  -VHDDescriptionPropertyID “{CBEEB35F-4FB0-DDAF-B613-53F8F65C6010}”  -StorageVolumeMSClusterNamePropertyID “{8F0E2694-2732-978C-E90E-648D2F4197ED}”  -StorageProviderIDPropertyID “{C985D9D8-FBEB-B4E8-96DB-07AB4C3EC7D1}”  -StorageArrayManufacturePropertyID “{C6D105D8-6FCA-4703-36D6-789947404B5E}”  -StoragePoolSpacesSupportsDeduplicationPropertyID “{6C594DF5-9D14-11BA-3B16-706CEE600892}”  -VMHostDiskContainsHostVolumeClassID “{734CD839-4002-2E94-945C-12DB895F7834}”  -VMHostDiskAvailableCapacityPropertyID “{2D4C7A1D-B028-E43C-0721-0D579A197103}”  -EnclosureVMMServerPropertyID “{8490F610-DB13-1507-DDDA-714FB11E95AD}”  -VMHostDiskIsPassThroughCapablePropertyID “{EE13C509-2C96-CCC6-9EAE-4E2425FFF232}”  -StorageArrayDescriptionPropertyID “{EB849087-195D-CF95-1E90-AA94B4A6EFAD}”  -FileShareMSClassID “{7D8AC03E-3187-FC24-30F1-85AE5468372B}”  -ClusterAssociationsPropertyID “{A33D8B13-07C6-0495-26D9-2470EDFA48C6}”  -FileShareMSStorageVolumeIDPropertyID “{3616F7CA-9208-804E-F836-892FE2E58DB5}”  -FileServerDescriptionPropertyID “{F0D6DEFD-A7B1-AE95-93F7-BC2ADAD00DDC}”  -StoragePoolSpacesVMMServerPropertyID “{B71E2EE6-2203-83E6-F94E-CF567815855C}”  -VHDVHDFormatTypePropertyID “{6F4E8949-970E-BA01-B897-FA58D7D273D9}”  -StoragePoolGroupClassID “{B8D09224-EF74-2455-E8BA-B01DE812844B}”  -FileShareIDPropertyID “{17A39EFD-D022-58FB-CD7B-33F845FE299E}”  -FileShareSMBStorageVolumeIDPropertyID “{1F37C501-EC17-8373-93DF-7E8B6E855D8C}”  -FileShareMSIDPropertyID “{29971B1F-0885-FA76-5164-697CA7C127A3}”  -FileShareSMBVMMServerPropertyID “{D8EA8839-5B9F-F0CB-C1A2-7158E323EFB7}”  -HostVolumeMountPointsPropertyID “{6A6640BD-44CC-7B6E-6936-A6277543D57E}”  -VMHostIDPropertyID “{D21DF8A8-BCAE-F9A7-5BA8-5FD9DF41A214}”  -StorageVolumeMSClassID “{C6442A82-21EE-EC59-F6D5-CFBCE90A0052}”  -VirtualMachineClassID “{CCF55321-3A62-BFCB-A2EF-F2C1BEA2D008}”  -VirtualMachineIDPropertyID “{A6DD0FAF-A5DC-0625-3FF3-631446D19A20}”  -StorageProviderDescriptionPropertyID “{92CC3E00-BE95-D9EE-3873-56C3299A524E}”  -StorageLogicalUnitBlockSizePropertyID “{2C7E6AE2-CDD9-76CF-4A30-D2F3D04F6AF5}”  -StorageVolumeMSVMMServerPropertyID “{96272AD4-1233-EAAD-B277-BFCEC12F5B85}”  -ArrayReferencesEnclosureID “{63A3A9C3-9B20-1065-457A-49849A7576E7}”  -VHDMaximumSizePropertyID “{1618F0DE-7E9B-0687-C020-140BFA18F2B3}”  -StorageArrayFirmwareVersionPropertyID “{BC2C288C-02A3-541A-459B-9E53E94DE8C3}”  -StorageLogicalUnitClassID “{9DB07CE2-4F14-0693-A643-8AA7EBEEB4BA}”  -StorageVolumeMSClassificationPropertyID “{95E513C9-32FD-3DDF-72B2-BAA12D1BE957}”

 

Log Name:      Operations Manager
Source:        Health Service Script
Date:          4/25/2019 8:24:35 PM
Event ID:      108
Task Category: None
Level:         Information
Keywords:      Classic
User:          N/A
Computer:       server.domain.root
Description:
StorageObjectsDiscovery.DS.ps1 :
[20:24:35:986]
Objects Discovered = 32
Relationships Discovered = 27

 

After some time we could see the data in DB as well in performance graph.