Report seems to be including archived machines
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
Answers (0)
Please log in to answer
Be the first to answer this question
Also, I'm not sure what you mean by "archive our machines after 90 days." - chucksteel 5 years ago
Also by Archive i mean that if the machine has not contacted the kace 1000 in 90 days it goes into Archive - markc0 5 years ago
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. - feeldamped 5 years ago
I think if you're talking about archiving then that is just archiving it from the "Assets" section. - feeldamped 5 years ago