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

Information about \Monitoring\Overview\Distribution Status\Distribution Point Configuration 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\Logs)

1) if you use textbox filter to search XXXX
Execute WQL  =SELECT * FROM SMS_DPStatusInfo WHERE ( (IsPullDP LIKE '%XXXX%'  OR IsDPMonEnabled LIKE '%XXXX%'  OR IsMulticast LIKE '%XXXX%'  OR IsPXE LIKE '%XXXX%'  OR Version LIKE '%XXXX%'  OR Name LIKE '%XXXX%' ) )
Execute SQL =select  all SMS_DPStatusInfo.IsDPMonEnabled,SMS_DPStatusInfo.IsMulticast,SMS_DPStatusInfo.IsPullDP,SMS_DPStatusInfo.IsPXE,SMS_DPStatusInfo.LastStatusTime,SMS_DPStatusInfo.MessageCount,SMS_DPStatusInfo.MessageState,SMS_DPStatusInfo.NALPath,SMS_DPStatusInfo.Name,SMS_DPStatusInfo.NumberErrors,SMS_DPStatusInfo.NumberInProgress,SMS_DPStatusInfo.NumberInstalled,SMS_DPStatusInfo.NumberUnknown,SMS_DPStatusInfo.SccmPXE,SMS_DPStatusInfo.Version from vSMS_DPStatusInfo AS SMS_DPStatusInfo  where (((((SMS_DPStatusInfo.IsPullDP like N'%XXXX%' OR SMS_DPStatusInfo.IsDPMonEnabled like N'%XXXX%') OR SMS_DPStatusInfo.IsMulticast like N'%XXXX%') OR SMS_DPStatusInfo.IsPXE like N'%XXXX%') OR SMS_DPStatusInfo.Version like N'%XXXX%') OR SMS_DPStatusInfo.Name like N'%XXXX%')

2) By default if you do not use filter
Execute WQL  =SELECT * FROM SMS_DPStatusInfo
Execute SQL =select  all SMS_DPStatusInfo.IsDPMonEnabled,SMS_DPStatusInfo.IsMulticast,SMS_DPStatusInfo.IsPullDP,SMS_DPStatusInfo.IsPXE,SMS_DPStatusInfo.LastStatusTime,SMS_DPStatusInfo.MessageCount,SMS_DPStatusInfo.MessageState,SMS_DPStatusInfo.NALPath,SMS_DPStatusInfo.Name,SMS_DPStatusInfo.NumberErrors,SMS_DPStatusInfo.NumberInProgress,SMS_DPStatusInfo.NumberInstalled,SMS_DPStatusInfo.NumberUnknown,SMS_DPStatusInfo.SccmPXE,SMS_DPStatusInfo.Version from vSMS_DPStatusInfo AS SMS_DPStatusInfo

3) Distribution Point Status Details
Execute WQL  =SELECT * FROM SMS_DPStatusDetails WHERE NALPath = '["Display=\\\\COMPUTERNAME.MYDOMAIN.NET\\"]MSWNET:["SMS_SITE=XYZ"]\\\\COMPUTERNAME.MYDOMAIN.NET\\'
Execute SQL =select  all SMS_DPStatusDetails.DPName,SMS_DPStatusDetails.ID,SMS_DPStatusDetails.InsString1,SMS_DPStatusDetails.InsString10,SMS_DPStatusDetails.InsString2,SMS_DPStatusDetails.InsString3,SMS_DPStatusDetails.InsString4,SMS_DPStatusDetails.InsString5,SMS_DPStatusDetails.InsString6,SMS_DPStatusDetails.InsString7,SMS_DPStatusDetails.InsString8,SMS_DPStatusDetails.InsString9,SMS_DPStatusDetails.LastStatusTime,SMS_DPStatusDetails.MessageCategory,SMS_DPStatusDetails.MessageFullID,SMS_DPStatusDetails.MessageID,SMS_DPStatusDetails.MessageSeverity,SMS_DPStatusDetails.MessageState,SMS_DPStatusDetails.NALPath,SMS_DPStatusDetails.PackageID,SMS_DPStatusDetails.SiteCode,SMS_DPStatusDetails.StatusMsgID from vSMS_DPStatusDetails AS SMS_DPStatusDetails  where SMS_DPStatusDetails.NALPath = N'["Display=\\COMPUTERNAME.MYDOMAIN.NET\"]MSWNET:["SMS_SITE=XYZ"]\\COMPUTERNAME.MYDOMAIN.NET\'

4) Specific Status Distribution Point Status Details
in 1st get object ID
 GetObjectAsync : SMS_DPStatusDetails.ID="126111"
Then get object details
Execute WQL  =select * from SMS_DPStatusDetails WHERE ID = "126111"
Execute SQL =select  all SMS_DPStatusDetails.DPName,SMS_DPStatusDetails.ID,SMS_DPStatusDetails.InsString1,SMS_DPStatusDetails.InsString10,SMS_DPStatusDetails.InsString2,SMS_DPStatusDetails.InsString3,SMS_DPStatusDetails.InsString4,SMS_DPStatusDetails.InsString5,SMS_DPStatusDetails.InsString6,SMS_DPStatusDetails.InsString7,SMS_DPStatusDetails.InsString8,SMS_DPStatusDetails.InsString9,SMS_DPStatusDetails.LastStatusTime,SMS_DPStatusDetails.MessageCategory,SMS_DPStatusDetails.MessageFullID,SMS_DPStatusDetails.MessageID,SMS_DPStatusDetails.MessageSeverity,SMS_DPStatusDetails.MessageState,SMS_DPStatusDetails.NALPath,SMS_DPStatusDetails.PackageID,SMS_DPStatusDetails.SiteCode,SMS_DPStatusDetails.StatusMsgID from vSMS_DPStatusDetails AS SMS_DPStatusDetails  where SMS_DPStatusDetails.ID = N'126111'