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 SMS_R_System.
Often it is needed to select attributes from other tables like SMS_G_System.
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 SMS_R_System in case you adress more then one table.
The check could be, if required attributes from SMS_R_System 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:
SMS_R_System.ClientType from SMS_R_System
If i add an additional field like SMS_G_System_PC_BIOS.BIOSVersion there is no functionality in GUI any more:
select distinct SMS_R_System.Name,
inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId