So Many Extra Records

When I read the Workstation object via ODBC, it returns about 69,000
records. I only have about 380 workstations. Why are there so many records
with repeated information? Is there a way to Fix or mitigate this?

Here is what I have done:
1. DTS a ‘select * from workstation’ into a MS SQL table that allows nulls
in every field.
2. Query that MS SQL table selecting only the fields I need and using a
group by so I can get only one record per workstation.

This works, but is more complex than I would like.

-Tom

Hi

For every multivalued attribute that you query, you get a separate record.
Because of this, the multivalued attributes are presented by the odbc driver
with two options, either the attribute or the attribute_s.  The latter will
provide a comma delimited list of attribute values for that field, rather
than multiple records.

For example,

SELECT Workstation.CN_S, Workstation.Description_S
FROM Workstation Workstation

instead of

SELECT Workstation.CN, Workstation.Description
FROM Workstation Workstation

See the documentation at
http://developer.novell.com/ndk/doc/odbcrw/odbc_enu/data/bslljkl.html for
concatenating rows.

Further, you may wish to create a user defined table to limit yourself to
specific attributes, due to the large number of aux classes used by Zen.

See http://developer.novell.com/ndk/doc/odbcrw/odbc_enu/data/bsm0gy1.html

Thank you
Susan