Integrate KACE 1000 with JIRA Service Desk
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?
Answers (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?
Comments:
-
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. - adrian.chyla 5 years ago-
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) - Nico_K 5 years ago-
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! - adrian.chyla 5 years ago
-
If JIRA has something that could display\run Python code, then the KACE API will be your answer...
else... SQL - Channeler 5 years ago -
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. - isudothings 5 years ago
-
hi, thanks for link, i need to get out the field chassis type(text) - which in my organization shows desktop/laptop - adrian.chyla 5 years ago
-
@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 - isudothings 5 years ago
JIRA has great Powershell support, so you might check this Powershell module for the Kace API.
https://github.com/ArtisanByteCrafter/KaceSMA
