<div>
<div class="content wysiwyg-content">
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.<br />
Below is the query i was trying to add<br />
<br />
select SMS_R_System.ResourceId. SMS_R_System.ResourceType.<wbr /><br />
SMS_R_System.Name. SMS_R_System.SMSUniqueIden<wbr />tifier.<br />
SMS_R_System.ResourceDomai<wbr />nORWorkgro<wbr />up.<br />
SMS_R_System.Client from SMS_R_System where <br />
SMS_R_System.Client is null or SMS_R_System.Active is null<br />
<br />
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.<br />
<br />
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.<br />
<br />
How can i delete this query?<br />
<br />
I guess this could be done in SCCM SQL database but i am no DBA and do not know where to begin.
</div>
</div>


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.Name. SMS_R_System.SMSUniqueIdentifier.
SMS_R_System.ResourceDomainORWorkgroup.
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.

Cannot delete a query in sccm 2012 after sccm hanged while creating the query

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.