/build/static/layout/Breadcrumb_cap_w.png
07/18/2019 203 views

Hello, i have this SQL code for a report as below however it looks like its including Archived machines (as the total number of machines in the report is more than we have in theĀ  inventory).

We currently archive our machines after 90 days, is there anyway to change the code so it does not include archive machines?

Select

MACHINE.NAME,

MACHINE.IP,

MACHINE.USER,

SOFTWARE.DISPLAY_NAME,

SOFTWARE.DISPLAY_VERSION

From

MACHINE Right Join

MACHINE_SOFTWARE_JT On MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID Left Join

SOFTWARE On SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID

Where

(SOFTWARE.DISPLAY_NAME = "VLC")

Order By

SOFTWARE.DISPLAY_NAME,

SOFTWARE.DISPLAY_VERSION,

MACHINE.NAME

3 Comments   [ + ] Show comments

Comments

  • You might be getting duplicate machines in your report. Did you check for that?

    Also, I'm not sure what you mean by "archive our machines after 90 days."
  • Thanks you are right i am seeing duplicates, is there anyway to stop this?
    Also by Archive i mean that if the machine has not contacted the kace 1000 in 90 days it goes into Archive
    • I also think the duplicates might be coming from someone possibly having more than one version of the software installed.

      For example:

      I changed your query to look for "Microsoft Word" and it is showing me a Mac that we have that has v14.7.6 installed as well as 15.37 installed.
  • If you search for an archived device under "Inventory > Devices" does it show up?

    I think if you're talking about archiving then that is just archiving it from the "Assets" section.
    • or does it show "archive pending" for the duplicate machines when you look it up in the K1000?

There are no answers at this time