Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
BCM
User Panel

Site Notices
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
[#1]
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?
Close Join Our Mail List to Stay Up To Date! Win a FREE Membership!

Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!

You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.


By signing up you agree to our User Agreement. *Must have a registered ARFCOM account to win.
Top Top