KACE Product Support Question

Kace K1000 - SQL Report for Managed Installs and History

04/17/2019 230 views

Hi, we are looking to build a report which contains all of our Managed Installs, and includes the info under the "Show all History" link. We found that MI has the managed install data we are looking for, but we aren't having any luck in locating the table containing the history (ie, who made or changed the MI). Could someone clue me in if history is being stored in an identifiable table, that we can join to MI? Thanks!

0 Comments   [ + ] Show comments


All Answers


The data you are looking for is in OBJECT_HISTORY.

Answered 04/17/2019 by: chucksteel
Red Belt


That is perfect and is exactly what I was looking for! Thanks Chuck! I must have missed that table when I was looking before.

Answered 04/23/2019 by: macrospect
Senior White 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


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