Information about \Monitoring\Overview\Distribution Status\Distribution Point Group Status
Console information come from file
C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\XmlStorage\ConsoleRoot in MonitoringNode.xml
and from SMSProv.log (C:\Program Files\Microsoft Configuration Manager\Log)
"Distribution Point Group Status"
Execute WQL =SELECT * FROM SMS_DPGroupInfo
Execute SQL =select all SMS_DPGroupInfo.AssignedContentCount,SMS_DPGroupInfo.Description,SMS_DPGroupInfo.FeatureType,SMS_DPGroupInfo.GroupID,SMS_DPGroupInfo.MembersCount,SMS_DPGroupInfo.Name,SMS_DPGroupInfo.ErrorContentCount,SMS_DPGroupInfo.InProgressContentCount,SMS_DPGroupInfo.SuccessContentCount,SMS_DPGroupInfo.UnknownContentCount from vSMS_DPGroupInfo AS SMS_DPGroupInfo
Filter here is NOT a query filter but a console filter
Example line above = these below informations (GroupID change for each line)
GroupID = {0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}
Name = All Distribution Points
Description = All Distribution Points Worldwide
MembersCount = 2827
FeatureType = 9
AssignedContentCount = 13
SuccessContentCount = 0
InProgressContentCount = 0
ErrorContentCount = 13
UnknownContentCount = 0
"Distribution Point Group Status"-> View Status
Get Object GroupID
GetObjectAsync : SMS_DPGroupInfo.GroupID="{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}"
then get informations
Execute WQL =select * from SMS_DPGroupInfo WHERE GroupID = "{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}"
Execute SQL =select all SMS_DPGroupInfo.AssignedContentCount,SMS_DPGroupInfo.Description,SMS_DPGroupInfo.FeatureType,SMS_DPGroupInfo.GroupID,SMS_DPGroupInfo.MembersCount,SMS_DPGroupInfo.Name,SMS_DPGroupInfo.ErrorContentCount,SMS_DPGroupInfo.InProgressContentCount,SMS_DPGroupInfo.SuccessContentCount,SMS_DPGroupInfo.UnknownContentCount from vSMS_DPGroupInfo AS SMS_DPGroupInfo where SMS_DPGroupInfo.GroupID = N'{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}'
Then display MessageType "Success" using vSMS_DPGroupDistributionStatus
1 = Success
Execute WQL =SELECT * FROM SMS_DPGroupDistributionStatus WHERE GroupID = '{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND MessageType = 1
Execute SQL =select all SMS_DPGroupDistributionStatus.Assets,SMS_DPGroupDistributionStatus.ContentCount,SMS_DPGroupDistributionStatus.GroupID,SMS_DPGroupDistributionStatus.MessageCategory,SMS_DPGroupDistributionStatus.MessageState,SMS_DPGroupDistributionStatus.StatusTime from vSMS_DPGroupDistributionStatus AS SMS_DPGroupDistributionStatus where (SMS_DPGroupDistributionStatus.GroupID = N'{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND SMS_DPGroupDistributionStatus.MessageState = 1)
2 = InProgress
Execute WQL =SELECT * FROM SMS_DPGroupDistributionStatus WHERE GroupID = '{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND MessageType = 2
Execute SQL =select all SMS_DPGroupDistributionStatus.Assets,SMS_DPGroupDistributionStatus.ContentCount,SMS_DPGroupDistributionStatus.GroupID,SMS_DPGroupDistributionStatus.MessageCategory,SMS_DPGroupDistributionStatus.MessageState,SMS_DPGroupDistributionStatus.StatusTime from vSMS_DPGroupDistributionStatus AS SMS_DPGroupDistributionStatus where (SMS_DPGroupDistributionStatus.GroupID = N'{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND SMS_DPGroupDistributionStatus.MessageState = 2)
4 = Error
Execute WQL =SELECT * FROM SMS_DPGroupDistributionStatus WHERE GroupID = '{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND MessageType = 4
Execute SQL =select all SMS_DPGroupDistributionStatus.Assets,SMS_DPGroupDistributionStatus.ContentCount,SMS_DPGroupDistributionStatus.GroupID,SMS_DPGroupDistributionStatus.MessageCategory,SMS_DPGroupDistributionStatus.MessageState,SMS_DPGroupDistributionStatus.StatusTime from vSMS_DPGroupDistributionStatus AS SMS_DPGroupDistributionStatus where (SMS_DPGroupDistributionStatus.GroupID = N'{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND SMS_DPGroupDistributionStatus.MessageState = 4)
5 = Unknow
Execute WQL =SELECT * FROM SMS_DPGroupDistributionStatus WHERE GroupID = '{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND MessageType = 5
Execute SQL =select all SMS_DPGroupDistributionStatus.Assets,SMS_DPGroupDistributionStatus.ContentCount,SMS_DPGroupDistributionStatus.GroupID,SMS_DPGroupDistributionStatus.MessageCategory,SMS_DPGroupDistributionStatus.MessageState,SMS_DPGroupDistributionStatus.StatusTime from vSMS_DPGroupDistributionStatus AS SMS_DPGroupDistributionStatus where (SMS_DPGroupDistributionStatus.GroupID = N'{0D30A907-B1BE-427D-AA91-7E2E5B5AE5C4}' AND SMS_DPGroupDistributionStatus.MessageState = 5)
No comments:
Post a Comment