I was creating a query to find unhealthy client in SCCM 2012 but it would hang on me before the query creation completed and had to end task on config manager to bring the console back up.
Below is the query i was trying to add
select SMS_R_System.ResourceId. SMS_R_System.ResourceType.
SMS_R_System.Client from SMS_R_System where
SMS_R_System.Client is null or SMS_R_System.Active is null
After launching the console i would see that the query i just created would appear under queries in the SCCM console but trying to run it would hang the console.
I tried to select the query and delete it through the console but it process the deleting but the query still appear under queries in sccm.
How can i delete this query?
I guess this could be done in SCCM SQL database but i am no DBA and do not know where to begin.