Qlik Automation techniques required

[RickyK]

Hello All,

Greetings for the day!!

We are planning to do some automation in Qlik.

But not sure what are the automation techniques are available for Qlikview/Qlik sense.

Really appreciate if you share some guidance around this and will be very helpful to me.

Regards,

RickyK

[Chip_Matejowsky · Accepted solution]

Hello @RickyK,

Hey can you provide more clarity on what functionality you are wanting to automate?
Both QlikView and Qlik Sense have robust APIs that you can leverage:

• QlikView APIs
• Qlik Sense APIs

Suggest that you also reach out to your Qlik account manager to have a discussion about your business requirements. They may have resources available to help.

Best Regards

[RickyK]

Thanks for your suggestion @Chip_Matejowsky 

We have some requirements like below:

1. In our organisation we are using Named CALs for QlikView, is there any way to automate this to determine all users who have not used their CALs for the last 90 days and automatically reclaim their licenses?

2. Weekly restart of Qlik servers automatically for that how do we automate(by using power shell script) if yes, what is that script?

3. We need to get the mail alerts when Qlik servers gets down.

4. Need to get the mail alerts when storage is full or above 80%. And creates the INC to look for that issue .

Please let me know if the above requirement is not clear.

Regards,

RickyK

[Chip_Matejowsky · Accepted solution]

Hi @RickyK,

1. Refer to article QMS API remove a Named CAL. This document is provided as is and you may have to modify the scripts in order to work in your environments. The customized script is not supported by Qlik Support, so if you need direct assistance, contact your account manager who can schedule an engagement with Qlik Professional Services. Be sure that you thoroughly test the QMS API scripts in a lower lever environment before implementing in your production environment. 
2. This can be done via a Windows operating system process, such as Task Scheduler, or via PowerShell and would occur wholly outside of Qlik. Your internal IT team should be able to help you with this task.  I Googled "PowerShell script to restart server" and found the below hits:
   1. https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.management/restart-computer...
   2. https://adamtheautomator.com/powershell-to-restart-computers/
   3. https://xpertstec.com/how-to-schedule-windows-server-reboot-automatically/
3. This can again be done via Task Scheduler outside of Qlik, so suggest you talk with your internal IT team. I Googled "Windows task scheduler email service stopped" and found the following hit: https://clusteringformeremortals.com/2018/10/29/step-by-step-how-to-trigger-an-email-alert-when-a-wi...
4. Another instance that would need to be done outside of Qlik, so work with your internal IT team. I Googled "email alert on storage capacity" and found the following hit: https://www.linuxjournal.com/content/tech-tip-send-email-alert-when-your-disk-space-gets-low

Best Regards

[RickyK]

Thanks @Chip_Matejowsky 

This is really helpful. Thanks once again🙂