I keep running into this, I write a simple query, and I get multiple results, like 30 entries for <client1> and 30 more for <cleints> and so on, giving thousands of results when there are only 400 machines in the domain. Can someone tell me why SMS is doing this, and how I can make it so only one client name is returned per machine??

thanks in advance
0 Comments   [ + ] Show Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


Maybe you're linking to a table that has multiple entries? In SMS 2.0, this used to happen to me I think if I used the IP Address Table and System Resource (I think those are the right names) - since the IP table might have had multiple entries for a client. Maybe if you post your query we can help?
Answered 02/14/2005 by: usachrisk
Purple Belt

Please log in to comment
Can you give some info on the query you're running?
Answered 02/14/2005 by: Bladerun
Green Belt

Please log in to comment
Of coarse, fisrt thing monday morning, I can't break it. When I get a good example, I will post it today. Thanks :)
Answered 02/14/2005 by: blankmonkey
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity