We are tring to track down all of the laptops that have been deployed over the years in the company that have 3g cards built into them.

With the MANY different images that have been used over time, the only common variable i can find is a Mini-Card listed in the Network Interfaces.

 

No common software or services running.

 

Is it possible to create a label or run a sql search to find all machines with 'Mini-Card' listed in the Network Interfaces tab?

5 Comments   [ + ] Show Comments

Comments

  • You can as there is a MACHINE_NICS table in the DB. You just have to try the wizard or connect and write your own SQL statement.
  • Here is my SQL search: SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((MACHINE.NIC like '%mini%'))

    This is the error i get: Please correct the following errors:

    mysql error: [1054: Unknown column 'MACHINE.NIC' in 'where clause'] in EXECUTE( "SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE ((MACHINE.NIC like '%mini%')) ")

    Any ideas?
  • We are on 5.5 btw. And this is the information I'm needing to gather from the inventory page / network interfaces:

    Network Interfaces (2)
    1) Dw1501 Wireless-n Wlan Half-mini Card:

    I'm needing to find all the laptops that contain 'mini' anywhere in the network interface description.
  • Try. just change the LIKE statement.

    SELECT
    MACHINE.`NAME` AS System,
    MACHINE_NICS.NIC AS Nic
    FROM
    MACHINE
    RIGHT OUTER JOIN MACHINE_NICS ON MACHINE_NICS.ID = MACHINE.ID
    WHERE
    MACHINE_NICS.NIC LIKE '%Miniport%'
  • No go on that one either. Its pulling random pcs. Even after changing the LIKE to '%mini%'
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share