Podpowiedzcie proszę ja z bazy wyciąnąc oprócz n/w jeszcze Nazwa komputera, IP, MAC
przydało by się: Klient, Informacja o połączeniu sieciowym
select lastname, c.name, address, zip, city, email, c.id, pin, count(n.id), n.name, passwd, cc.invoice, ccc.phone, cccc.customergroupid FROM customers c LEFT JOIN nodes n ON n.ownerid = c.id LEFT OUTER JOIN assignments AS cc ON cc.customerid = c.id LEFT OUTER JOIN customercontacts AS ccc ON ccc.customerid = c.id LEFT OUTER JOIN customerassignments AS cccc ON cccc.customerid = c.id
WHERE deleted=0 GROUP BY c.id
Pozdrawiam *DeCha*
select lastname, c.name, address, zip, city, email, c.id, pin, count(n.id), n.name, inet_ntoa(ipaddr), m.mac, passwd, cc.invoice, ccc.phone, cccc.customergroupid FROM customers c LEFT JOIN nodes n ON n.ownerid = c.id LEFT OUTER JOIN assignments AS cc ON cc.customerid = c.id LEFT OUTER JOIN customercontacts AS ccc ON ccc.customerid = c.id LEFT OUTER JOIN customerassignments AS cccc ON cccc.customerid = c.id LEFT JOIN macs m ON m.nodeid = n.id WHERE deleted=0 GROUP BY c.id limit 1;
W dniu 03/10/18 o 17:54, Dominik Chenczke pisze:
select lastname, c.name, address, zip, city, email, c.id, pin, count(n.id), n.name, passwd, cc.invoice, ccc.phone, cccc.customergroupid FROM customers c LEFT JOIN nodes n ON n.ownerid = c.id LEFT OUTER JOIN assignments AS cc ON cc.customerid = c.id LEFT OUTER JOIN customercontacts AS ccc ON ccc.customerid = c.id LEFT OUTER JOIN customerassignments AS cccc ON cccc.customerid = c.id
WHERE deleted=0 GROUP BY c.id
uczestnicy (3)
-
Dominik Chenczke -
Dominik Chenczke -
Kamil Kordas