/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Dynamic Date Ranges For Kace Query in Excel

10/03/2016 990 views

Hi Guys,

I'm attempting to use Excel to build dynamic reports and dashboards within Excel for use with the Kace appliance. I've created a series of queries to pull the data I want from KACE. The only bump in the road is all my queries have a set date range, so if I want to change the dataset I have to manually change the date rage for each query. My questions is, does anyone know of a way of taking date ranges from excel cells to dynamically change the date range on the query?


3 Comments   [ + ] Show comments

Comments

  • I haven't used Excel to query the K1000 but you can use date ranges in a SQL query. Do you always want to query the previous month or something similar?
  • I'd like to be able to query datasets over a series of months including this month.
    • Can you post an example of one of your queries?
  • Thanks Chuck, I think I've managed to work around it.

All Answers

0
Hi Druis - 
I was searching for posts on the forum that mention 'Dashboard', and came across yours. I am a Tableau Developer with years of experience using Kace as well. How is Excel working for you and your dynamic reports? Do you want to give your dashboard an upgrade? If so, I could help you create some actionable insights from your data so you can spend more time asking questions of the data and less time pulling data. 

Michael
Answered 01/30/2017 by: michaellynton
Yellow Belt

 
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