Hi Eswar, Collection query (WQL) is the correct query.. I given a try with multiple collection sytax with WQL query, some are empty collections... not working... If i want to delete im deleting from the database On Mon, Dec 29, 2014 at 3:26 PM, Eswar Koneti <[email protected]> wrote:
> Why does your wql(collection query) has count? It willl not give you the > count of pcs in collection instead reports. > Correct the collection with right syntax? > Did you verify the collection syntax? > > Regards, > Eswar Koneti > www.eskonr.com > Sent from Mobile Device, excuse any typo's as a result. > > --- Original Message --- > > From: "Ranvir singh" <[email protected]> > Sent: December 29, 2014 10:19 PM > To: [email protected] > Subject: [mssms] SCCM Console getteing Creashed while deleting the SCCM > 2007 R3 collections > > Hi Team, > > Im getting the below error while deleting the collection from SCCM 2007 R3 > > > *An error occured in ConfigMgr. The ConfigMgr console will continue to > function, however you should save your work and restart the console. After > restarting the console, verify that your last configurations have been > applied.* > > > > > > > > System.ArgumentException: An error message must be supplied. > > Parameter name: message > > at > Microsoft.ConfigurationManagement.AdminConsole.SmsErrorDialog..ctor(String > details, String message, String caption, Icon icon) > > at > Microsoft.ConfigurationManagement.AdminConsole.SmsErrorDialog..ctor(Exception > ex, String message, String caption) > > at > Microsoft.ConfigurationManagement.AdminConsole.DeleteCollectionWizard.DeleteCollectionWizardForm.PostApply(BackgroundWorker > worker, DoWorkEventArgs e) > > at > Microsoft.ConfigurationManagement.AdminConsole.SmsWizardForm.OnFinish() > > at System.Windows.Forms.Control.OnClick(EventArgs e) > > at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) > > at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons > button, Int32 clicks) > > at System.Windows.Forms.Control.WndProc(Message& m) > > at System.Windows.Forms.ButtonBase.WndProc(Message& m) > > at System.Windows.Forms.Button.WndProc(Message& m) > > at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) > > at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, > IntPtr wparam, IntPtr lparam) > > > > Admin UI .log > > > > [ > > > > > > > > > > > > > *3][12/29/2014 2:00:45 PM] :Help topic not found in 'HelpTopicLinks.xml' > for topic ID: '7e96e251-ed74-4905-87c0-77d082a5fa4d' [3][12/29/2014 2:01:00 > PM] :Help topic not found in 'HelpTopicLinks.xml' for topic ID: > '7e96e251-ed74-4905-87c0-77d082a5fa4d' [17][12/29/2014 2:36:45 PM] > :System.Management.ManagementException\r\nGeneric failure \r\n at > System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus > errorCode) at > System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() > at > Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryResultsObject.<GetEnumerator>d__0.MoveNext()\r\nManagementException > details: instance of __ExtendedStatus { Description = > "[42000][156][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect > syntax near the keyword 'AS'."; Operation = "ExecQuery"; ParameterInfo = > "SELECT COUNT(*) FROM SMS_CM_RES_COLL_XXXcollID"; ProviderName = > "WinMgmt"; StatusCode = 2147749889 <2147749889>; }; \r\n* > > > > Any idea please!!!! > > >
