Hi All,

I'm trying to query our inv database with a web script(PHP and ADODB-ODBC
connector). So far I'm getting the machine name, MAC address and IP
Address no probs. What we need is the last user login info to go with the
previous. Here is the query I've tried so far:

SELECT foo.LastLoginName
FROM ManageWise."User" foo
cim.UnitaryComputerSystem u

Something to that affect. The query returns the error 'The COLUMN
LastLoginName does not exist in...'. I can't find an example so I
basically put it together looking at the back of the Zenworks 6.5
Administrator Handbook. Any help is appreciated.


Chuck Wheat
Senior IT Administrator II
UTC Information Technology
615 McCallie Ave, Chattanooga, TN 37403