Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

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:

select distinct
SMS_R_System.Name,
SMS_R_System.ResourceId,
SMS_R_System.ResourceType,
SMS_R_System.OperatingSystemNameandVersion,
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,
SMS_R_System.ResourceId,
SMS_R_System.ResourceType,
SMS_R_System.OperatingSystemNameandVersion,
SMS_R_System.ClientType,
SMS_G_System_PC_BIOS.BIOSVersion
from SMS_R_System
inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Chriss shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base