Hi,

New customer with the k2000 and I am trying to figure out a way to export a report from the k1000 that has all our machine names and MAC addresses in the format needed for WSNAME and the k2000 to name our machines properly. Anyone had any success with this?

Thanks!
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
I've been using this:

SELECT Concat(REPLACE(NIC.MAC, ':', '), ' = ', M.NAME) AS TRANS,
NIC.NIC
FROM MACHINE M,
MACHINE_NICS NIC
WHERE M.ID = NIC.ID
AND NIC.NIC NOT RLIKE ( 'WIFI|WIRELESS' )
Answered 05/16/2011 by: dchristian
Red Belt

Please log in to comment
0
Thanks dchristian. One more item that you could help me with is the report format. Do you customize it in any way or does that output work for you when you import it into the K2000. It seems like the K2000 only needs to get the MAC:system name.
Answered 05/16/2011 by: jgengler
Orange Senior Belt

Please log in to comment
0
You could export to CSV and just copy the trans column to the text file.
Answered 05/17/2011 by: dchristian
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity