myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Creating subselect query caused console error

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Creating subselect query caused console error Page: [1]
Login
Message << Older Topic   Newer Topic >>
Creating subselect query caused console error - 10/6/2008 12:25:38 PM   
gross928


Posts: 265
Score: 12
Joined: 3/31/2004
Status: offline 		I am creating a subselect query and the orriginal query runs fine but when I try and run the other query I get the following error on the console...

[*The ConfigMgr Provider reported an error,*]

Anyone have any idea why I am getting this error?

Thanks
Gavin
Post #: 1
RE: Creating subselect query caused console error - 10/6/2008 12:30:19 PM   
jnelson993


Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		If you post the query here we can help you out better.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gross928)
Post #: 2
RE: Creating subselect query caused console error - 10/6/2008 12:50:00 PM   
gross928


Posts: 265
Score: 12
Joined: 3/31/2004
Status: offline 		Here is the orriginal query;

select distinct SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_UnknownFile on SMS_G_System_UnknownFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UnknownFile.FileName = "Adssecur.dll"

Here is the subselect Query;

select distinct SMS_R_System.NetbiosName from  SMS_R_System inner join SMS_G_System_UnknownFile on SMS_G_System_UnknownFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UnknownFile.FileName not in (select SMS_R_System.NetbiosName, SMS_G_System_UnknownFile.FileName from  SMS_R_System inner join SMS_G_System_UnknownFile on SMS_G_System_UnknownFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UnknownFile.FileName = "Adssecur.dll")

(in reply to jnelson993)
Post #: 3
RE: Creating subselect query caused console error - 10/6/2008 12:58:05 PM   
jnelson993


Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		The problem is in the subselect.  The subselect needs to return only one column, you've got 2.  But instead of just fixing that, a lot could be eliminated.  If all you need to return is the netbios name, then the join condition is unecessary, and the join in the subselect is unnecessary too. 

SELECT DISTINCT
  SMS_R_System.NetbiosName
FROM  
  SMS_R_System
WHERE  SMS_R_System.ResourceID NOT IN (SELECT
                                         SMS_G_System_UnknownFile.resourceID
                                      FROM  
                                         SMS_G_System_UnknownFile
                                      WHERE  SMS_G_System_UnknownFile.FileName = "Adssecur.dll")



_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gross928)
Post #: 4
RE: Creating subselect query caused console error - 10/6/2008 1:00:57 PM   
gross928


Posts: 265
Score: 12
Joined: 3/31/2004
Status: offline 		Thanks... that did the trick.

(in reply to jnelson993)
Post #: 5
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Creating subselect query caused console error Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.234