Need to get custom inventory item to show up in report
I have a custom inventory rule that pulls in monitor serial numbers. I need to create a report of this information for all workstations.
currenlty my code is
MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID
AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 4469
Answer Chosen by the Author
I got figured out, here's what i ended up with.
SELECT MACHINE.NAME, MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE
join MACHINE_CUSTOM_INVENTORY ON MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND (SOFTWARE_id=4469)
Answered 03/22/2016 by: brianfulcher15
Please log in to comment
log in to commentPlease