ITNinja

Much like my other question, I suppose I am on my own here? In the instance that someone reads this but not the other, KACE support has failed as well by not being present for chat and not responding to email. So is there some other location or forum where I can go to get answers?

Can you paste the SQL from your report in here so we can have a look?

Sure!

select *, MACHINE.NAME as MNAME, MACHINE_DISKS.NAME as DNAME from (MACHINE,MACHINE_DISKS, MACHINE_NICS)
where MACHINE.ID = MACHINE_DISKS.ID and MACHINE.ID = MACHINE_NICS.ID
order by MNAME

Thanks for responding, I was afraid I wasn't going to get anything since it had been a couple days. Is this just not a very active place? The amount of posts are something of an indicator but the views are high.

What are you trying to get out of this report? If I run it in my SQL editor, I get a lot of data, which seems to be more than your report. have you tried to execute this in MySQL Workbench to test the results?

I know that the version you are on is older now, with a reporting engine (JasperSoft) that is deprecated. If this error keeps appearing, you may want to try pasting it into a new SQL report to get your data out.

also, there is plenty of activity here, but your original post didn't really give much to go with. The more you provide, the more likely to get a quick, quality response.

Sorry about not giving enough info, I thought the error and title would've sufficed for an idea of what was happening. I believe this is one of the built-in reports, but it is supposed to show our inventory with all the details. When you say old version, do you mean the K1000 version? The guys in charge of bringing the box up to 5.3 think they will have it up before the month is out. Would that alleviate some of the issues?

I know this is going to be a pain and seem backwards but I don't know any SQL. I was brought on as an intern to try and learn the K1000 system so that I can train them on it. They want to be able to set up some custom reports though and have people familiar with SQL that I haven't met yet but found out about today. Should I run it by them? I've only spent about 15 hours with this box. Most of that has been reading whitepapers though.

Ok, so I had a look at the report on my system, and it is there, even on 5.3. Are you trying to get data out in a format other than csv?

I would open a support ticket, and they will be able to help you out. Chat is good, but there is no follow-up until your spot in the queue is addressed.

You can do this from any page in the K1000 console at the bottom right corner.

HTH

I think it fails even trying to get it out in CSV but I can't directly recall if I tried CSV. I think I have but I've mainly been doing PDF, TXT, and HTML. I've only used CSV for a handful of things. I suppose I will create a ticket then. Thanks for the help though, I appreciate you trying to direct me to a solution.