Need to get custom inventory item to show up in report

Question

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

[CODE]

SELECT

MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE

FROM

ORG1.MACHINE_CUSTOM_INVENTORY

WHERE

MACHINE_CUSTOM_INVENTORY.ID = MACHINE.ID

AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = 4469

[/CODE]

Accepted Answer

I got figured out, here's what i ended up with.

[code]

SELECT MACHINE.NAME, MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE

FROM MACHINE

join MACHINE_CUSTOM_INVENTORY ON MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND (SOFTWARE_id=4469)

WHERE MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=4469

[/code]

Answer

you can use the wizard and create this report easier,  Just select the machine name and the cir for columns and run it

KACE Product Support