Whenever I run any ePO reports I see multiple entries of every client. Looks like when I imported data from MSDE to SQL 2000, somehow it created 4 entries for each client connected to the ePO. Does anyone know how to clean the tables in SQL 2000 and leave only unique entry from every client connected to the ePO server.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple entries in ePO reports
- Thread starter jsehmi
- Start date
VictorySabre
Technical User
You may want to give McAfee support a call. They have several SQL scripts that can be used to remove those duplicate entries from the database.
- Status
Similar threads
- Locked
- Question
- Locked
- Question