Resource explorer launch from queries
In Configuration Manager Console the Resource Explorer cannot be launched from queries results in the Monitoring -> Queries if you built a query that not only selects attributes from SMSRSystem.
Often it is needed to select attributes from other tables like SMSGSystem.
If you select only one attribute from another table the GUI declines to launch Resource Explorer or other functionalities from the right click menu.
Maybe this restriction in the launch of Ressource Explorer from queries can be dropped.
It seems to me that the tables get always resolved to SMSRSystem in case you adress more then one table.
The check could be, if required attributes from SMSRSystem are available needed to drill down to the Object, the launch of resource explorer should be possible.
This is already implemented, the additional lock in case you join a table prevents the launch.
The Attributes needed for all functions seems to be:
SMSRSystem.ClientType from SMSRSystem
If i add an additional field like SMSGSystemPCBIOS.BIOSVersion there is no functionality in GUI any more:
select distinct SMSRSystem.Name,
inner join SMSGSystemPCBIOS on SMSGSystemPCBIOS.ResourceID = SMSRSystem.ResourceId