/build/static/layout/Breadcrumb_cap_w.png

KB Article DB Location

I know that the KB entries in the DB change throughout each environment, but could anyone give me any pointers on how to find it in mine? I have searched through just about every table in our DB and can't find any reference to KB Articles. Any help with this would be much appreciated! 


0 Comments   [ + ] Show comments

Answers (3)

Posted by: jverbosk 11 years ago
Red Belt
2

I believe the attachments are stored with the related KB articles and there is no way to directly access them without database modifications done by Kace (which is not recommended).

If your aim is to delete KB article attachments, you can either delete the KB article in question completely, or upload a smaller attachment (to blow away the larger attachment).

John


Comments:
  • Thanks John. I am actually looking into importing KB articles into the KACE HD via CSV files. I do not think that any of our current HD articles have any attachments that need to be pulled in, so this should be ok. I just knew that there is a HD_ATTACHMENT table so I wondered if I was just missing something on the KB Article side. - horstj 11 years ago
Posted by: jverbosk 11 years ago
Red Belt
1

If your goal is to import KB articles from CSVs, this might help (an answer I gave for another question):

Here's the KACE KB on importing tickets using assets (which I used to import 21,000 tickets from an Excel file), possibly something you could tweak to import your KB articles:

https://www.kace.com/support/resources/kb/article/How-To-Use-Ticket-Rules-To-Import-Tickets-From

The columns in the CSV file match up to the columns in the HD_TICKET table, so if you use the MySQL query browser you could tweak it so that you use the ADVISORY table (and all of its columns) instead (sorry, not in front of my K1000 now so I'm just going by what you said).  Leaving column entries themselves blank is not an issue (I know I didn't have data for every column in the HD_TICKET table), but every column needs to be present.  If you need help setting up or using the MySQL Query Browser so you can see the column names, this blog should help:

http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

As for transferring the data from Assets into KB Articles, I would create the pre-defined ticket rule (step 4 in the KB), then go into the SQL code (it will be listed in the Custom Ticket Rules section in the Queue configuration) and see specifically what it's targeting.  It may just require mapping the columns between the Assets and ADVISORY tables.

That said, if you aren't comfortable with the MySQL code, it might require a professional services package (as stated in the KB), but at least this should get you started so you can make that determination.

If nothing else, post how far you get (if you want to give it a shot yourself) and I'll take a look at the custom ticket rules I imported to do the ticket imports to see if it's something I can help with (once I'm in front of my K1000).

John

Posted by: horstj 11 years ago
Brown Belt
1

I actually just found it to be in the ADVISORY table of the DB, but still have not found the attachment location. Does anyone know where this might be?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ