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
– 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.