Tuesday, June 26, 2018

Console Query - \Monitoring\Overview\Distribution Status\Distribution Point Group Status

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: