Inventory Queries

[sherreeq]

How do i set up a query that will return the endpoint name, computer name, description, mac, and ip number?

 

[IN70043]

Try this one. It shows a lot of info and 2 entries, 1 for MAC addr, and other for TCPIP addr.

select unique(C.HARDWARE_SYSTEM_ID),C.TME_OBJECT_LABEL,
C.COMPUTER_ALIAS ,C.BOOTED_OS_NAME ,C.BOOTED_OS_VERSION ,
M.PHYSICAL_MEMORY_KB ,M.PAGING_SPACE_KB ,
B.BIOS_MODEL ,N.NETWORK_NODE_ADDRESS,N.NETWORK_PROTOCOL ,
P.PROCESSOR_MODEL, P.PROCESSOR_SPEED,C.COMPUTER_SCANTIME
from COMPUTER_SYSTEM C, COMPUTER_SYSTEM_MEMORY M,
INSTALLED_BIOS B, NETWORK_NODE N,
PROCESSOR P, installed_processor I
WHERE M.HARDWARE_SYSTEM_ID = C.HARDWARE_SYSTEM_ID
and B.HARDWARE_SYSTEM_ID = C.HARDWARE_SYSTEM_ID
and N.HARDWARE_SYSTEM_ID = C.HARDWARE_SYSTEM_ID
and I.HARDWARE_SYSTEM_ID = C.HARDWARE_SYSTEM_ID
and P.PROCESSOR_ID = I.PROCESSOR_ID
order by C.TME_OBJECT_LABEL

Regards

 

[mmich]

We found someone inhouse that is savay with MSAccess. They made an ODBC connection to our Inventory MSSQL database and created querries that produce easy to read gui results. The end results are an application that mutliple folks can use to get inventory information without having the Tivoli Desktop installed. It is a nice solution to fix Tivoli's shortfall in this area.