How do I export the contents of a Smart Label to a .csv/Excel file?
I have a machine Smart Label whose contents I need to pass on to several other people to review and make notations. I'd like to provide this list to them in such a way that they can use Excel.
However, I cannot find a way to export the contents of a machine Smart Label to any format. I looked at the Label section of the K1100 itself and also tried to find a report or create a new one that would do this, but I can't find a way to do it, and a Google search has yielded no results either.
Is this even possible? How can I do it?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dugullett
11 years ago
The quickest way would be to go to the inventory screen. Select your label under "view by" (upper right hand). After that "choose action" export to csv.
Comments:
-
I actually tried that already, and even though I checked the label I wanted, when I exported to .csv, I got a .csv that listed of all my labels, not the content of the one label I wanted. - KFox 11 years ago
-
Here's a sample query you can run. I'm not sure of all the info the "other people" need.
SELECT M.NAME, IP, MAC, USER_LOGGED
FROM MACHINE M
LEFT JOIN MACHINE_LABEL_JT MLJT ON M.ID = MLJT.MACHINE_ID
LEFT JOIN LABEL L ON L.ID = MLJT.LABEL_ID
WHERE L.NAME = '<LABEL NAME>' - dugullett 11 years ago
-
Dugullett, thanks for the query.
I actually had someone in our Application Development department run a query yesterday (after I made my original post) to see if he could generate the .csv I needed and he was successful. I asked him today and he said that your query matched his rather closely with some differences.
However, as someone who is not a developer in any way and has zero knowledge of SQL (I don't even know what running a query entails and what I would use to perform that task) I suppose I'm looking for some way to perform this kind of task with something that's built into the K1000.
Your code will be helpful to others who do know SQL. I'm just not one of them. ;) I find it hard to believe there's no way to do this with the K1000's built in tools, but I could certainly be wrong. And if there isn't, then it's something I can add to the KACE feature request site.
Thanks again. - KFox 11 years ago-
There is a built in GUI that gets even better in 5.4. I rarely use that though. You can select the fields you want to report on, and then select the label(s) you want it ran on. I suggest taking a look at some of these for more info.
Americas KKE - Reporting 101
https://kace.webex.com/kace/lsr.php?AT=pb&SP=TC&rID=66363507&rKey=5b32a739e943f766&act=pb
http://www.kace.com/support/resources/kb/article/kace-kontinuing-education-k1000-and-k2000-recordings
You can also to the query above and navigate to Reporting>Choose Action>Add New SQL Report. After giving it a title, description, and category you can paste in my above query into the "SQL Select Statement". I would say you've lucked out if you have someone who knows it. You can always post here what you are needing, and you'll usually get a fast answer. - dugullett 11 years ago-
Since you have someone who knows SQL have them download the MYSQL tools. http://dev.mysql.com/downloads/tools/workbench/5.2.html
Username: R1 (with orgs)
Password: box747
This will tell you how to change it.
http://www.kace.com/support/resources/kb/article/how-to-change-the-password-for-read-only-database - dugullett 11 years ago -
Thanks for the links. Unfortunately, none of the recorded KACE training sessions have any audio for me, so they have been pretty useless to me without the narration as their PowerPoint slides are far too basic. I don't know if it's something on my system, but I have audio for everything else.
I am running 5.4, but not sure of the GUI you're referring to. I went to their supposedly new reporting tool and wizard, but became lost. - KFox 11 years ago -
I call it GUI, but yes it's the reporting wizard. I would try reinstalling the Webex piece that's installed with it. It may be corrupt. Those videos will help you with the reporting wizard. Either that, or just post what all info you are needing and I can create the report for you. - dugullett 11 years ago
