/build/static/layout/Breadcrumb_cap_w.png
02/21/2019 295 views

Hi,

i want to create custom field in JIRA Service Desk and integrate it with a KACE 1000 Systems Management Appliance, i want to try do it by myself, however i'm not a programmer(basic skills in Java), should it be done by API or a different way? 

0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

2

It is always a good idea to use the API (or the Reporting User for a pure SQL-Query) to get the info you need.

I would always prefer the reporting user to read the KACE DB directly if this is sufficient.
You can follow this how to (but adapt it to your own needs) for PowerBI:
https://support.quest.com/kb/231736/ 

I used PowerBI for reporting only, but the way to get info ist the same.

Do you know that KACE itself has a very good Service Desk, so maybe a move to KACE would be easier?

Answered 02/21/2019 by: Nico_K
Red Belt

  • Thank you for your respond, let's suppose i want to create a report in KACE, then i'd like to import that report to my JIRA Service Desk.

    Yes, i know KACE itself has Service Desk, but my organization use the JIRA Service Desk.

    I just want to add a custom field in JIRA and integrate it with the specific data in KACE 1000, but it i generate a report and load it to Jira, it'll not be a integrate, but a data import. If new device will be add to KACE 1000, the field will not be added automatically to JIRA tickets.
    • well, the import should not be this big issue, but in that case I really would go the reporting user way.
      I don't know Jira that much, but I would simply use a script which connects to the KACE DB to collect the info directly.
      (you can also do it via the official API, but I am more the SQL guy who feels more confident there)
      • Ok, i would create a sql request, but i've no clue how to do it, like where can i implement, if you know some sources where i can find out where and how create that simple sql request, i'm trying to solve that problem by my own. Thanks!
    • If JIRA has something that could display\run Python code, then the KACE API will be your answer...

      else... SQL
    • What type of data are you looking to get? I posted a link to my powershell API wrapper for KACE, and it might be super straight forward to do.
      • hi, thanks for link, i need to get out the field chassis type(text) - which in my organization shows desktop/laptop
      • @adrian.chyla - Since I can't seem to reply to your reply...

        This will return the info you need for a machine with ID 1234. If you want all machines, omit the -MachineID parameter and append a query parameter "paging=limit ALL"

        $query=Get-SmaMachineInventory -Server 'https://kace.example.com' -Credential (get-credential) -QueryParameters "?shaping=machine all" -MachineID 1234

        $query.Machines | Select Name, chassis_type

All Answers

1

JIRA has great Powershell support, so you might check this Powershell module for the Kace API.


https://github.com/ArtisanByteCrafter/KaceSMA


Answered 02/26/2019 by: isudothings
Purple Belt

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