Example of Report to Export from K1000 to K2000 for WSNAME
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!
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
Answers (3)
Please log in to answer
Posted by:
dchristian
12 years ago
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' )
Posted by:
jgengler
12 years ago
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.
Posted by:
dchristian
12 years ago
You could export to CSV and just copy the trans column to the text file.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.