Comments

• 

  • nshah
  • 3 years ago

  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.
• 

  • jharrell
  • 3 years ago

  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?
• 

  • jharrell
  • 3 years ago
  • last edited 3 years ago

  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.
• 

  • nshah
  • 3 years ago

  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%'
• 

  • jharrell
  • 3 years ago

  No go on that one either. Its pulling random pcs. Even after changing the LIKE to '%mini%'