/build/static/layout/Breadcrumb_cap_w.png

Query Returns Mulitple results

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
Asked 19 years ago 1635 views
0 Comments   [ + ] Show comments

Answers (3)

Posted by: usachrisk 19 years ago
Purple Belt
0
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?
Posted by: Bladerun 19 years ago
Green Belt
0
Can you give some info on the query you're running?
Posted by: blankmonkey 19 years ago
Senior Yellow Belt
0
Of coarse, fisrt thing monday morning, I can't break it. When I get a good example, I will post it today. Thanks :)
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ