mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%W' at line 2] in EXECUTE(
"SELECT GROUP_CONCAT(DISTINCT IF(LABEL.NAME NOT LIKE 'HDN_LABEL_%', LABEL.NAME, NULL) SEPARATOR '\n') AS LABEL_NAME, OS_NAME, USER_LOGGED  FROM MACHINE  LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID)  LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID) WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%'))  GROUP BY MACHINE.ID ORDER BY LABEL_NAME, OS_NAME, USER_LOGGED,
SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%')) GROUP BY TOTAL RESULT LIMIT 0")

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity
Share SNMP OID and MIB Information
It’s easy to add custom SNMP OID GETs to your Dell KACE K1000 inventory, but where do you find the exact OIDs you need for a specific device? This is the place to share the OIDs and MIBs you have – and to request the ones you need.

Share