/build/static/layout/Breadcrumb_cap_w.png

Kace K1000 - SQL Report for Managed Installs and History

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

Answers (2)

Posted by: chucksteel 5 years ago
Red Belt
0

The data you are looking for is in OBJECT_HISTORY.

Posted by: macrospect 4 years ago
Senior White Belt
0

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

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

 
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