Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login
Site Notices
9/22/2017 12:11:25 AM
Posted: 2/8/2006 2:24:39 PM EDT
need to figure out how to run a query on some objects that have the same ID but different values.
This mostly pertains to Tivoli Endpoints that are logging in to a server. Ex. endpoint with an ID of PC1
logged in on 2/7/06 and 2/8/06. I need to return the last login time. Any help is greatly appreciated. Can also use MS access if I have to.
Link Posted: 2/10/2006 5:03:37 PM EDT
[Last Edit: 2/10/2006 5:08:20 PM EDT by david_g17]
what are the table name(s) and field names?

from the mysql prompt, can you run

mysql>show tables;

and then run

mysql> explain <insert table name here>

then post the results?

PM me if you still need help with this - i might forget about this thread, but I can likely help you out.

Tivoli is IBM backup software, right?
Top Top